SQL

CREATE TABLE episodes  (
  id INTEGER PRIMARY KEY,
  program_id INTEGER NOT NULL,
  episode_number INTEGER NOT NULL,
  title TEXT,
  description TEXT,
  image TEXT,
  video_url TEXT,
  duration TEXT,
  release_date TEXT,
  status TEXT DEFAULT 'available',
  FOREIGN KEY (program_id) REFERENCES programs(id) ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
program_id INTEGER Rename | Drop
episode_number INTEGER Rename | Drop
title TEXT ✓ Rename | Drop
description TEXT ✓ Rename | Drop
image TEXT ✓ Rename | Drop
video_url TEXT ✓ Rename | Drop
duration TEXT ✓ Rename | Drop
release_date TEXT ✓ Rename | Drop
status TEXT ✓ Rename | Drop

Foreign Keys

Column Destination
program_id programs.id

+ Add index

Indexes

Name Columns Unique SQL Drop?