delivery
Tables (4)
Food (메뉴)
- Key (id) — bigint — Primary key — NOT NULL
- FK (RESTAURANT_ID) — bigint — Foreign key → Restaurant.PK — NOT NULL
- 음식이름 (name) — varchar
- 음식가격 (price) — int
FoodOrder (Untitled)
- PK (id) — bigint — Primary key — NOT NULL
- FK (ORDERS_ID) — bigint — Foreign key → Order.PK — NOT NULL
- PK (id22) — bigint — Foreign key → Order.FK — NOT NULL
- 음식이름 (name) — varchar
- 음식수량 (quantity) — int
- 음식가격*음식수량 (price) — int
Order (주문서)
- PK (id) — bigint — Primary key — NOT NULL
- FK (RESTAURANT_ID) — bigint — Foreign key → Restaurant.PK — NOT NULL
- 음식점이름 (name) — varchar
- 총주문금액 (totalPrice) — int
Restaurant (음식점)
- PK (id) — bigint — Primary key — NOT NULL
- 매장이름 (name) — varchar
- 최소주문금액 (minOrderPrice) — int
- 배달료 (deliveryFee) — int