dir_schema


Columns

Column Type Size Nulls Auto Default Children Parents Comments
device text 2147483647 null

{“what”:“Device identifier (hostname or ID) that owns the directory.”,“why”:“Uniquely identifies which machine’s directory schema this row describes; without it, rows from different devices collide.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:51.688815505+00:00”}

dir_path text 2147483647 null

{“what”:“Absolute or relative path of the directory on the device.”,“why”:“Together with device, uniquely identifies the directory; without it, multiple schemas for same path on same device would be ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:51.707699010+00:00”}

purpose text 2147483647 √ null

{“what”:“Intended use of the directory, e.g., logs, cache, data.”,“why”:“Documents why the directory exists; without it, future maintainers cannot infer the directory’s role.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:51.732979778+00:00”}

allowed_kinds _text 2147483647 √ null

{“what”:“List of allowed file kinds or extensions, e.g., {‘log’,‘txt’}.”,“why”:“Enforces which file types may reside here; without it, any file type could be placed, breaking validation.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:51.751976281+00:00”}

subdir_convention text 2147483647 √ null

{“what”:“Naming rule for subdirectories, e.g., date-based YYYY/MM/DD.”,“why”:“Defines expected subdirectory structure; without it, subdirectory names become inconsistent and hard to predict.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:51.769303766+00:00”}

naming_pattern text 2147483647 √ null

{“what”:“File naming pattern, e.g., ‘prefix_*.log’.”,“why”:“Specifies expected file name format; without it, files cannot be matched to the schema.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:51.802169383+00:00”}

max_loose_files int4 10 √ null

{“what”:“Maximum number of files allowed directly in the directory (not in subdirs).”,“why”:“Prevents clutter; without it, loose files could accumulate unboundedly, degrading performance.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:51.830554544+00:00”}

owner_kind text 2147483647 √ null

{“what”:“Type of owner, e.g., ‘user’, ‘service’, ‘team’.”,“why”:“Identifies who is responsible; without it, ownership is unclear and accountability is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:51.848267644+00:00”}

owner_id text 2147483647 √ null

{“what”:“Identifier of the owner (username, service name, team ID).”,“why”:“Points to the specific owner; without it, owner_kind alone is insufficient to contact or assign permissions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:51.875671247+00:00”}

source text 2147483647 'user'::text

{“what”:“Origin of this schema definition: ‘user’ or ‘system’.”,“why”:“Distinguishes manually defined schemas from auto-generated ones; without it, trust in the schema’s accuracy is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:51.892809282+00:00”}

confidence float4 8,8 √ 1.0

{“what”:“Confidence score (0-1) that the schema is correct.”,“why”:“Indicates reliability; without it, low-confidence schemas could be mistaken for verified ones.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:51.913317502+00:00”}

notes text 2147483647 √ null

{“what”:“Free-form notes about the schema.”,“why”:“Captures context not covered by other fields; without it, rationale and exceptions are lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:51.925839049+00:00”}

updated_at timestamptz 35,6 √ now()

{“what”:“Timestamp of last modification, timezone-aware.”,“why”:“Tracks freshness; without it, stale schemas cannot be detected.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:51.943065137+00:00”}

Indexes

Constraint Name Type Sort Column(s)
dir_schema_pkey Primary key Asc/Asc device + dir_path

Relationships