Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| room_id | text | 2147483647 | null |
|
|
{“what”:“Identifier of the room that owns the certificate.”,“why”:“Links the certificate state to a specific room.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:10.058764187+00:00”} |
||
| cert_id | text | 2147483647 | null |
|
|
{“what”:“Identifier of the certificate, e.g., serial number.”,“why”:“Uniquely identifies which certificate’s state is recorded.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:10.081111114+00:00”} |
||
| state | text | 2147483647 | null |
|
|
{“what”:“Current status: active, revoked, expired, etc.”,“why”:“Determines if the certificate is valid for the room.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:10.118846743+00:00”} |
||
| reason | text | 2147483647 | √ | null |
|
|
{“what”:“Optional explanation for the state, e.g., revocation cause.”,“why”:“Provides audit trail for why the state changed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:10.140622618+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| room_cert_state_pkey | Primary key | Asc/Asc | room_id + cert_id |