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 |