Kiosk
Tables (4)
Member (Untitled)
- member_id (PK) — Primary key — NOT NULL
- phone (Field)
- grade (Field2)
order (Untitled3)
- order_id (Key) — Primary key — NOT NULL
- member_id (PK) — Foreign key → Member.member_id — NOT NULL
- created_at (Field)
product (Untitled2)
- product_id (Key) — Primary key — NOT NULL
- product_name (Field)
- price (Field2)
- size (Field3)
- type (Field4)
- kcal (Field5)
product_order (Untitled4)
- prodicutorder_id (Key) — Primary key — NOT NULL
- product_id (Key2) — Foreign key → product.product_id — NOT NULL
- order_id (Key3) — Foreign key → order.order_id — NOT NULL
- count (Field)