hhplus 3rd week

Tables (5)

Concert (콘서트)

  • concert_id (콘서트 id) — INT — Primary key — NOT NULL
  • concert_name (콘서트명) — VARCHAR(50)
  • concert_date (콘서트일) — DATE
  • seat_num (좌석 번호) — INT
  • price (좌석 가격) — DECIMAL(10,2)
  • grade (좌석 등급) — VARCHAR(20)
  • status (예약가능여부) — VARCHAR(20)
  • temp_reserved_at (임시예약시간) — TIMESTAMP
  • created_at (생성일) — TIMESTAMP

PayHistory (결제 내역)

  • history_id (결제id) — INT — Primary key — NOT NULL
  • user_id (사용자 id) — INT — Foreign key → User.user_id — NOT NULL
  • amount (결제금액) — DECIAMAL
  • status (결제 결과) — VARCHAR(20)
  • created_at (생성일) — CURRENT_TIMESTAMP

QueueToken (큐토큰)

  • queue_id (큐id) — INT — Primary key — NOT NULL
  • user_id (사용자 id) — INT — Foreign key → User.user_id — NOT NULL
  • UUID (토큰) — VARCHAR(36)
  • queue_num (큐 번호) — INT
  • status (큐 상태) — VARCHAR(20)
  • expires_at (만료시간) — TIMESTAMP
  • created_at (생성일) — CURRENT_TIMESTAMP

Reservation (예매)

  • reservation_id (예약 id) — INT — Primary key — NOT NULL
  • user_id (사용자 id) — INT — Foreign key → User.user_id — NOT NULL
  • concert_id (콘서트 id) — INT — Foreign key → Concert.concert_id — NOT NULL
  • status (상태) — VARCHAR(20)
  • expired_at (만료 시간) — TIMESTAMP
  • created_at (생성일) — CURRENT_TIMESTAMP

User (사용자)

  • user_id (사용자 id) — INT — Primary key — NOT NULL
  • balance (잔고) — BigDecimal
  • created_at (생성일) — CURRENT_TIMESTAMP
  • updated_at (수정일) — CURRENT_TIMESTAMP