KIOSK
Tables (3)
Menu (Untitled)
- MenuIDX (Key) — int — Primary key — NOT NULL
- Name (Field) — VARCHAR(40)
- Price (Field2) — int
- Path (Field3) — TEXT
- Category (Field4) — VARCHAR(20)
Order (Untitled2)
- Idx (Key) — Primary key — NOT NULL
- MenuIDX (Key2) — int — Foreign key → Menu.MenuIDX — NOT NULL
- UserIDX (Key3) — int — Foreign key → User.UserIDX — NOT NULL
- Table (Field) — int
- Amount (Field2) — int
- OrderedTime (Field3) — DateTime
- isCard (Field4) — boolean
User (Untitled3)
- UserIDX (Key) — int — Primary key — NOT NULL
- name (Field) — VARCHAR(20)
- value (Field2) — VARCHAR(20)