Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('status_changes_id_seq'::regclass) |
|
|
{“what”:“Unique numeric identifier for each change event; auto-incremented.”,“why”:“Without it, rows cannot be uniquely referenced or updated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:14.842591883+00:00”} |
|
| birth_id | text | 2147483647 | null |
|
|
{“what”:“Identifier of the birth record whose status changed; matches an external system.”,“why”:“Without it, changes cannot be linked to the correct birth record.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:14.854411017+00:00”} |
||
| name | text | 2147483647 | null |
|
|
{“what”:“Full name of the person associated with the birth record.”,“why”:“Without it, the record cannot be identified by name for human review.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:14.864606921+00:00”} |
||
| old_status | text | 2147483647 | null |
|
|
{“what”:“Status value before the change; e.g., pending, approved.”,“why”:“Without it, the previous state is unknown, so the transition cannot be audited.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:14.877301845+00:00”} |
||
| new_status | text | 2147483647 | null |
|
|
{“what”:“Status value after the change; e.g., approved, rejected.”,“why”:“Without it, the resulting state is unknown, so current status cannot be derived.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:14.886660050+00:00”} |
||
| reason | text | 2147483647 | √ | null |
|
|
{“what”:“Free-text explanation for the status change; may be empty.”,“why”:“Without it, the justification for the change is missing, making audits incomplete.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:14.906824065+00:00”} |
|
| changed_at | text | 2147483647 | null |
|
|
{“what”:“Date and time the change occurred; stored as text.”,“why”:“Without it, the order of changes cannot be determined, so the current status is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:14.929471167+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| status_changes_pkey | Primary key | Asc | id |
| idx_status_changes_name | Performance | Asc | name |