kiosk

Tables (5)

CateGory (Untitled4)

  • categoryId (Key) — Primary key — NOT NULL
  • categoryName (Field)
  • categorySortingNumber (Field2)

Menu (Untitled)

  • menuId (Key) — Primary key — NOT NULL
  • menuName (Field)
  • menuPrice (Field2)
  • menuStock (Field3)
  • menuState (Field5)
  • origFilename (Field4)
  • filename (Field7)
  • menuDouble (Field8)
  • menuDoublePrice (Field6)
  • menuSortingNumber (Field9)
  • categoryId (Key2) — Foreign key → CateGory.categoryId — NOT NULL

OrderMenu (Untitled5)

  • orderMenuId (Key) — Primary key — NOT NULL
  • orderMenuQuentity (Field)
  • menuId (Key2) — Foreign key → Menu.menuId — NOT NULL
  • orderId (Key3) — Foreign key → Orders.orderId — NOT NULL
  • orderMenuOption (Field2)

Orders (Untitled3)

  • orderId (Key) — Primary key — NOT NULL
  • orderPrice (Field)
  • orderTime (Field2)
  • userId (Key2) — Foreign key → Users.userId — NOT NULL

Users (Untitled2)

  • userId (Key) — Primary key — NOT NULL
  • userLoginId (Field)
  • userPw (Field2)