ㅇㅇ
Tables (16)
daily_menu
- daily_menu_id — BIGINT — Primary key — NOT NULL
- weekly_menu_id — BIGINT — Foreign key → weekly_menu.weekly_menu_id — NOT NULL
- day_of_week — TINYINT — NOT NULL
- daily_menu_highlight — VARCHAR(255)
- daily_menu_image_url — VARCHAR(2048)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
daily_menu_dish
- meal_type — ENUM('BREAKFAST', 'LUNCH', 'DINNER') — Primary key — NOT NULL
- daily_menu_id — BIGINT — Foreign key → daily_menu.daily_menu_id — NOT NULL
- dish_id — BIGINT — Foreign key → dish.dish_id — NOT NULL
dish
- dish_id — BIGINT — Primary key — NOT NULL
- dish_name — VARCHAR(100) — NOT NULL
- dish_description — VARCHAR(1000)
- dish_image_url — VARCHAR(2048)
- cooking_time_minutes — INT
- servings — INT — NOT NULL
- source_name — VARCHAR(100)
- source_url — VARCHAR(2048)
- external_recipe_id — VARCHAR(255)
- crawled_at — DATETIME
- is_active — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
dish_ingredient
- dish_ingredient_id — BIGINT — Primary key — NOT NULL
- dish_id — BIGINT — Foreign key → dish.dish_id — NOT NULL
- ingredient_id — BIGINT — Foreign key → ingredient.ingredient_id
- raw_ingredient_name — VARCHAR(100) — NOT NULL
- raw_amount_text — VARCHAR(100)
- quantity — DECIMAL(10, 2)
- unit — VARCHAR(50)
- required_grams — DECIMAL(10, 2)
- is_optional — BOOLEAN — NOT NULL
- sort_order — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
dish_recipe_step
- dish_recipe_step_id — BIGINT — Primary key — NOT NULL
- dish_id — BIGINT — Foreign key → dish.dish_id — NOT NULL
- step_number — INT — NOT NULL
- description — VARCHAR(1000) — NOT NULL
- step_image_url — VARCHAR(2048)
- timer_seconds — INT
- cooking_tip — VARCHAR(500)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
ingredient
- ingredient_id — BIGINT — Primary key — NOT NULL
- ingredient_name — VARCHAR(100) — NOT NULL
- normalized_name — VARCHAR(100) — NOT NULL
- category — VARCHAR(50) — NOT NULL
- ingredient_image_url — VARCHAR(2048)
- is_active — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
ingredient_alias
- ingredient_alias_id — BIGINT — Primary key — NOT NULL
- ingredient_id — BIGINT — Foreign key → ingredient.ingredient_id — NOT NULL
- alias_name — VARCHAR(100) — NOT NULL
- normalized_alias_name — VARCHAR(100) — NOT NULL
- source_name — VARCHAR(100)
- created_at — DATETIME — NOT NULL
ingredient_price
- ingredient_price_id — BIGINT — Primary key — NOT NULL
- ingredient_id — BIGINT — Foreign key → ingredient.ingredient_id — NOT NULL
- source — VARCHAR(50) — NOT NULL
- source_item_code — VARCHAR(100)
- region_name — VARCHAR(100)
- market_name — VARCHAR(100)
- unit_name — VARCHAR(50) — NOT NULL
- unit_grams — DECIMAL(10, 2) — NOT NULL
- price — INT — NOT NULL
- price_date — DATE — NOT NULL
- refreshed_at — DATETIME — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
ingredient_request
- ingredient_request_id — BIGINT — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → users.user_id — NOT NULL
- ingredient_name — VARCHAR(100) — NOT NULL
- memo — VARCHAR(500)
- status — ENUM('REQUESTED', 'APPROVED', 'REJECTED') — NOT NULL
- created_at — DATETIME — NOT NULL
user_current_menu
- user_id — CHAR(36) — Foreign key → users.user_id — NOT NULL
- weekly_menu_id — BIGINT — Foreign key → weekly_menu.weekly_menu_id — NOT NULL
- created_at — DATETIME — NOT NULL
user_favorite_menu
- user_id — CHAR(36) — Foreign key → users.user_id — NOT NULL
- weekly_menu_id — BIGINT — Foreign key → weekly_menu.weekly_menu_id — NOT NULL
- saved_at — DATETIME — NOT NULL
user_ingredient
- user_id — CHAR(36) — Foreign key → users.user_id — NOT NULL
- ingredient_id — BIGINT — Foreign key → ingredient.ingredient_id — NOT NULL
- owned_grams — DECIMAL(10, 2) — NOT NULL
- memo — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
user_preferred_dish
- user_id — CHAR(36) — Foreign key → users.user_id — NOT NULL
- dish_id — BIGINT — Foreign key → dish.dish_id — NOT NULL
- created_at — DATETIME — NOT NULL
user_shopping_list_item
- shopping_list_item_id — BIGINT — Primary key — NOT NULL
- user_id — CHAR(36) — Foreign key → users.user_id — NOT NULL
- ingredient_id — BIGINT — Foreign key → ingredient.ingredient_id — NOT NULL
- ingredient_price_id — BIGINT — Foreign key → ingredient_price.ingredient_price_id
- quantity_grams — DECIMAL(10, 2) — NOT NULL
- is_checked — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
users
- user_id — CHAR(36) — Primary key — NOT NULL
- user_name — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
weekly_menu
- weekly_menu_id — BIGINT — Primary key — NOT NULL
- owner_user_id — CHAR(36) — Foreign key → users.user_id
- source_weekly_menu_id — BIGINT — Foreign key → weekly_menu.weekly_menu_id
- weekly_menu_name — VARCHAR(100) — NOT NULL
- weekly_menu_explanation — VARCHAR(500)
- weekly_menu_highlight — VARCHAR(255)
- weekly_menu_image_url — VARCHAR(2048)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL