푸드코드앱
테이블 (5)
Customer
- CustomerID — INT
- CustomerName — VARCHAR(255)
FoodCorner
- CornerID — INT
- CornerName — VARCHAR(255)
FoodOrder
- OrderID — INT
- OrderNumber — INT
- CustomerID — INT — 외래 키 → Customer.CustomerID
Menu
- MenuID — INT
- CornerID — INT — 외래 키 → FoodCorner.CornerID
- MenuName — VARCHAR(255)
- Price — DECIMAL(10, 2)
OrderDetail
- OrderDetailID — INT
- OrderID — INT — 외래 키 → FoodOrder.OrderID
- MenuID — INT — 외래 키 → Menu.MenuID