Query

mealie.db — shopping_list_items

SQL

CREATE TABLE shopping_list_items  (
  created_at DATETIME,
  update_at DATETIME,
  id CHAR(32) NOT NULL,
  shopping_list_id CHAR(32),
  is_ingredient BOOLEAN,
  position INTEGER NOT NULL,
  checked BOOLEAN,
  quantity FLOAT,
  note VARCHAR,
  is_food BOOLEAN,
  unit_id CHAR(32),
  food_id CHAR(32),
  label_id CHAR(32),
  PRIMARY KEY (id),
  FOREIGN KEY(food_id) REFERENCES ingredient_foods (id),
  FOREIGN KEY(label_id) REFERENCES multi_purpose_labels (id),
  FOREIGN KEY(shopping_list_id) REFERENCES shopping_lists (id),
  FOREIGN KEY(unit_id) REFERENCES ingredient_units (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_id CHAR(32) ✓ Rename | Drop
is_ingredient BOOLEAN ✓ Rename | Drop
position INTEGER Rename | Drop
checked BOOLEAN ✓ Rename | Drop
quantity FLOAT ✓ Rename | Drop
note VARCHAR ✓ Rename | Drop
is_food BOOLEAN ✓ Rename | Drop
unit_id CHAR(32) ✓ Rename | Drop
food_id CHAR(32) ✓ Rename | Drop
label_id CHAR(32) ✓ Rename | Drop

Foreign Keys

Column Destination
unit_id ingredient_units.id
shopping_list_id shopping_lists.id
label_id multi_purpose_labels.id
food_id ingredient_foods.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
ix_shopping_list_items_created_at created_at SQL 
CREATE INDEX ix_shopping_list_items_created_at
ON shopping_list_items (created_at)
Drop
ix_shopping_list_items_position position SQL 
CREATE INDEX ix_shopping_list_items_position
ON shopping_list_items (position)
Drop
ix_shopping_list_items_shopping_list_id shopping_list_id SQL 
CREATE INDEX ix_shopping_list_items_shopping_list_id
ON shopping_list_items (shopping_list_id)
Drop
sqlite_autoindex_shopping_list_items_1 id ✓ SQL
-- no sql found --
 Drop