Query

pilot.db — practice_logs

SQL

CREATE TABLE practice_logs  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  student_id INTEGER NOT NULL REFERENCES students(id) ON DELETE CASCADE,
  trainer_id INTEGER NOT NULL REFERENCES trainers(id),
  raw_text TEXT NOT NULL,
  -- das Diktat,
  unverändert
  structured TEXT,
  -- JSON: { focus,
  volume,
  went_well,
  struggles }
                                    -- NULL wenn KI nicht verfügbar war — raw bleibt wertvoll
  created_at TEXT NOT NULL DEFAULT (datetime('now'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
student_id INTEGER Rename | Drop
trainer_id INTEGER Rename | Drop
raw_text TEXT Rename | Drop
structured TEXT ✓ Rename | Drop
created_at TEXT Rename | Drop

Foreign Keys

Column Destination
trainer_id trainers.id
student_id students.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_practice_logs_student
  • student_id
  • created_at
 SQL 
CREATE INDEX idx_practice_logs_student
ON practice_logs(student_id, created_at DESC)
Drop