birth_steps


Description

{“what”:“Steps of a birth process, each row one step.”,“why”:“Without it, no record of which steps were attempted or their outcomes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:10.913072985+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('birth_steps_id_seq'::regclass)

{“what”:“Surrogate key, unique per step row.”,“why”:“Provides stable identity for updates and joins.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:10.930226404+00:00”}

birth_id text 2147483647 null

{“what”:“Identifier of the birth process this step belongs to.”,“why”:“Groups steps for a single birth; without it steps are unassignable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:10.941956163+00:00”}

step_name text 2147483647 null

{“what”:“Name of the step, e.g., ‘dilation’ or ‘pushing’.”,“why”:“Identifies which step is being recorded; without it steps are indistinguishable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:10.962691906+00:00”}

passed int4 10 null

{“what”:“Numeric outcome code; 1=passed, 0=failed, other values may apply.”,“why”:“Determines success/failure of each step; without it outcome is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:10.973173825+00:00”}

detail text 2147483647 null

{“what”:“Free-text notes about the step execution or result.”,“why”:“Captures context not in numeric fields; without it troubleshooting is limited.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:11.014027652+00:00”}

step_order int4 10 null

{“what”:“Sequence number of the step within the birth process.”,“why”:“Preserves intended order; without it steps cannot be replayed in sequence.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:11.059643840+00:00”}

Indexes

Constraint Name Type Sort Column(s)
birth_steps_pkey Primary key Asc id
idx_steps_birth Performance Asc birth_id

Relationships