Query
CREATE TABLE "ingredient_foods" (
created_at DATETIME,
update_at DATETIME,
id CHAR(32) NOT NULL,
group_id CHAR(32) NOT NULL,
name VARCHAR,
description VARCHAR,
label_id CHAR(32),
name_normalized VARCHAR,
plural_name VARCHAR,
plural_name_normalized VARCHAR,
on_hand BOOLEAN NOT NULL,
PRIMARY KEY (id),
CONSTRAINT ingredient_foods_name_group_id_key UNIQUE (name, group_id),
FOREIGN KEY(label_id) REFERENCES multi_purpose_labels (id),
FOREIGN KEY(group_id) REFERENCES groups (id)
)