site_configs


Description

{“what”:“One row per host with its site-specific configuration.”,“why”:“Without it, there is no single place to look up host-specific settings for shortcuts, headers, and rewriting.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:06.627451758+00:00”}

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

Relationships