recipick

Tables (9)

FavoriteRecipe

  • favorite_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → Users.user_id — NOT NULL
  • recipe_id — BIGINT — Foreign key → Recipe.recipe_id — NOT NULL
  • created_at — DATETIME — NOT NULL

IngredientCategory

  • category_id — BIGINT — Primary key — NOT NULL
  • parent_id — BIGINT
  • name — VARCHAR(50) — NOT NULL

IngredientMaster

  • ingredient_id — BIGINT — Primary key — NOT NULL
  • category_id — BIGINT — Foreign key → IngredientCategory.category_id — NOT NULL
  • name_ko — VARCHAR(50) — NOT NULL
  • icon_url — VARCHAR(255)
  • created_at — DATETIME — NOT NULL

Recipe

  • recipe_id — BIGINT — Primary key — NOT NULL
  • source — ENUM('SPOONACULAR', 'MFDS') — NOT NULL
  • external_id — VARCHAR(255)
  • title — VARCHAR(100) — NOT NULL
  • image_url — VARCHAR(255)
  • ready_minutes — INT
  • difficulty — ENUM('EASY', 'NORMAL', 'HARD') — NOT NULL
  • step_count — INT — NOT NULL
  • instructions — JSON
  • created_at — DATETIME — NOT NULL

RecipeIngredient

  • recipe_ingredient_id — BIGINT — Primary key — NOT NULL
  • recipe_id — BIGINT — Foreign key → Recipe.recipe_id — NOT NULL
  • ingredient_id — BIGINT — Foreign key → IngredientMaster.ingredient_id — NOT NULL
  • ingredient_name — VARCHAR(50) — NOT NULL
  • is_optional — BOOLEAN — NOT NULL

RecipeLog

  • recipe_log_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → Users.user_id — NOT NULL
  • recipe_id — BIGINT — Foreign key → Recipe.recipe_id — NOT NULL
  • cooked_at — DATE — NOT NULL
  • rating — INT — NOT NULL
  • memo — TEXT
  • image_url — VARCHAR(255)
  • created_at — DATETIME — NOT NULL

UserIngredient

  • user_ingredient_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → Users.user_id — NOT NULL
  • ingredient_id — BIGINT — Foreign key → IngredientMaster.ingredient_id — NOT NULL
  • expire_at — DATE
  • is_consumed — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

UserProfile

  • user_id — BIGINT — Foreign key → Users.user_id — NOT NULL
  • cooking_level — ENUM('EASY','NORMAL','HARD') — NOT NULL
  • allergies — JSON
  • banned_ingredients — JSON
  • updated_at — DATETIME — NOT NULL

Users

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • provider — ENUM('LOCAL','GOOGLE','KAKAO','NAVER') — NOT NULL
  • provider_id — VARCHAR(255)
  • password — VARCHAR(255)
  • created_at — DATETIME — NOT NULL