중고거래

테이블 (3)

b2b_product

  • product_id — VARCHAR(10)
  • partner_id — VARCHAR(10)
  • wholesale_price — DECIMAL(10,2)
  • min_order_qty — INT

online_product

  • product_id — VARCHAR(10)
  • shop_url — VARCHAR(200)
  • delivery_type — VARCHAR(20)
  • discount_rate — DECIMAL(5,2)

product

  • product_id — VARCHAR(10)
  • product_name — VARCHAR(100) — NOT NULL
  • price — DECIMAL(10,2)
  • stock — INT
  • online_yn — CHAR(1)
  • offline_yn — CHAR(1)
  • b2b_yn — CHAR(1)