take-out food
Tables (5)
customer
- customer_no — char(30) — Primary key — NOT NULL
- customer_name — char(30)
- customer_phone — char(11)
- customer_address — char(30)
- customer_gendert — char(5)
- customer_age — int
goods
- goods_id — char(30) — Primary key — NOT NULL
- goods_name — char(30)
- goods_price — float
- store_no — char(30) — Foreign key → store.store_no — NOT NULL
store
- store_no — char(30) — Primary key — NOT NULL
- store_address — char(30)
- store_phone — char(11)
sys_order
- order_id — char(30) — Primary key — NOT NULL
- takeaway_boy_id — char(30) — Foreign key → takeaway_boy.takeaway_boy_id — NOT NULL
- customer_no — char(30) — Foreign key → customer.customer_no — NOT NULL
- goods_id — char(30) — Foreign key → goods.goods_id — NOT NULL
- order_price — float
- order_time — datetime
- estimated_delivery_time — datetime
- distance — float
- address — char(30)
- quantity — int
- discount — float
takeaway_boy
- takeaway_boy_id — char(30) — Primary key — NOT NULL
- boy_name
- boy_phone
- boy_age
- boy_gender