Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | gen_random_uuid() |
|
|
{“what”:“Random UUID generated by gen_random_uuid() as primary key.”,“why”:“Without it, profiles cannot be uniquely identified or updated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:54.413615968+00:00”} |
|||||
| domain | text | 2147483647 | null |
|
|
{“what”:“Domain name (e.g., example.com) the profile applies to.”,“why”:“Without it, profiles cannot be matched to a specific domain, making lookups ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:54.425953547+00:00”} |
|||||
| tier_number | int2 | 5 | null |
|
|
{“what”:“Numeric tier level (smallint) that orders tiers.”,“why”:“Without it, tier ordering and comparisons are impossible; tier_name alone is not sortable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:54.474645862+00:00”} |
|||||
| tier_name | text | 2147483647 | null |
|
|
{“what”:“Text label for the tier, complementing tier_number.”,“why”:“Without it, tier names are unknown for display or reporting; tier_number alone is not user-friendly.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:54.568961052+00:00”} |
|||||
| profile_json | jsonb | 2147483647 | null |
|
|
{“what”:“JSON object with the profile’s configuration details.”,“why”:“Without it, the profile’s specific settings are unavailable, so the profile cannot be applied.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:54.588336808+00:00”} |
|||||
| source | text | 2147483647 | 'auto'::text |
|
|
{“what”:“Source label indicating how the profile was created; default ‘auto’.”,“why”:“Without it, the provenance of the profile is unknown, complicating audits or debugging.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:54.614422018+00:00”} |
|||||
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when the profile was created, in UTC with timezone.”,“why”:“Without it, the age of the profile is unknown, affecting decisions on refresh or expiry.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:54.632221769+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| stealth_profiles_pkey | Primary key | Asc | id |
| idx_stealth_profiles_domain | Performance | Asc/Desc | domain + created_at |