status_changes


Description

{“what”:“Chronological log of status updates for birth records; each row is one change.”,“why”:“Without it, the history of status changes is lost, so audits and current status cannot be reconstructed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:14.827584534+00:00”}

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

Relationships