Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('style_collections_id_seq'::regclass) |
|
|
{“what”:“Unique integer identifier for the collection; auto-generated from sequence.”,“why”:“Without it, collections cannot be uniquely referenced in foreign keys or updates.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:53:56.768674338+00:00”} |
|
| name | text | 2147483647 | null |
|
|
{“what”:“Human-readable label for the collection; used for display and identification.”,“why”:“Without it, collections have no user-facing identifier, making them indistinguishable in lists.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:53:56.782859616+00:00”} |
||
| description | text | 2147483647 | ''::text |
|
|
{“what”:“Free-form text explaining the collection’s purpose or contents; defaults to empty string.”,“why”:“Without it, the collection’s purpose is undocumented, leading to misuse or confusion.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:53:56.799137918+00:00”} |
||
| created_at | text | 2147483647 | now() |
|
|
{“what”:“Creation time of the collection, stored as text; defaults to current timestamp.”,“why”:“Without it, the collection’s age is unknown, preventing time-based sorting or auditing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:53:56.815539246+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| style_collections_pkey | Primary key | Asc | id |
| style_collections_name_key | Must be unique | Asc | name |