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)