시험
테이블 (4)
Menu
- MenuID — INT
- RestaurantID — INT
- Name — VARCHAR(100) — NOT NULL
- Price — DECIMAL(10, 2) — NOT NULL
Order
- OrderID — INT
- MemberID — INT — NOT NULL
- RestaurantID — INT
- Address — VARCHAR(255) — NOT NULL
- Request — TEXT
- TotalAmount — DECIMAL(10, 2) — NOT NULL
- OrderType — ENUM('포장', '배달') — NOT NULL
- PaymentStatus — BOOLEAN — NOT NULL
- OrderTime — DATETIME — NOT NULL
OrderMenu
- OrderMenuID — INT
- OrderID — INT
- MenuID — INT
Restaurant
- RestaurantID — INT
- Name — VARCHAR(100) — NOT NULL
- Address — VARCHAR(255) — NOT NULL
- PhoneNumber — VARCHAR(15) — NOT NULL