tenant

{“what”:“Integer primary key, unique per tenant.”,“why”:“Referenced by other tables as tenant_id to associate rows.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:30.288851331+00:00”}

{“what”:“Display name for the tenant, e.g., ‘Acme Corp’.”,“why”:“Shown in UI and reports; without it, tenants are only numbers.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:30.321847844+00:00”}

{“what”:“URL-safe unique string, e.g., ‘acme-corp’.”,“why”:“Used in API paths and subdomains; without it, routing would need numeric IDs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:30.348634225+00:00”}

{“what”:“Boolean flag; true means tenant is enabled.”,“why”:“Allows disabling a tenant without deleting data; without it, deactivation would require removal.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:30.393754696+00:00”}

{“what”:“Timestamp of last row update, timezone-aware.”,“why”:“Supports change tracking and cache invalidation; without it, stale data is undetectable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:30.405001011+00:00”}

{“what”:“Timestamp when tenant was created, timezone-aware.”,“why”:“Provides tenant age for lifecycle analysis; without it, onboarding date is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:30.418042876+00:00”}

{“what”:“Text field for JSON or key-value configuration.”,“why”:“Stores tenant-specific settings without schema migration; without it, custom fields require ALTER TABLE.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:30.433264016+00:00”}

{“what”:“Integer foreign key to a tenant collection group.”,“why”:“Groups tenants for bulk operations; without it, collections cannot be assigned.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:30.446846850+00:00”}