e-commerce
Tables (23)
Cart (cart)
- id — BIGINT — Primary key — NOT NULL
- member (member_id) — BIGINT — Foreign key → Member.id — NOT NULL
- product (product_id) — BIGINT — Foreign key → Product.id — NOT NULL
- quantity — INT
Cart (v2_cart)
- id — BIGINT — Primary key — NOT NULL
- member (member_id) — BIGINT — Foreign key → Member.id — NOT NULL
- prodcutName (product_name) — VARCHAR
- price — INT
- quantity — INT
- thumbnailUrl (thumbnail_url) — VARCHAR
- productId (product_id) — BIGINT
Delivery (v2_delivery)
- id — BIGINT — Primary key — NOT NULL
- deliveryAddress (delivery_address_id) — BIGINT — Foreign key → DeliveryAddress.id — NOT NULL
- productName (product_name) — VARCHAR
- quantity — INT
- deliveryStatus (delivery_status) — VARCHAR
- referenceCode (reference_code) — BIGINT
- productId (product_id) — BIGINT
- orderLineId (order_line_id) — BIGINT
Delivery (delivery)
- id — BIGINT — Primary key — NOT NULL
- product (prodcut_id) — BIGINT — Foreign key → Product.id — NOT NULL
- memberAddress (member_address_id) — BIGINT — Foreign key → DeliveryAddress.id — NOT NULL
- orderLine (order_line_id) — BIGINT — Foreign key → OrderLine.id — NOT NULL
- deliveryStatus (delivery_status) — VARCHAR
- referenceCode (reference_code) — BIGINT
DeliveryAddress (v2_delivery_address)
- id — BIGINT — Primary key — NOT NULL
- receiver — VARCHAR
- street — VARCHAR
- detailAddress (detail_address) — VARCHAR
- zipCode (zip_code) — VARCHAR
- alias — BIT
- isMainAddress — BIT
- memberId (member_id) — BIGINT
DeliveryAddress (member_address)
- id — BIGINT — Primary key — NOT NULL
- member (member_id) — BIGINT — Foreign key → Member.id — NOT NULL
- receiver — VARCHAR
- street — VARCHAR
- detailAddress — VARCHAR
- zipCode — VARCHAR
- alias — VARCHAR
- isMainAddress (is_main_address) — BIT
Member (v2_member)
- id — BIGINT — Primary key — NOT NULL
- username — VARCHAR
- phoenNumber (phone_number) — VARCHAR
- password — VARCHAR
- role — VARCHAR
- company — VARCHAR
Member (member)
- id — BIGINT — Primary key — NOT NULL
- username — VARCHAR
- phoenNumber (phone_number) — VARCHAR
- password — VARCHAR
- role — VARCHAR
- company — VARCHAR
Order (product_order)
- id — BIGINT — Primary key — NOT NULL
- member (member_id) — BIGINT — Foreign key → Member.id — NOT NULL
- oderStatus (order_status) — VARCHAR
- totalPrice (total_price) — INT
- totalDiscount (total_discount) — INT
Order (v2_product_order)
- id — BIGINT — Primary key — NOT NULL
- oderStatus (order_status) — VARCHAR
- totalPrice (total_price) — INT
- totalDiscount (total_discount) — INT
- memberId (member_id) — BIGINT
OrderLine (order_line)
- id — BIGINT — Primary key — NOT NULL
- order (oder_id) — BIGINT — Foreign key → Order.id — NOT NULL
- product (product_id) — BIGINT — Foreign key → Product.id — NOT NULL
- quantity — INT
- orderLineStatus (order_line_status) — VARCHAR
- delivery (delivery_id) — BIGINT — Foreign key → Delivery.id — NOT NULL
- payment (payment_id) — BIGINT — Foreign key → Payment.id — NOT NULL
OrderLine (v2_order_line)
- id — BIGINT — Primary key — NOT NULL
- order (order_id) — BIGINT — Foreign key → Order.id — NOT NULL
- productName (product_name) — VARCHAR
- price — INT
- quantity — INT
- thumbnailUrl (thumnail_url) — VARCHAR
- orderLineStatus (order_line_status) — VARCHAR
- productId (product_id) — BIGINT
- paymentId (payment_id) — BIGINT
- deliveryId (delivery_id) — BIGINT
Payment (payment)
- id — BIGINT — Primary key — NOT NULL
- member (member_id) — BIGINT — Foreign key → Member.id — NOT NULL
- paymentMethod (payment_method_id) — BIGINT — Foreign key → PaymentMethod.id — NOT NULL
- orderLine (order_line_id) — BIGINT — Foreign key → OrderLine.id — NOT NULL
- totalPrice (total_price) — INT
- discountPrice (discount_price) — INT
- paymentStatus (payment_status) — VARCHAR
- referenceCode (reference_code) — VARCHAR
Payment (v2_payment)
- id — BIGINT — Primary key — NOT NULL
- paymentMethod (payment_method_id) — BIGINT — Foreign key → PaymentMethod.id — NOT NULL
- totalPrice (total_price) — INT
- discountPrice (discount_price) — INT
- paymentStatus (payment_status) — VARCHAR
- referenceCode (reference_code) — VARCHAR
- member_id — BIGINT
- orderLineId (order_line_id) — BIGINT
PaymentMethod (payment_method)
- id — BIGINT — Primary key — NOT NULL
- member (member_id) — BIGINT — Foreign key → Member.id — NOT NULL
- paymentType (payment_type) — VARCHAR
- bank — VARCHAR
- creditCardNumber (credit_card_number) — VARCHAR
- accountNumber (account_number) — VARCHAR
PaymentMethod (v2_payment_method)
- id — BIGINT — Primary key — NOT NULL
- paymentType (payment_type) — VARCHAR
- bank — VARCHAR
- accountNumber (account_number) — VARCHAR
- creditCardNumber (credit_card_number) — VARCHAR
- memberId (member_id) — BIGINT
Product (v2_product)
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR
- desciption (description) — VARCHAR
- price — INT
- totalStock — INT
- remainStock (soldQuantity) — INT
- phoneNumber (phone_number) — VARCHAR
- company — VARCHAR
- sellerId (seller_id) — BIGINT
Product (product)
- id — BIGINT — Primary key — NOT NULL
- seller (seller_id) — BIGINT — Foreign key → Member.id — NOT NULL
- name — VARCHAR
- desciption (description) — VARCHAR
- price — INT
- totalStock — INT
- remainStock (soldQuantity) — INT
ProductImage (product_image)
- product (product_id) — BIGINT — Foreign key → Product.id — NOT NULL
- originalUrl (original_url) — VARCHAR
- originalPath (original_path) — VARCHAR
- thumnailUrl (thumnail_url) — VARCHAR
- thumnailPath (thumnail_path) — VARCHAR
ProductImage (v2_product_image)
- product (product_id) — BIGINT — Foreign key → Product.id — NOT NULL
- originalUrl (original_url) — VARCHAR
- originalPath (original_path) — VARCHAR
- thumnailUrl (thumnail_url) — VARCHAR
- thumnailPath (thumnail_path) — VARCHAR
Refund (v2_refund)
- id — BIGINT — Primary key — NOT NULL
- payment (payment_id) — BIGINT — Foreign key → Payment.id — NOT NULL
- productName (product_name) — VARCHAR
- quantity — BIGINT
- price — BIGINT
- referenceCode (reference_code) — VARCHAR
- refundStatus (refund_status) — VARCHAR
- memberId (member_id) — BIGINT
- productId (product_id) — BIGINT
Tag (tag)
- product (product_id) — BIGINT — Foreign key → Product.id — NOT NULL
- tag — VARCHAR
Tag (v2_tag)
- product (product_id) — BIGINT — Foreign key → Product.id — NOT NULL
- tag — VARCHAR