CREATE TABLE campaigns (
id INTEGER PRIMARY KEY AUTOINCREMENT,
trainer_id INTEGER NOT NULL REFERENCES trainers(id),
title TEXT NOT NULL,
-- intern
subject TEXT NOT NULL,
-- Mail-Betreff
intro_text TEXT,
-- persönlicher Einstieg in der Mail
status TEXT NOT NULL DEFAULT 'draft',
-- 'draft' | 'sent'
sent_at TEXT,
recipients_count INTEGER,
show_in_reminders INTEGER NOT NULL DEFAULT 0,
-- Stufe 2: Block in Transaktionsmails
created_at TEXT NOT NULL DEFAULT (datetime('now')),
updated_at TEXT NOT NULL DEFAULT (datetime('now')),
show_after_training INTEGER NOT NULL DEFAULT 0
)