배달DB
테이블 (4)
음식(FOOD) (Untitled2)
- MENU_ID (id) — int — 기본 키 — NOT NULL
- NAME (name) — varchar
- PRICE (price) — int
- RESTAURANT_ID (restaurant) — int — 외래 키 → 음식점(RESTAURANT).RESTAURANT_ID — NOT NULL
음식점(RESTAURANT) (Untitled)
- RESTAURANT_ID (id) — int — 기본 키 — NOT NULL
- NAME (name) — varchar
- MIN_ORDER_PRICE (minOrderPrice) — int
- DELIVERY_FEE (deliveryFee) — int
주문(ORDER) (Untitled3)
- ORDER_ID (id) — int — 기본 키 — NOT NULL
- TOTAL_PRICE (totalPrice) — int
- RESTAURANT_ID (restaurantId) — int — 외래 키 → 음식점(RESTAURANT).RESTAURANT_ID — NOT NULL
주문음식(ORDER_FOOD) (Untitled4)
- ORDER_MENU_ID (id) — int — 기본 키 — NOT NULL
- QUANTITY (quantity) — int
- PRICE (price) — int
- ORDER_ID (orderId) — int — 외래 키 → 주문(ORDER).ORDER_ID — NOT NULL
- MENU_ID (menuId) — int — 외래 키 → 음식(FOOD).MENU_ID — NOT NULL