TEST
Tables (4)
FoodOrder (상세주문)
- ID (foodOrder_id) — Long — Primary key — NOT NULL
- 음식id (food_id) — Long — Foreign key → Foods.음식id — NOT NULL
- 주문id (order_id) — Long — Foreign key → Order.주문id — NOT NULL
- 주문수량 (quantity) — Int
- 주문음식가격 (price) — Int
Foods (음식)
- 음식id (food_id) — Long — Primary key — NOT NULL
- 식당id (restaurant_id) — Long — Foreign key → Restaurant.식당id — NOT NULL
- 음식이름 (foodName) — String
- 가격 (foodPrice) — Int
Order (주문)
- 주문id (order_id) — Long — Primary key — NOT NULL
- 식당id (restaurant_id) — Long — Foreign key → Restaurant.식당id — NOT NULL
- 총가격 (total_price) — Int
Restaurant (식당)
- 식당id (restaurant_id) — Long — Primary key — NOT NULL
- 식당이름 (name) — String
- 최소주문가격 (minOrderPrice) — Int
- 기본 배달비 (deliveryFee) — Int