parameter_card


Description

{“what”:“Links a card to a specific parameter of a polymorphic object.”,“why”:“Without it, the mapping between cards and object parameters is missing, so card content and parameter usage cannot be determined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:05.421165475+00:00”}

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
report_card.id fk_parameter_card_ref_card_id C

{“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
metabot_conversation.id Implied Constraint R

{“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

Relationships