stealth_profiles


Description

{“what”:“Profiles that define stealth behavior for a domain at a given tier.”,“why”:“Without it, stealth configurations cannot be stored or retrieved per domain and tier.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:19:54.358613341+00:00”}

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
tier_costs.tier_number Implied Constraint R

{“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

Relationships