Query

pilot.db — services

SQL

CREATE TABLE "services"  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  trainer_id INTEGER NOT NULL REFERENCES trainers(id) ON DELETE CASCADE,
  label TEXT NOT NULL,
  duration_min INTEGER,
  price_cents INTEGER NOT NULL DEFAULT 0,
  unit TEXT NOT NULL DEFAULT 'Std',
  category TEXT NOT NULL DEFAULT 'lesson'
    CHECK(category IN ('lesson','video','other','card','trial')),
  is_card_redemption INTEGER NOT NULL DEFAULT 0,
  active INTEGER NOT NULL DEFAULT 1,
  sort_order INTEGER NOT NULL DEFAULT 0,
  created_at TEXT NOT NULL DEFAULT (datetime('now')),
  updated_at TEXT NOT NULL DEFAULT (datetime('now')),
  units INTEGER,
  is_trial INTEGER NOT NULL DEFAULT 0
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
trainer_id INTEGER Rename | Drop
label TEXT Rename | Drop
duration_min INTEGER ✓ Rename | Drop
price_cents INTEGER Rename | Drop
unit TEXT Rename | Drop
category TEXT Rename | Drop
is_card_redemption INTEGER Rename | Drop
active INTEGER Rename | Drop
sort_order INTEGER Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT Rename | Drop
units INTEGER ✓ Rename | Drop
is_trial INTEGER Rename | Drop

Foreign Keys

Column Destination
trainer_id trainers.id

+ Add index

Indexes

Name Columns Unique SQL Drop?