pointSystem

Tables (5)

BasketProduct

  • basketProductId (Key) — Long — Primary key — NOT NULL
  • shopBasketId (Key2) — Long — Foreign key → ShopBasket.shopBasketId — NOT NULL
  • productId (Key3) — Long — Foreign key → Product.productId — NOT NULL
  • totalPrice (Field) — int
  • count (Field2) — int

OrderList

  • userId (Key) — Long — Foreign key → User.userId — NOT NULL
  • productId (Key2) — Long — Foreign key → Product.productId — NOT NULL

Product

  • productId (Key) — Long — Primary key — NOT NULL
  • productName (Field) — String
  • productPrice (Field2) — int
  • productCount (Field3) — int
  • pointRate (Field4) — int
  • productOwner (Field5) — String

ShopBasket

  • shopBasketId (Key) — Long — Primary key — NOT NULL
  • userId (Key2) — Long — Foreign key → User.userId — NOT NULL

User

  • userId (Key) — Long — Primary key — NOT NULL
  • userName (Field) — String
  • userCash (Field2) — Long
  • userPoint (Field3) — Long