상품구매

테이블 (3)

member

  • seq — BIGINT
  • user_id — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • user_type — ENUM('BUYER', 'SELLER') — NOT NULL
  • created_at — DATETIME

product

  • seq — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • quantity — INT — NOT NULL
  • is_sold — BOOLEAN — NOT NULL
  • seller_seq — BIGINT — NOT NULL
  • created_at — DATETIME

product_purchase

  • seq — BIGINT
  • buyer_seq — BIGINT — NOT NULL
  • product_seq — BIGINT — NOT NULL
  • purchase_quantity — INT — NOT NULL
  • purchased_at — DATETIME