CREATE TABLE "ingredient_units" (
created_at DATETIME,
update_at DATETIME,
id CHAR(32) NOT NULL,
group_id CHAR(32) NOT NULL,
name VARCHAR,
description VARCHAR,
abbreviation VARCHAR,
fraction BOOLEAN,
use_abbreviation BOOLEAN,
name_normalized VARCHAR,
abbreviation_normalized VARCHAR,
plural_name VARCHAR,
plural_name_normalized VARCHAR,
plural_abbreviation VARCHAR,
plural_abbreviation_normalized VARCHAR,
PRIMARY KEY (id),
CONSTRAINT ingredient_units_name_group_id_key UNIQUE (name, group_id),
FOREIGN KEY(group_id) REFERENCES groups (id)
)