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