purchaseManagement

Tables (6)

email_verification (EmaiVerification)

  • email — varchar — Foreign key → user.user_email — NOT NULL
  • verification_code (verificationCode) — varchar

order_list (OrderList)

  • order_id — BIGINT — Foreign key → product_order.order_id — NOT NULL
  • user_email (userEmail) — varchar — Foreign key → product_order.user_email — NOT NULL
  • product_id (productId) — BIGINT — Foreign key → product.product_id — NOT NULL
  • product_name (ProductName) — varchar
  • quantity — INT

product (ProductEntity)

  • product_id (productId) — BIGINT — Primary key — NOT NULL
  • product_name (productName) — varchar
  • product_quentity (productQuentity) — INT
  • like_count (likeCount) — INT
  • product_image (productImage) — varchar
  • update_at (updateAt) — Date
  • create_at (createAt) — Date

product_order (ProductOrderEntity)

  • order_id — BIGINT — Primary key — NOT NULL
  • user_email (userEmail) — varchar — Foreign key → user.user_email — NOT NULL
  • order_at (orderAt) — Date

user (UserEntity)

  • user_email (userEmail) — varchar — Primary key — NOT NULL
  • email — varchar
  • password — varchar
  • user_name (userName) — varchar
  • singup_at (signupAt) — Date
  • address — varchar
  • mobile_No (mobileNo) — varchar
  • profile_image (profileImage) — varchar

wish_list (WishList)

  • wish_list_id (whishListId) — BIGINT — Primary key — NOT NULL
  • user_email (userEmail) — varchar — Foreign key → user.user_email — NOT NULL
  • product_id (productId) — BIGINT — Foreign key → product.product_id — NOT NULL