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,
calendar_token TEXT,
password_hash TEXT,
activation_token TEXT,
activation_expires_at TEXT,
activated_at TEXT,
password_reset_token TEXT,
password_reset_expires_at TEXT,
payment_method TEXT,
payment_notes TEXT,
marketing_consent_at TEXT,
marketing_consent_source TEXT,
marketing_token TEXT,
privacy_accepted_at TEXT
)