kiosk

Tables (3)

Goods (Untitled)

  • goodsId (Key) — Primary key — NOT NULL
  • goodsName (Field)
  • goodsImgPath (Field2)
  • goodsCategory (Field7)
  • goodsPrice (Field3)
  • goodsStock (Field4)
  • goodsIntro (Field5)
  • goodsContents (Field6)
  • goodsRating (Field9)

Order (Untitled4)

  • orderNumber (Key) — Primary key — NOT NULL
  • goodsId (Key2) — Foreign key → Goods.goodsId — NOT NULL
  • listNumber (Field)
  • orderTime (Field2)
  • isPay (Field3)
  • tableNumber (Field4)
  • Field5

User (Untitled2)

  • userId (Key) — Primary key — NOT NULL
  • tableNumber (Field6)
  • Role (Field)