MilestonesTable
tableBreakdex::DataStores::MilestonesTable
Goal markers within a lab — checkpoints the breakdancer aims to hit
Milestones are specific achievements within a lab project. They provide structure and motivation — the breakdancer sets a goal ('land windmill 3x in a row') and checks it off when accomplished. Completing all milestones signals the lab is ready for 'clean' status.
Relationships
Depends On 1
labs_dao
Reads From 1
labs_table
Breaks If 1
lab_deleted_without_cascade
Data Access
Reads 1
labs_table
Answers
States
| State | Behavior |
|---|---|
| completed | message: completed_at is set — milestone achieved, timestamp records when shows: checked_badge_with_date |
| not Completed | message: completed_at is NULL — milestone is still pending shows: open_checkbox |
Columns
| Name | Type | Constraints |
|---|---|---|
| id | text | NOT NULL |
| lab_id | text | NOT NULL |
| title | text | NOT NULL MIN: 1 |
| notes | text | |
| completed_at | datetime | |
| created_at | datetime | NOT NULL DEFAULT: now |
Primary Key
idForeign Keys
lab_id \u2192 labs