order
Tables (4)
Order (CopyOfUntitled)
- id (Key) — int — Primary key — NOT NULL
- id (User) — int — Foreign key → Store.id — NOT NULL
- id (store) — int — Foreign key → User.id — NOT NULL
- num (Field2) — char
- Store_request (Field3) — char
- delivery_request (Field4) — char
- price (Field6) — int
- delivery_way (Field7) — char
- address (FK) — int
- pay (Field8) — char
- time (Field10) — datetime
- pickup (Field11) — boolean
Rider (Untitled3)
- id (rider) — int — Primary key — NOT NULL
- id (Key) — int — Foreign key → Order.id — NOT NULL
- id (User) — int — Foreign key → Order.id — NOT NULL
- id (store) — int — Foreign key → Order.id — NOT NULL
- name (Field2) — char
- phone_number (Field3) — char
- gender (Field4) — char
- address (Field5) — char
- GPS (Field6) — char
Store (Untitled2)
- id (store) — int — Primary key — NOT NULL
- Business Number (Field) — int
- store_address (Field2) — char
- open (Field3) — boolean
- menu (Field4) — char
- price (Field5) — int
- delivery_price (Field6) — int
- details (Field7) — char
User (Untitled)
- id (User) — int — Primary key — NOT NULL
- phoneNum (Field) — char
- address (Field2) — char
- nickname (Field3) — char