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)
)