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