경매

테이블 (5)

Bid

  • bid_id — NUMBER — 기본 키 — NOT NULL
  • item_id — NUMBER — 외래 키 → Item.item_id — NOT NULL
  • bidder_id — VARCHAR(20) — 외래 키 → User.user_id — NOT NULL
  • bid_amount — NUMBER
  • bid_time — TIMESTAMP

Item

  • item_id — NUMBER — 기본 키 — NOT NULL
  • seller_id — VARCHAR2(20) — 외래 키 → User.user_id — NOT NULL
  • title — VARCHAR2(100)
  • description — VARCHAR2(500)
  • starting_price — NUMBER
  • current_price — NUMBER
  • start_time — TIMESTAMP
  • end_time — TIMESTAMP
  • status — VARCHAR2(20)

Payment

  • payment_id — NUMBER — 기본 키 — NOT NULL
  • transaction_id (transaction_id2) — NUMBER — 외래 키 → Transaction.transaction_id — NOT NULL
  • payment_method — VARCHAR2(20)
  • payment_status — VARCHAR2(20)
  • payment_time — TIMESTAMP

Transaction

  • transaction_id — NUMBER — 기본 키 — NOT NULL
  • item_id — NUMBER — 외래 키 → Item.item_id — NOT NULL
  • buyer_id — VARCHAR2(20) — 외래 키 → User.user_id — NOT NULL
  • final_price — NUMBER
  • transaction_time — TIMESTAMP
  • is_completed — CHAR(1)

User

  • user_id — VARCHAR(20) — 기본 키 — NOT NULL
  • password — VARCHAR2(64)
  • username — VARCHAR2(50)
  • balance — NUMBER — NOT NULL