k-pop-ticketing
테이블 (7)
결제 (payments)
- id — BIGINT — 기본 키 — NOT NULL
- user_id (userId) — BIGINT — 외래 키 → 유저.id — NOT NULL
- amount — INT — NOT NULL
- status — VARCHAR — NOT NULL
- type — VARCHAR — NOT NULL
- created_at (createdAt) — DATETIME — NOT NULL
- updated_at (updatedAt) — DATETIME — NOT NULL
공연 (shows)
- id — BIGINT — 기본 키 — NOT NULL
- concert_id (concertId) — BIGINT — 외래 키 → 콘서트.id — NOT NULL
- start_date (startDate) — DATETIME — NOT NULL
- capacity — INT — NOT NULL
- created_at (createdAt) — DATETIME — NOT NULL
- updated_at (updatedAt) — DATETIME — NOT NULL
대기열 토큰 (waiting_token)
- id — BIGINT — 기본 키 — NOT NULL
- token — VARCHAR — NOT NULL
- expired_at (expiredAt) — DATETIME — NOT NULL
- status — VARCHAR — NOT NULL
예약 (reservations)
- id — BIGINT — 기본 키 — NOT NULL
- user_id (userId) — BIGINT — 외래 키 → 유저.id — NOT NULL
- show_id (showId) — BIGINT — 외래 키 → 좌석.show_id — NOT NULL
- seat_id (seatId) — BIGINT — 외래 키 → 좌석.id — NOT NULL
- reservation_status (reservationStatus) — VARCHAR — NOT NULL
- created_at (createdAt) — DATETIME — NOT NULL
- updated_at (updatedAt) — DATETIME — NOT NULL
유저 (users)
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR — NOT NULL
- balance — INT — NOT NULL
- created_at (createdAt) — DATETIME — NOT NULL
- updated_at (updatedAt) — DATETIME — NOT NULL
좌석 (seats)
- id — BIGINT — 기본 키 — NOT NULL
- show_id (showId) — BIGINT — 외래 키 → 공연.id — NOT NULL
- number — INT — NOT NULL
- amount — INT — NOT NULL
- status — VARCHAR — NOT NULL
- created_at (createdAt) — DATETIME — NOT NULL
- updated_at (updatedAt) — DATETIME — NOT NULL
콘서트 (concerts)
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR — NOT NULL
- created_at (createdAt) — DATETIME — NOT NULL
- updated_at (updatedAt) — DATETIME — NOT NULL