Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('style_fingerprints_id_seq'::regclass) |
|
|
{“what”:“Unique numeric identifier for each fingerprint row.”,“why”:“Without it, rows cannot be uniquely referenced for updates or deletes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:05.325318620+00:00”} |
|
| collection_name | text | 2147483647 | null |
|
|
{“what”:“The collection this fingerprint belongs to.”,“why”:“Without it, fingerprints cannot be associated with a collection, making style detection impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:05.341206512+00:00”} |
||
| label | text | 2147483647 | ''::text |
|
|
{“what”:“Optional label to differentiate multiple fingerprints per collection.”,“why”:“Without it, multiple fingerprints for the same collection would be indistinguishable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:05.372323263+00:00”} |
||
| fingerprint | text | 2147483647 | null |
|
|
{“what”:“The style fingerprint string; exact format not specified.”,“why”:“Without it, there is no data to match against for style detection.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:05.392039483+00:00”} |
||
| created_at | text | 2147483647 | now() |
|
|
{“what”:“Timestamp of row creation, stored as text.”,“why”:“Without it, there is no record of when the fingerprint was added, complicating audits.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:54:05.422578583+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| style_fingerprints_pkey | Primary key | Asc | id |
| idx_sfp_collection | Performance | Asc | collection_name |