Add Column

Cancel

Current Schema

CREATE TABLE availability  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  trainer_id INTEGER NOT NULL REFERENCES trainers(id) ON DELETE CASCADE,
  weekday INTEGER NOT NULL,
  -- 0=So,
  1=Mo,
  ...,
  6=Sa
  start_time TEXT NOT NULL,
  -- 'HH:MM'
  end_time TEXT NOT NULL,
  recurring INTEGER NOT NULL DEFAULT 1    -- 1 = wiederkehrend,
  0 = einmaliges Sonderfenster,
  year_week TEXT NULL
)