Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Surrogate primary key; unique integer per row.”,“why”:“Without it, rows cannot be uniquely identified for updates or deletes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:05.442123212+00:00”} |
||||
| updated_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp of last row modification, timezone-aware, defaults to now.”,“why”:“Without it, there is no record of when the association was last changed, breaking audit or sync logic.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:05.456578757+00:00”} |
|||||
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp of row creation, timezone-aware, defaults to now.”,“why”:“Without it, the creation time of the association is unknown, breaking ordering or retention policies.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:05.474939292+00:00”} |
|||||
| card_id | int4 | 10 | null |
|
|
{“what”:“Foreign key to the card table; identifies the card in this association.”,“why”:“Without it, the card side of the relationship is unknown, so you cannot list parameters for a card.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:05.502464047+00:00”} |
|||||
| parameterized_object_type | varchar | 32 | null |
|
|
{“what”:“Polymorphic type name of the associated object (e.g., ‘Product’, ‘User’).”,“why”:“Without it, the object type is ambiguous, so the object cannot be resolved from the ID alone.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:05.574409803+00:00”} |
|||||
| parameterized_object_id | int4 | 10 | null |
|
|
{“what”:“Primary key value of the associated object within its type.”,“why”:“Without it, the specific object is unknown, so the parameter cannot be attached to a concrete entity.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:05.602308166+00:00”} |
|||||
| parameter_id | varchar | 36 | null |
|
|
{“what”:“String identifier of the parameter on the object (e.g., ‘color’, ‘size’).”,“why”:“Without it, the specific parameter is unknown, so the card cannot be linked to a particular attribute.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:05.650929972+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| parameter_card_pkey | Primary key | Asc | id |
| idx_parameter_card_card_id | Performance | Asc | card_id |
| idx_parameter_card_parameterized_object_id | Performance | Asc | parameterized_object_id |
| unique_parameterized_object_card_parameter | Must be unique | Asc/Asc/Asc | parameterized_object_id + parameterized_object_type + parameter_id |