Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer identifier for each library record.”,“why”:“Serves as primary key for stable references and joins.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:23.740502748+00:00”} |
|
| path | varchar | 254 | null |
|
|
{“what”:“Filesystem or import path of the library, e.g., ‘os/path.py’.”,“why”:“Uniquely identifies the library; without it, duplicates and lookups fail.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:23.755828471+00:00”} |
||
| source | text | 2147483647 | √ | null |
|
|
{“what”:“Full source code of the library as text; null if not stored.”,“why”:“Enables code inspection and analysis; absence means content unavailable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:23.774296018+00:00”} |
|
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when the record was inserted, in UTC.”,“why”:“Shows when library was added; needed for audit and ordering.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:23.794475340+00:00”} |
||
| updated_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp of last update to the record, in UTC.”,“why”:“Detects stale entries and tracks modifications over time.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:23.811569801+00:00”} |
||
| entity_id | bpchar | 21 | √ | null |
|
|
{“what”:“Single-character code classifying the library entity type.”,“why”:“Distinguishes entity kinds (e.g., module, package) for filtering.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:23.842801495+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pk_python_library | Primary key | Asc | id |
| idx_python_library_entity_id | Performance | Asc | entity_id |
| uk_python_library_path | Must be unique | Asc | path |
| unique_python_library_entity_id | Must be unique | Asc | entity_id |