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