Add Column

Cancel

Current Schema

CREATE TABLE users_to_recipes  (
  user_id CHAR(32) NOT NULL,
  recipe_id CHAR(32) NOT NULL,
  rating FLOAT,
  is_favorite BOOLEAN NOT NULL,
  id CHAR(32) NOT NULL,
  created_at DATETIME,
  update_at DATETIME,
  PRIMARY KEY (user_id, recipe_id, id),
  FOREIGN KEY(recipe_id) REFERENCES recipes (id),
  FOREIGN KEY(user_id) REFERENCES users (id),
  CONSTRAINT user_id_recipe_id_rating_key UNIQUE (user_id, recipe_id)
)