Online Auction ERD-희원

테이블 (7)

Auction

  • auction_id — BIGINT — 기본 키 — NOT NULL
  • product_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • starting_price (사전예약 시간) — DECIMAL(10,2) — NOT NULL — 사전ㅇ{ㅖ약 시간
  • current_price (경매 종료 시간) — DECIMAL(10,2) — 경매 종료 시간
  • status — VARCHAR(50) — NOT NULL
  • start_at — DATETIME — NOT NULL
  • end_at — DATETIME — NOT NULL
  • created_at — TIMESTAMP

Bid

  • bid_id — BIGINT — 기본 키 — NOT NULL
  • auction_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • bid_amount — DECIMAL(10,2) — NOT NULL
  • bid_time — TIMESTAMP

Chat

  • chat_id — BIGINT — 기본 키 — NOT NULL
  • auction_id (어느 경매와 관련 채팅?) — BIGINT — NOT NULL
  • sender_id (메세지 보낸사람) — BIGINT — NOT NULL
  • receiver_id (메세지 받는 사람) — BIGINT — NOT NULL
  • message (채팅 내용) — TEXT — NOT NULL
  • sent_at — TIMESTAMP

Notification

  • notification_id — BIGINT — 기본 키 — NOT NULL
  • user_id (알림받을 사용자) — BIGINT — NOT NULL
  • auction_id (관련된 경매) — BIGINT — NOT NULL
  • message (알림내용) — TEXT — NOT NULL
  • is_read (읽음 여부) — BOOLEAN
  • created_at — TIMESTAMP

Product

  • product_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • category — VARCHAR(255)
  • image_url — VARCHAR(512)
  • condition (새상품/중고상품 구분) — VARCHAR(50) — NOT NULL — 새상품/ 중고상품 구분 (ex. NEW, USED)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • user_id (user_id2) — BIGINT — 외래 키 → User.user_id — NOT NULL

Transaction

  • transaction_id — BIGINT — 기본 키 — NOT NULL
  • auction_id — BIGINT — NOT NULL
  • buyer_id — BIGINT — NOT NULL
  • seller_id — BIGINT — NOT NULL
  • transaction_amount — DECIMAL(10,2) — NOT NULL
  • transaction_date — TIMESTAMP

User

  • user_id — BIGINT — 기본 키 — NOT NULL
  • username — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • role — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP