certifications


Description

{“what”:“A record that a profile passed or failed a certification check for a domain.”,“why”:“Without it, certification status and history for profiles and domains are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:47.377761331+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('certifications_id_seq'::regclass)

{“what”:“Unique numeric identifier for this certification record.”,“why”:“Without it, rows cannot be uniquely referenced for updates or joins.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:47.399531229+00:00”}

profile_id int4 10 √ null
profiles.id certifications_profile_id_fkey R

{“what”:“Identifier of the profile that this certification belongs to.”,“why”:“Without it, the certification cannot be linked to a specific profile for lookup.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:47.438006012+00:00”}

domain text 2147483647 null

{“what”:“Domain name (e.g., example.com) that the certification applies to.”,“why”:“Without it, the scope of the certification is unknown; multiple domains per profile would be ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:47.480477968+00:00”}

kind text 2147483647 'stackrhythm_wordpress'::text

{“what”:“Type of certification, defaulting to ‘stackrhythm_wordpress’.”,“why”:“Without it, different certification processes or standards cannot be distinguished.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:47.511893347+00:00”}

certified bool 1 true

{“what”:“Whether the certification passed (true) or failed (false).”,“why”:“Without it, the outcome of the certification check is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:47.551825293+00:00”}

stackrhythm_version text 2147483647 null

{“what”:“Version of StackRhythm software used during certification.”,“why”:“Without it, cannot know which software version produced the result, affecting reproducibility.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:47.568830341+00:00”}

ruleset_version text 2147483647 null

{“what”:“Version of the ruleset applied for certification.”,“why”:“Without it, the exact rules used for the check are unknown, making results non-reproducible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:47.583240031+00:00”}

fingerprint_db_hash text 2147483647 √ null

{“what”:“Hash of the fingerprint database used, if any.”,“why”:“Without it, cannot verify which fingerprint data was used, potentially invalidating the certification.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:47.611858668+00:00”}

agent text 2147483647 null

{“what”:“Identifier of the agent (e.g., hostname or tool) that performed the certification.”,“why”:“Without it, the source of the certification is unknown, complicating audits.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:47.635342978+00:00”}

agent_session text 2147483647 √ null

{“what”:“Session identifier for the agent run, if applicable.”,“why”:“Without it, multiple runs from the same agent cannot be distinguished.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:47.653075427+00:00”}

certified_unix int8 19 √ null

{“what”:“Unix timestamp (seconds since epoch) when certification was granted.”,“why”:“Without it, the exact time of certification is unknown, affecting validity windows.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:47.680089875+00:00”}

certified_at text 2147483647 √ null

{“what”:“Human-readable timestamp of certification, e.g., ISO 8601.”,“why”:“Without it, the certification date is not available in a human-readable format.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:47.721328980+00:00”}

tags jsonb 2147483647 null

{“what”:“Arbitrary key-value metadata attached to the certification.”,“why”:“Without it, custom attributes like environment or notes cannot be stored.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:47.745735910+00:00”}

superseded_at timestamptz 35,6 √ null

{“what”:“Timestamp when this certification was replaced by a newer one.”,“why”:“Without it, old certifications cannot be marked as inactive, leading to ambiguous current status.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:47.785588898+00:00”}

created_at timestamptz 35,6 √ now()

{“what”:“Timestamp when this certification record was created.”,“why”:“Without it, the record’s creation time is unknown, affecting audit trails.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:47.832888349+00:00”}

Indexes

Constraint Name Type Sort Column(s)
certifications_pkey Primary key Asc id
idx_cert_active Performance Asc/Asc domain + kind
idx_cert_domain Performance Asc domain
idx_cert_profile Performance Asc profile_id

Relationships