Query

mealie.db — shopping_list_item_re...

SQL

CREATE TABLE "shopping_list_item_recipe_reference"  (
  created_at DATETIME,
  update_at DATETIME,
  id CHAR(32) NOT NULL,
  shopping_list_item_id CHAR(32) NOT NULL,
  recipe_id CHAR(32),
  recipe_quantity FLOAT NOT NULL,
  recipe_scale FLOAT NOT NULL,
  recipe_note VARCHAR,
  PRIMARY KEY (id, shopping_list_item_id),
  FOREIGN KEY(recipe_id) REFERENCES recipes (id),
  FOREIGN KEY(shopping_list_item_id) REFERENCES shopping_list_items (id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
created_at DATETIME ✓ Rename | Drop
update_at DATETIME ✓ Rename | Drop
id CHAR(32) ✓ Rename | Drop
shopping_list_item_id CHAR(32) ✓ Rename | Drop
recipe_id CHAR(32) ✓ Rename | Drop
recipe_quantity FLOAT Rename | Drop
recipe_scale FLOAT Rename | Drop
recipe_note VARCHAR ✓ Rename | Drop

Foreign Keys

Column Destination
shopping_list_item_id shopping_list_items.id
recipe_id recipes.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
ix_shopping_list_item_recipe_reference_created_at created_at SQL 
CREATE INDEX ix_shopping_list_item_recipe_reference_created_at
ON shopping_list_item_recipe_reference (created_at)
Drop
ix_shopping_list_item_recipe_reference_recipe_id recipe_id SQL 
CREATE INDEX ix_shopping_list_item_recipe_reference_recipe_id
ON shopping_list_item_recipe_reference (recipe_id)
Drop
sqlite_autoindex_shopping_list_item_recipe_reference_1
  • id
  • shopping_list_item_id
 ✓ SQL
-- no sql found --
 Drop