Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer identifier for each association row.”,“why”:“Provides a stable primary key for referencing or deleting a specific link.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:18.077714927+00:00”} |
||||
| card_id | int4 | 10 | null |
|
|
{“what”:“Integer identifier of the card being labeled.”,“why”:“Determines which card the label is applied to; without it, the association is meaningless.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:18.151631214+00:00”} |
|||||
| label_id | int4 | 10 | null |
|
|
{“what”:“Integer identifier of the label attached to the card.”,“why”:“Identifies which label is applied; without it, the card’s label set is incomplete.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:18.163124146+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| card_label_pkey | Primary key | Asc | id |
| idx_card_label_card_id | Performance | Asc | card_id |
| idx_card_label_label_id | Performance | Asc | label_id |
| unique_card_label_card_id_label_id | Must be unique | Asc/Asc | card_id + label_id |