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)