CREATE TABLE students (
id INTEGER PRIMARY KEY AUTOINCREMENT,
trainer_id INTEGER NOT NULL REFERENCES trainers(id) ON DELETE CASCADE,
name TEXT NOT NULL,
email TEXT,
-- für Magic-Link
phone TEXT,
hcpi REAL,
-- Handicap-Index
tags TEXT NOT NULL DEFAULT '[]',
-- JSON-Array: ["Einzel",
"Stamm",
"VIP"]
marketing_consent INTEGER NOT NULL DEFAULT 0,
video_consent INTEGER NOT NULL DEFAULT 0,
video_consent_date TEXT,
notes TEXT,
created_at TEXT NOT NULL DEFAULT (datetime('now')),
status TEXT NOT NULL DEFAULT 'active' -- 'active' | 'archived',
birthday TEXT,
member_since TEXT,
home_club TEXT,
source TEXT,
contact_channel TEXT,
prefs TEXT,
video_consent_granted_at TEXT,
example_note TEXT,
address TEXT
)