중고 경매

테이블 (10)

auction

  • id — SERIAL
  • product_id — INTEGER — NOT NULL
  • start_time — TIMESTAMP — NOT NULL
  • /* — 어떤 — NOT NULL
  • /* — 어떤 — NOT NULL
  • current_winner_id — INTEGER
  • status — VARCHAR(20)

bid

  • id — SERIAL
  • auction_id — INTEGER — NOT NULL
  • product_id — INTEGER — NOT NULL
  • bidder_id — INTEGER — NOT NULL
  • price — DECIMAL(10, 2) — NOT NULL
  • created_at — TIMESTAMP
  • is_winning — BOOLEAN

category

  • id — SERIAL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • parent_category_id — INTEGER

chat_messages

  • id — BIGSERIAL
  • room_id — BIGINT — NOT NULL
  • sender_id — BIGINT — NOT NULL
  • message — TEXT — NOT NULL
  • created_at — TIMESTAMP

favorite

  • id — SERIAL
  • user_id — INTEGER — NOT NULL
  • product_id — INTEGER — NOT NULL
  • added_at — TIMESTAMP
  • UNIQUE(user_id, — product_id)

notification

  • id — SERIAL
  • user_id — INTEGER — NOT NULL
  • notification_type — VARCHAR(20) — NOT NULL
  • system) — )
  • reference_id — INTEGER
  • content — TEXT — NOT NULL
  • is_read — BOOLEAN
  • created_at — TIMESTAMP

order

  • id — SERIAL
  • product_id — INTEGER — NOT NULL
  • buyer_id — INTEGER — NOT NULL
  • seller_id — INTEGER — NOT NULL
  • shipping_address_id — INTEGER — NOT NULL
  • final_price — DECIMAL(10, 2) — NOT NULL
  • order_date — TIMESTAMP
  • payment_method — VARCHAR(20) — NOT NULL
  • other) — )
  • payment_status — VARCHAR(20)
  • refunded) — )
  • shipping_status — VARCHAR(20)
  • returned) — )
  • tracking_number — VARCHAR(100)

product

  • id — SERIAL
  • seller_id — INTEGER — NOT NULL
  • category_id — INTEGER
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • base_price — DECIMAL(10, 2) — NOT NULL
  • condition — VARCHAR(50) — NOT NULL
  • is_sold — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

shipping_address

  • id — SERIAL
  • user_id — INTEGER — NOT NULL
  • recipient_name — VARCHAR(100) — NOT NULL
  • phone_number — VARCHAR(20) — NOT NULL
  • address_line1 — VARCHAR(255) — NOT NULL
  • address_line2 — VARCHAR(255)
  • city — VARCHAR(100) — NOT NULL
  • state_province — VARCHAR(100)
  • postal_code — VARCHAR(20) — NOT NULL
  • country — VARCHAR(100) — NOT NULL
  • is_default — BOOLEAN

user

  • id — SERIAL
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • phone_number — VARCHAR(20)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP