yoonjongwon

Tables (4)

tb_dish (음식 이름)

  • dish_id (dish_name_id) — INT — Primary key — NOT NULL
  • name (음식 이름) — VARCHAR(200)

tb_menu (식단)

  • menu_id — BIGINT — Primary key
  • restaurant_id — INT — Foreign key → tb_restaurant.restaurant_id
  • rating — INT — NOT NULL
  • viewpoint — VARCHAR(500)
  • served_date — DATE — NOT NULL
  • special_yn — Boolean — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

tb_menu_dish (식단-음식 테이블)

  • menu_dish_id (아이디) — int — Primary key — NOT NULL
  • menu_id (메뉴 아이디) — BIGINT — Foreign key → tb_menu.menu_id
  • dish_id (음식 아이디) — INT — Foreign key → tb_dish.dish_id — NOT NULL
  • main_yn (메인 음식 여부) — Boolean

tb_restaurant

  • restaurant_id — INT — Primary key
  • restaurant_name — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL