Query
CREATE TABLE "shopping_lists_multi_purpose_labels" (
created_at DATETIME,
update_at DATETIME,
id CHAR(32) NOT NULL,
shopping_list_id CHAR(32) NOT NULL,
label_id CHAR(32) NOT NULL,
position INTEGER NOT NULL,
PRIMARY KEY (id, shopping_list_id, label_id),
CONSTRAINT shopping_list_id_label_id_key UNIQUE (shopping_list_id, label_id),
FOREIGN KEY(shopping_list_id) REFERENCES shopping_lists (id),
FOREIGN KEY(label_id) REFERENCES multi_purpose_labels (id)
)