책배달 연습
테이블 (5)
BookMenus
- MenuID — INT
- EstablishmentID — INT
- ImageURL — VARCHAR(255)
- BookName — VARCHAR(255) — NOT NULL
- Price — DECIMAL(10, 2) — NOT NULL
Establishments
- EstablishmentID — INT
- OwnerID — INT
- Name — VARCHAR(255) — NOT NULL
Orders
- OrderID — INT
- CustomerID — INT
- MenuID — INT
- OrderStatus — VARCHAR(20)
Reviews
- ReviewID — INT
- CustomerID — INT
- EstablishmentID — INT
- ReviewText — TEXT
- Rating — INT
Users
- UserID — INT
- UserType — VARCHAR(10) — NOT NULL
- Email — VARCHAR(255) — NOT NULL
- Points — INT