웹프웤
테이블 (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