콘서트예매

테이블 (9)

balance (잔액)

  • balance_id (잔액ID) — BIGINT — 기본 키 — NOT NULL
  • user_id (유저ID) — BIGINT — 외래 키 → user.user_id
  • balance (잔액) — INT

balance_history (충전/사용내역)

  • balancehistory_id (충전내역ID) — BIGINT — 기본 키
  • balance_id (잔액ID) — 외래 키 → balance.balance_id — NOT NULL
  • amount (금액) — INT — NOT NULL
  • type (타입) — VARCHAR(50)
  • created_date (생성일시) — TIMESTAMP

concert (콘서트)

  • concert_id (콘서트ID) — BIGINT — 기본 키 — NOT NULL
  • cocert_title (콘서트타이틀) — VARCHAR(255) — NOT NULL

concert_detail (콘서트정보)

  • detail_id (스케쥴ID) — BIGINT — 기본 키
  • concert_id (콘서트ID) — BIGINT — 외래 키 → concert.concert_id
  • concert_date (콘서트일시) — DATETIME — NOT NULL

concert_seat (좌석)

  • seat_id (좌석ID) — BIGINT — 기본 키
  • detail_id (스케쥴ID) — BIGINT — 외래 키 → concert_detail.detail_id
  • seat_no (좌석번호) — VARCHAR(50) — NOT NULL
  • status (상태) — VARCHAR(50) — NOT NULL
  • seat_price (가격) — INT — NOT NULL

reservation (예약)

  • reservation_id (예약ID) — BIGINT — 기본 키
  • user_id (유저ID) — BIGINT — 외래 키 → user.user_id
  • seat_id (좌석ID) — BIGINT — 외래 키 → concert_seat.seat_id
  • concert_title (콘서트타이틀) — VARCHAR(255)
  • reservation_date (예약일자) — TIMESTAMP — NOT NULL
  • status (상태) — VARCHAR(50) — NOT NULL
  • total_price (총액) — INT — NOT NULL

reservation_pay (결제)

  • pay_id (결제ID) — BIGINT — 기본 키
  • reservation_id (예약ID) — BIGINT — 외래 키 → reservation.reservation_id
  • pay_date (결제일자) — TIMESTAMP — NOT NULL
  • pay_amount (금액) — INT — NOT NULL
  • status (상태) — VARCHAR(50) — NOT NULL

user (유저)

  • user_id (유저ID) — BIGINT — 기본 키

user_queue (대기열)

  • queue_id (대기열ID) — BIGINT — 기본 키
  • user_id (유저ID) — BIGINT — 외래 키 → user.user_id
  • token (토큰) — VARCHAR(255) — NOT NULL
  • status (상태) — VARCHAR(50) — NOT NULL
  • created_date (생성일시) — TIMESTAMP — NOT NULL
  • expiry_date (만료일시) — TIMESTAMP — NOT NULL