SQL

CREATE TABLE package_checklist  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  package_id INTEGER NOT NULL REFERENCES packages(id) ON DELETE CASCADE,
  item_id INTEGER NOT NULL REFERENCES package_checklist_items(id) ON DELETE CASCADE,
  UNIQUE(package_id, item_id)
)

Columns

+ Add column
Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
package_id INTEGER Rename | Drop
item_id INTEGER Rename | Drop

Foreign Keys

Column Destination
item_id package_checklist_items.id
package_id packages.id

Indexes

+ Add index
Name Columns Unique SQL Drop?
sqlite_autoindex_package_checklist_1
  • package_id
  • item_id
 ✓ SQL
-- no sql found --
 Drop