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 |