경매
테이블 (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