웹프웤

테이블 (8)

INGREDIENT

  • ingredient_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(255) — NOT NULL

MEALPLAN

  • mealplan_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → USER.user_id — NOT NULL
  • title — VARCHAR(255)
  • description — TEXT
  • is_recommended — BOOLEAN
  • total_calories — INT
  • created_at — TIMESTAMP

MEALPLAN_RECIPE

  • mealplan_recipe_id — BIGINT — 기본 키 — NOT NULL
  • mealplan_id (mealplan_id2) — BIGINT — 외래 키 → MEALPLAN.mealplan_id — NOT NULL
  • recipe_id (recipe_id2) — BIGINT — 외래 키 → RECIPE.recipe_id — NOT NULL
  • day_of_week — VARCHAR(20)
  • meal_type — VARCHAR(20)

RECIPE

  • recipe_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • calories — INT
  • protein — DECIMAL(10, 2)
  • carbs — DECIMAL(10, 2)
  • fat — DECIMAL(10, 2)
  • carbon_score — DECIMAL(10, 2)
  • image_url — VARCHAR(2048)

RECIPE_INGREDIENT

  • ingredient_id (ingredient_id2) — BIGINT — 외래 키 → INGREDIENT.ingredient_id — NOT NULL
  • recipe_id (recipe_id2) — BIGINT — 외래 키 → RECIPE.recipe_id — NOT NULL
  • amount — VARCHAR(100)

USER

  • user_id — BIGINT — 기본 키 — NOT NULL
  • username — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • target_calories — INT
  • created_at — TIMESTAMP

USER_ALLERGY

  • user_id (user_id2) — BIGINT — 외래 키 → USER.user_id — NOT NULL
  • ingredient_id (ingredient_id2) — BIGINT — 외래 키 → INGREDIENT.ingredient_id — NOT NULL

USER_PREFERENCE

  • user_id (user_id2) — BIGINT — 외래 키 → USER.user_id — NOT NULL
  • ingredient_id (ingredient_id2) — BIGINT — 외래 키 → INGREDIENT.ingredient_id — NOT NULL