UbicShop

Tables (12)

Category (category)

  • Long (category_id) — Primary key — NOT NULL
  • String (name)

Coupon (coupon)

  • Long (coupon_id) — Primary key — NOT NULL

Order (orders)

  • Long (order_id) — Primary key — NOT NULL
  • Long (user_id) — Foreign key → User.Long — NOT NULL
  • User (user)
  • enum (status)

OrderProduct (order_product)

  • Long (order_product_id) — Primary key — NOT NULL
  • Long (order_id) — Foreign key → Order.Long — NOT NULL
  • Long (product_id) — Foreign key → Product.Long — NOT NULL
  • Product (product)
  • Order (order)
  • int (orderPrice)
  • int (count)

Product (product)

  • Long (product_id) — Primary key — NOT NULL
  • String (name)
  • int (price)
  • int (stockQuantity)

ProductCategory (product_category)

  • Long (product_category_id) — Primary key — NOT NULL
  • Long (product_id) — Foreign key → Product.Long — NOT NULL
  • Long (category_id) — Foreign key → Category.Long — NOT NULL
  • Product (product)
  • Category (category)

ProductTag (product_tag)

  • Long (product_tag_id) — Primary key — NOT NULL
  • Long (product_id) — Foreign key → Product.Long — NOT NULL
  • Long (tag_id2) — Foreign key → Tag.Long — NOT NULL

ShopList (shop_list)

  • Long (shop_list_id) — Primary key — NOT NULL
  • Long (user_id) — Foreign key → User.Long — NOT NULL
  • User (user)

ShopListProduct (shop_list_product)

  • Long (shop_list_product_id) — Primary key — NOT NULL
  • Long (shop_list_id) — Foreign key → ShopList.Long — NOT NULL
  • Long (product_id) — Foreign key → Product.Long — NOT NULL
  • Product (product)
  • ShopList (shopList)
  • int (shopListPrice)
  • int (count)

Tag (tag)

  • Long (tag_id) — Primary key — NOT NULL

User (user)

  • Long (user_id) — Primary key — NOT NULL
  • String (name)

UserCoupon (user_coupon)

  • Long (user_coupon_id) — Primary key — NOT NULL
  • Long (coupon_id) — Foreign key → Coupon.Long — NOT NULL
  • Long (user_id) — Foreign key → User.Long — NOT NULL