캡스톤
테이블 (6)
Food (Untitled3)
- food id (food_id) — bigint — 기본 키 — NOT NULL
- food list id (food_list_id) — bigint — 외래 키 → Food List.food list id — NOT NULL
- restaurant id (restaurant_id) — bigint — 외래 키 → Food List.restaurant id — NOT NULL
- name — varchar
- food picture (food_picture) — varchar
- price — int
- is vegeterian (is_vegeterian) — boolean
- is vegan — boolean
- is gluten free (is_gluten_free) — boolean
- is kosher (is_kosher) — boolean
- is halal (is_halal) — boolean
Food List (Untitled6)
- food list id (food_list_id) — bigint — 기본 키 — NOT NULL
- restaurant id (restaurant_id) — bigint — 외래 키 → Restaurant.restaurant id — NOT NULL
Restaurant (Untitled2)
- restaurant id (restaurant_id) — bigint — 기본 키 — NOT NULL
- name — varchar
- category — enum
- main picture (main_pic) — varchar
- address — varchar
- open time (open_time) — varchar
- food list (food_list) — list
- review list (review_list) — list
Review (Untitled4)
- review id (review_id) — bigint — 기본 키 — NOT NULL
- review list id (review_list_id) — bigint — 외래 키 → Review List.review list id — NOT NULL
- restaurant id (restaurant_id) — bigint — 외래 키 → Review List.restaurant id — NOT NULL
- writer — varchar
- content — varchar
- review picture (review_pic) — varchar
- stars — int
Review List (Untitled5)
- review list id (review_list_id) — bigint — 기본 키 — NOT NULL
- restaurant id (restaurant_id) — bigint — 외래 키 → Restaurant.restaurant id — NOT NULL
User (Untitled)
- user id (user_id) — bigint — 기본 키 — NOT NULL
- name (user_name) — varchar
- email (user_email) — varchar
- pw (user_pw) — varchar
- diet preference (user_diet_preference) — enum
- notification setting (noti_setting) — boolean