gaon-sprint-1th
Tables (9)
daily_menu
- daily_menu_id — BIGINT — Primary key — NOT NULL
- weekly_menu_id — BIGINT — Foreign key → weekly_menu.weekly_menu_id — NOT NULL
- day_number — TINYINT — NOT NULL
- daily_menu_highlight — VARCHAR(255)
- daily_menu_image_url — VARCHAR(2048)
dish
- dish_id — BIGINT — Primary key — NOT NULL
- daily_menu_id — BIGINT — Foreign key → daily_menu.daily_menu_id — NOT NULL
- dish_name — VARCHAR(100) — NOT NULL
- meal_type — VARCHAR(20) — NOT NULL
- dish_image_url — VARCHAR(2048)
- cooking_time_minutes — INT
- servings — INT — 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
ingredient
- ingredient_id — BIGINT — Primary key — NOT NULL
- ingredient_name — VARCHAR(100) — 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
user_current_menu
- user_id — BIGINT — 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 — BIGINT — 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
users
- user_id — BIGINT — 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
- 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