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