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