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