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