Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique identifier for each dependency record.”,“why”:“Provides a stable key for referencing and updating a specific dependency.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:24.343550832+00:00”} |
|
| from_entity_type | varchar | 20 | null |
|
|
{“what”:“Type of the source entity (e.g., ‘table’, ‘view’) for polymorphic lookup.”,“why”:“Distinguishes which entity table to join with from_entity_id, since dependencies span multiple types.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:24.356146652+00:00”} |
||
| from_entity_id | int4 | 10 | null |
|
|
{“what”:“Identifier of the source entity within its type’s table.”,“why”:“Together with from_entity_type, uniquely identifies the source; without it the dependency has no origin.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:24.376727918+00:00”} |
||
| to_entity_type | varchar | 20 | null |
|
|
{“what”:“Type of the target entity (e.g., ‘table’, ‘view’) for polymorphic lookup.”,“why”:“Distinguishes which entity table to join with to_entity_id, since dependencies span multiple types.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:24.390521654+00:00”} |
||
| to_entity_id | int4 | 10 | null |
|
|
{“what”:“Identifier of the target entity within its type’s table.”,“why”:“Together with to_entity_type, uniquely identifies the target; without it the dependency has no destination.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:24.402328219+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| dependency_pkey | Primary key | Asc | id |
| idx_dependency_from | Performance | Asc/Asc | from_entity_type + from_entity_id |
| idx_dependency_to | Performance | Asc/Asc | to_entity_type + to_entity_id |
| idx_unique_dependency | Must be unique | Asc/Asc/Asc/Asc | from_entity_type + from_entity_id + to_entity_type + to_entity_id |