dd
Tables (15)
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)
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_image_url — VARCHAR(2048)
- cooking_time_minutes — INT
- servings — INT — NOT NULL
- created_at — DATETIME — NOT NULL
dish_ingredient
- dish_id — BIGINT — Foreign key → dish.dish_id — NOT NULL
- ingredient_id — BIGINT — Foreign key → ingredient.ingredient_id — NOT NULL
- required_grams — DECIMAL(10, 2) — 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
ingredient
- ingredient_id — BIGINT — Primary key — NOT NULL
- ingredient_name — VARCHAR(100) — NOT NULL
- category — VARCHAR(50) — NOT NULL
- ingredient_image_url — VARCHAR(2048)
- created_at — DATETIME — NOT NULL
ingredient_product
- ingredient_product_id — BIGINT — Primary key — NOT NULL
- ingredient_id — BIGINT — Foreign key → ingredient.ingredient_id — NOT NULL
- product_name — VARCHAR(255) — NOT NULL
- store_name — VARCHAR(100)
- package_grams — DECIMAL(10, 2) — NOT NULL
- price — INT — NOT NULL
- product_url — VARCHAR(2048)
- refreshed_at — DATETIME
- is_active — BOOLEAN — NOT NULL
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
- start_date — DATE — 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_product_id — BIGINT — Foreign key → ingredient_product.ingredient_product_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