crople
Tables (10)
auction
- auction_id — VARCHAR(50)
- seller_id — VARCHAR(50) — NOT NULL
- title — VARCHAR(100) — NOT NULL
- start_price — DECIMAL(15,2) — NOT NULL
- current_price — DECIMAL(15,2) — NOT NULL
- auction_type — ENUM('bar','auc','dauc') — NOT NULL
- details — TEXT
- created_at — TIMESTAMP
- end_time — DATETIME — NOT NULL
- INDEX — (seller_id)
- INDEX — (end_time)
bids
- bid_id — INT
- auction_id — VARCHAR(50) — NOT NULL
- user_id — VARCHAR(50) — NOT NULL
- bid_amount — DECIMAL(15,2) — NOT NULL
- bid_time — TIMESTAMP
- is_winner — TINYINT(1)
- INDEX — (user_id)
- INDEX — (auction_id)
escrows
- escrow_id — VARCHAR(50)
- amount — DECIMAL(15,2) — NOT NULL
- status — ENUM('holding','released','refunded')
- created_at — TIMESTAMP
notifications
- notification_id — INT
- user_id — VARCHAR(50) — NOT NULL
- content — TEXT — NOT NULL
- is_read — BOOLEAN
- created_at — TIMESTAMP
- INDEX — (user_id)
- INDEX — (is_read)
payment
- payment_id — INT
- tran_id — VARCHAR(50) — NOT NULL
- payment_method — ENUM('credit_card','kakao_pay','bank_transfer') — NOT NULL
- payment_status — ENUM('success','failed') — NOT NULL
- created_at — TIMESTAMP
- INDEX — (tran_id)
- INDEX — (payment_status)
point_transactions
- id — INT
- user_id — VARCHAR(50) — NOT NULL
- amount — INT — NOT NULL
- type — ENUM('충전','입찰','구매','에스크로보관','정산','환불') — NOT NULL
- description — TEXT
- created_at — DATETIME
- INDEX — (user_id)
points
- user_id — VARCHAR(50)
- balance — INT — NOT NULL
- updated_at — DATETIME
qna
- qna_id — INT
- auction_id — VARCHAR(50) — NOT NULL
- question_user_id — VARCHAR(50) — NOT NULL
- question_content — TEXT — NOT NULL
- question_created_at — TIMESTAMP
- answer_content — TEXT
- answer_created_at — TIMESTAMP
- INDEX — (auction_id)
- INDEX — (question_user_id)
transaction
- tran_id — VARCHAR(50)
- buyer_id — VARCHAR(50) — NOT NULL
- seller_id — VARCHAR(50) — NOT NULL
- auction_id — VARCHAR(50) — NOT NULL
- amount — DECIMAL(15,2) — NOT NULL
- status — ENUM('pending','confirmed','shipped','completed')
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — (buyer_id)
- INDEX — (seller_id)
- INDEX — (auction_id)
user
- user_id — VARCHAR(50)
- pw — VARCHAR(255) — NOT NULL
- num — VARCHAR(15) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- age — TINYINT — NOT NULL
- created_at — TIMESTAMP