SQL

CREATE TABLE recommends  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  section_id INTEGER NOT NULL,
  section_title TEXT NOT NULL,
  program_id INTEGER NOT NULL,
  display_order INTEGER DEFAULT 0,
  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
section_id INTEGER Rename | Drop
section_title TEXT Rename | Drop
program_id INTEGER Rename | Drop
display_order INTEGER ✓ Rename | Drop

Foreign Keys

Column Destination
program_id programs.id

+ Add index

Indexes

Name Columns Unique SQL Drop?