Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | √ | null |
|
|
{“what”:“Unique bigint identifier for each symlink entry.”,“why”:“Without it, rows cannot be uniquely referenced for updates or deletion.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:46.687106833+00:00”} |
|
| source_path | text | 2147483647 | null |
|
|
{“what”:“Path string of the symlink’s source location.”,“why”:“Without it, the symlink’s origin is unknown, so the mapping cannot be created or verified.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:46.710555183+00:00”} |
||
| target_path | text | 2147483647 | null |
|
|
{“what”:“Path string that the symlink points to.”,“why”:“Without it, the destination is unknown, making the mapping incomplete.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:46.733131362+00:00”} |
||
| primary_category | text | 2147483647 | null |
|
|
{“what”:“High-level classification label for the symlink’s purpose.”,“why”:“Without it, symlinks cannot be grouped or filtered by main function.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:46.746694383+00:00”} |
||
| link_category | text | 2147483647 | null |
|
|
{“what”:“Secondary classification refining the primary category.”,“why”:“Without it, distinctions between symlink types within a primary category are lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:46.762351820+00:00”} |
||
| score | float8 | 17,17 | null |
|
|
{“what”:“Floating-point rating of link reliability or usage priority.”,“why”:“Without it, ranking or prioritizing symlinks for validation or cleanup is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:46.781958240+00:00”} |
||
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when the symlink entry was inserted.”,“why”:“Without it, the age of the entry is unknown, hindering audit or cleanup decisions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:46.796148272+00:00”} |
||
| last_validated | timestamptz | 35,6 | √ | null |
|
|
{“what”:“Timestamp of the most recent successful validation of the symlink.”,“why”:“Without it, it’s unknown whether the symlink has ever been checked, so stale links cannot be identified.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:46.823562527+00:00”} |
|
| status | text | 2147483647 | 'active'::text |
|
|
{“what”:“Lifecycle state of the entry, defaulting to ‘active’.”,“why”:“Without it, broken or deprecated symlinks cannot be distinguished from valid ones.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:46.848945937+00:00”} |
||
| kind | text | 2147483647 | 'source-pointer'::text |
|
|
{“what”:“Categorization of the link direction or usage, defaulting to ‘source-pointer’.”,“why”:“Without it, the role of the symlink in the system is ambiguous, affecting validation logic.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:46.859746648+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| symlink_registry_pkey | Primary key | Asc | id |
| idx_symlink_category | Performance | Asc | link_category |
| idx_symlink_kind | Performance | Asc | kind |
| idx_symlink_status | Performance | Asc | status |
| idx_symlink_target | Performance | Asc | target_path |
| symlink_registry_source_path_key | Must be unique | Asc | source_path |