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)