SQL
CREATE TABLE student_summaries (
student_id INTEGER PRIMARY KEY REFERENCES students(id) ON DELETE CASCADE,
summary TEXT NOT NULL,
source_counts TEXT,
-- JSON: Datenstand bei Erzeugung (Invalidierung)
generated_at TEXT NOT NULL DEFAULT (datetime('now'))
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
student_id |
INTEGER |
✓ | ✓ | Rename | Drop |
summary |
TEXT |
Rename | Drop | ||
source_counts |
TEXT |
✓ | Rename | Drop | |
generated_at |
TEXT |
Rename | Drop |
Foreign Keys
| Column | Destination |
|---|---|
student_id |
students.id |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|