Add Column

Cancel

Current Schema

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