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