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