2023_SLI_RESTAURANT
Tables (6)
Untitled (Orders)
- Key (oderID) — char(10) — Primary key — NOT NULL
- Field (orderDate) — date
- Field (Order Method) — char(3)
- Field (Payment) — int(50000)
- Key (CustomerID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (Customer)
- Key (CustomerID) — char(10) — Primary key — NOT NULL
- Field (name) — char(10)
- Field (phone) — int(10)
- Field (address) — char(30)
Untitled (FOOD)
- Key (MenuName) — char(30) — Primary key — NOT NULL
- Field (Price) — int(50000)
- Field (Description) — text
- Key (oderID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (DeliveryPerson)
- Key (DeliverID) — char(30) — Primary key — NOT NULL
- Key (oderID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Field (Name) — char(30)
- Field (Phone) — int(30)
- Field (DeliveryCompany) — char(30)
- Field (DeliveryTime) — time
- Field (DeliveryFee) — int(5000)
Untitled (Side Menu)
- Key (MenuName) — char(30) — Primary key — NOT NULL
- Field (Price) — int(5000)
- Field (Description) — text
- Key (MenuName2) — char(30) — Foreign key → Untitled.Key — NOT NULL
Untitled (Coupon)
- Key (CouponID) — char(10) — Primary key — NOT NULL
- Field (Discount) — int(10000)
- Key (oderID) — char(10) — Foreign key → Untitled.Key — NOT NULL