YunMarket

Tables (12)

Answer

  • id — BIGINT — Primary key — NOT NULL
  • question_id — BIGINT — Foreign key → Question.id — NOT NULL
  • seller_id — BIGINT — Foreign key → Question.seller_id — NOT NULL
  • contents — varchar
  • deletedYn — boolean

Cart

  • id — BIGINT — Primary key — NOT NULL
  • customer_id — BIGINT — Foreign key → Customer.id — NOT NULL
  • product_id — BIGINT — Foreign key → Product.id — NOT NULL
  • quantity — INT

Category

  • id — BIGINT — Primary key — NOT NULL
  • name — varchar

Customer

  • id — BIGINT — Primary key — NOT NULL
  • email — varchar
  • password — varchar
  • phone — varchar
  • address — varchar
  • point — INT
  • deletedYn — boolean
  • created_date — DATETIME
  • modified_date — DATETIME

Ordered

  • id — BIGINT — Primary key — NOT NULL
  • customer_id — BIGINT — Foreign key → Customer.id — NOT NULL
  • product_id — BIGINT — Foreign key → Product.id — NOT NULL
  • seller_id — BIGINT — Foreign key → Seller.id — NOT NULL
  • transaction_id — BIGINT — Foreign key → Transaction.id — NOT NULL
  • quantity — INT
  • price — INT
  • total_amount — INT
  • created_date (created_datetime) — DATETIME

Product

  • id — BIGINT — Primary key — NOT NULL
  • category_id — BIGINT — Foreign key → Category.id — NOT NULL
  • seller_id — BIGINT — Foreign key → Seller.id — NOT NULL
  • name — varchar
  • price — INT
  • description — varchar
  • quantity — INT
  • image — varchar
  • ordered_count — BIGINT
  • deletedYn — boolean
  • created_date — DATETIME
  • modified_date — DATETIME

ProductViewHistory

  • id — BIGINT — Primary key — NOT NULL
  • product_id — BIGINT — Foreign key → Product.id — NOT NULL
  • userIp — varchar

Question

  • id — BIGINT — Primary key — NOT NULL
  • customer_id — BIGINT — Foreign key → Customer.id — NOT NULL
  • product_id — BIGINT — Foreign key → Product.id — NOT NULL
  • seller_id — BIGINT — Foreign key → Product.seller_id — NOT NULL
  • contents — varchar
  • deletedYn — boolean

Review

  • id — BITINT — Primary key — NOT NULL
  • product_id — BIGINT — Foreign key → Product.id — NOT NULL
  • customer_id — BIGINT — Foreign key → Customer.id — NOT NULL
  • rating — INT
  • contents — varchar
  • deletedYn — boolean
  • created_date — DATETIME
  • modified_date — DATETIME

ReviewComment

  • id — BIGINT — Primary key — NOT NULL
  • review_id — BITINT — Foreign key → Review.id — NOT NULL
  • seller_id — BIGINT — Foreign key → Seller.id — NOT NULL
  • contents — varchar
  • deletedYn — boolean
  • created_date — DATETIME
  • modified_date — DATETIME

Seller

  • id — BIGINT — Primary key — NOT NULL
  • email — varchar
  • password — varchar
  • phone — varchar
  • deletedYn — boolean
  • created_date — DATETIME
  • modified_date — DATETIME

Transaction

  • id — BIGINT — Primary key — NOT NULL
  • transaction_date — DATETIME
  • transaction_price — INT
  • point_use — INT
  • deleted — boolean