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