LabEntriesTable
tableBreakdex::DataStores::LabEntriesTable
Session log entries within a lab — text notes and video clips
Each entry is a practice observation or recording within a lab. Entries form a chronological journal of the breakdancer's progress on a lab project. A lab with no entries is just a plan; entries turn it into practice.
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 |
|---|---|
| no Lab | message: lab_id is NULL — entry exists independently after lab deletion (on_delete:cascade should prevent this) shows: orphaned_entry |
| no Video | message: Entry is text-only — no video clip attached to this observation shows: text_only_entry |
Columns
| Name | Type | Constraints |
|---|---|---|
| id | text | NOT NULL |
| lab_id | text | |
| content | text | NOT NULL MIN: 1 |
| video_path | text | |
| created_at | datetime | NOT NULL DEFAULT: now |
Primary Key
idForeign Keys
lab_id \u2192 labs