kiosk

Tables (5)

markets (Untitled4)

  • idxMarket (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar

menu (Untitled)

  • idxMenu (Key) — int — Primary key — NOT NULL
  • MenuName (Field) — varchar
  • price (Field2) — int
  • sale (Field3) — double
  • img (Field4) — varchar
  • MenuType (Field5) — int
  • category (Field6) — int
  • page (Field7) — int

orders (Untitled2)

  • idxOrders (Key4) — int — Primary key — NOT NULL
  • idxMarket (Key2) — int — Foreign key → markets.idxMarket — NOT NULL
  • idxUser (Key3) — int — Foreign key → user.idxUser — NOT NULL
  • payTime (Field) — datatime
  • payType (Field2) — int
  • table (Field3) — int

ordersMenu (Untitled5)

  • idxMenu (Key) — int — Foreign key → menu.idxMenu — NOT NULL
  • idxOrders (Key4) — int — Foreign key → orders.idxOrders — NOT NULL
  • count (Field) — int

user (Untitled3)

  • idxUser (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar
  • QRCode (Field2) — varchar
  • BaCode (Field3) — varchar