assignment_insights


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
uuid text 2147483647 √ null
shipment_id int8 19 √ null
shipments.id assignment_insights_shipment_id_fkey R
diagnostic_json json 2147483647 √ null
llm_response_json json 2147483647 √ null
summary text 2147483647 √ null
primary_reason text 2147483647 √ null
status text 2147483647 √ null
provider text 2147483647 √ null
model text 2147483647 √ null
error_message text 2147483647 √ null
created_at timestamptz 35,6 √ null
updated_at timestamptz 35,6 √ null
tenant_id int4 10 null
tenants.id assignment_insights_tenant_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
idx_269332_assignment_insights_pkey Primary key Asc id
idx_269332_ix_assignment_insights_created_at Performance Asc created_at
idx_269332_ix_assignment_insights_model Performance Asc model
idx_269332_ix_assignment_insights_provider Performance Asc provider
idx_269332_ix_assignment_insights_shipment_id Performance Asc shipment_id
idx_269332_ix_assignment_insights_status Performance Asc status
idx_269332_ix_assignment_insights_updated_at Performance Asc updated_at
idx_269332_ix_assignment_insights_uuid Must be unique Asc uuid
ix_assignment_insights_tenant_id Performance Asc tenant_id

Relationships

Close relationships within degrees of separation