hhplus-concert-service

Tables (8)

Balance (잔액)

  • balance_id (잔액ID) — BIGINT — Primary key — NOT NULL
  • user_id (유저_ID) — INTEGER — Foreign key → User.user_id — NOT NULL
  • balance (잔액) — BIGINT
  • create_at (생성일시) — TIMESTAMP

Concert (콘서트)

  • concert_id (콘서트ID) — BIGINT — Primary key — NOT NULL
  • concert_title (콘서트타이틀) — VARCHAR(255)

Concert_Detail (콘서트 정보)

  • detail_id (정보ID) — BIGINT — Primary key — NOT NULL
  • concert_id (콘서트ID) — BIGINT — Foreign key → Concert.concert_id — NOT NULL
  • concert_date (콘서트일시) — TIMESTAMP

Concert_seat (좌석)

  • seat_id (좌석ID) — BIGITN — Primary key — NOT NULL
  • detail_id (정보ID) — BIGINT — Foreign key → Concert_Detail.detail_id — NOT NULL
  • seat_no (좌석번호) — VARCHAR(50)
  • status (상태) — VARCHAR(50)
  • seat_price (좌석가격) — INT

Queue (대기열)

  • queue_id (대기열ID) — BIGINT — Primary key — NOT NULL
  • user_id (유저_ID) — BIGINT — Foreign key → User.user_id — NOT NULL
  • token (토근) — BIGINT
  • status (상태) — VARCHAR(50)
  • created_at (번호 생성시점) — TIMESTAMP
  • entered_at (활성시점) — TIMESTAMP
  • update_at (데이터 변경) — TIMESTAMP

Reservation (예약)

  • reservation_id (예약ID) — BIGINT — Primary key — NOT NULL
  • concert_id (콘서트ID) — BIGINT — Foreign key → Concert.concert_id — NOT NULL
  • user_id (유저_ID) — INTEGER — Foreign key → User.user_id — NOT NULL
  • concert_title (콘서트타이틀) — VARCHAR(255)
  • reservation_date (예약일자) — TIMESTAMP
  • status (상태) — VARCHAR(50)
  • pay_amount (결제금액) — INT
  • seat_id (좌석ID) — BIGITN — Foreign key → Concert_seat.seat_id — NOT NULL

Reservation_pay (결제)

  • pay_id (결제ID) — BIGINT — Primary key — NOT NULL
  • reservation_id (예약ID) — BIGINT — Foreign key → Reservation.reservation_id — NOT NULL
  • pay_date (결제일자) — TIMESTAMP
  • pay_amount (금액) — INT
  • status (상태) — VARCHAR(50)
  • user_id (유저_ID) — BIGINT — Foreign key → User.user_id — NOT NULL

User (사용자)

  • user_id (유저_ID) — BIGINT — Primary key — NOT NULL
  • name (이름) — VARCHAR(50)