symlink_registry


Description

{“what”:“Central registry of symlink entries with source/target paths, categories, and status.”,“why”:“Without it, symlink mappings and their validation state would be unknown, breaking link management.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:46.662701772+00:00”}

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

Relationships