Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| host | text | 2147483647 | null |
|
|
{“what”:“Hostname (e.g., example.com) that uniquely identifies this config row.”,“why”:“Without it, multiple configs for the same host would be ambiguous and updates would target the wrong row.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:06.663382911+00:00”} |
||
| shortcuts | jsonb | 2147483647 | '{}'::jsonb |
|
|
{“what”:“JSON object mapping shortcut keys to target URLs or actions.”,“why”:“Without it, there is no definition of which shortcuts exist or what they expand to, so shortcut links break.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:06.718371739+00:00”} |
||
| header_overrides | jsonb | 2147483647 | '{}'::jsonb |
|
|
{“what”:“JSON object of HTTP header names to values to set on responses.”,“why”:“Without it, there is no way to inject or modify HTTP headers per host.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:06.763661082+00:00”} |
||
| emulation | text | 2147483647 | √ | null |
|
|
{“what”:“Optional text defining an emulation profile (e.g., ‘mobile’ or a user-agent).”,“why”:“Without it, the site cannot be served with the specified emulation, so behavior may differ from the intended target.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:06.803598886+00:00”} |
|
| url_rewrite | text | 2147483647 | √ | null |
|
|
{“what”:“Text pattern or rule for rewriting incoming URLs (e.g., regex or template).”,“why”:“Without it, URL rewriting cannot be applied, so requests to old paths would 404 or hit wrong resources.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:06.860157049+00:00”} |
|
| notes | text | 2147483647 | √ | null |
|
|
{“what”:“Free-form human-readable notes about this site configuration.”,“why”:“Without it, there is no place to record context or rationale, so future maintainers lose operational knowledge.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:06.900220180+00:00”} |
|
| updated_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp (with time zone) of the most recent change to this row.”,“why”:“Without it, there is no way to know how stale a config is, so caching or auditing becomes unreliable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:06.922604341+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| site_configs_pkey | Primary key | Asc | host |