pilot.db — accounts

CREATE TABLE accounts  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  name TEXT NOT NULL,
  -- Akademie-Name oder Trainer-Vollname
  kind TEXT NOT NULL DEFAULT 'solo'              -- 'solo' (Einzeltrainer) | 'academy' (Akademie)
    CHECK(kind IN ('solo','academy')),
  plan TEXT NOT NULL DEFAULT 'trial'             -- 'trial' | 'solo' | 'academy' | 'cancelled'
    CHECK(plan IN ('trial','solo','academy','cancelled')),
  status TEXT NOT NULL DEFAULT 'trial'           -- 'trial' | 'active' | 'past_due' | 'cancelled'
    CHECK(status IN ('trial','active','past_due','cancelled')),
  trial_until TEXT,
  -- ISO-Datum,
  NULL nach Trial-Konvertierung
  seats INTEGER NOT NULL DEFAULT 1,
  -- Anzahl der genutzten Trainer-Sitze
  billing_email TEXT,
  -- separate Rechnungs-Mail (NULL = Owner-Mail)
  created_at TEXT NOT NULL DEFAULT (datetime('now'))
)