Ticketing
Tables (6)
concert (콘서트 정보)
- id (concert_id) — long — Primary key — NOT NULL
- title (Field) — archar
- description (Field2) — TEXT
- created_at (Field3) — datetime
- updated_at (Field4) — datetime
concert_schedule (콘서트_스케줄(날짜, 회차))
- id (concert_schedule_id) — long — Primary key — NOT NULL
- id (concert_id) — long — Foreign key → concert.id — NOT NULL
- concert_date (Field) — datetime
- total_seats (Field2) — int
- created_at (Field3) — datetime
- updated_at (Field4) — datetime
payment (결제 정보(PG사, 금액, 상태))
- id (payment_id) — long — Primary key — NOT NULL
- id (reservation_id) — long — Foreign key → reservation.id — NOT NULL
- amount (Field) — decimal
- payment_key (Field2) — varchar
- status (Field3) — enum
- created_at (Field4) — datetime
- updated_at (Field5) — datetime
reservation (예약 정보(누가, 언제, 어떤 좌석을 찜했나))
- id (reservation_id) — long — Primary key — NOT NULL
- id (user_id) — Long — Foreign key → user.id — NOT NULL
- id (seat_id) — long — Foreign key → seat.id — NOT NULL
- expired_at (Field) — datetime
- created_at (Field2) — datetime
- updated_at (Field3) — datetime
seat (좌석 정보(번호, 가격, 등급, 상태, 버전))
- id (seat_id) — long — Primary key — NOT NULL
- id (concert_schedule_id) — long — Foreign key → concert_schedule.id — NOT NULL
- seat_no (Field) — int
- price (Field2) — decimal(10,2)
- status (Field3) — varchar
- version (Field4) — big int
- created_at (Field5) — datetime
- updated_at (Field6) — date_time
user (사용자)
- id (user_id) — Long — Primary key — NOT NULL
- email (Field) — varchar
- password (Field2) — varchar
- name (Field3) — varchar
- created_at (Field4) — timestamp
- updated_at (Field5)