TicketingService
Tables (9)
Ticket (ticket)
- 티켓아이디 (ticket) — Long — Primary key — NOT NULL
- 유저아이디 (member_id) — Long — Foreign key → Member.유저아이디 — NOT NULL
- 공연좌석아이디 (performance_seat_id) — Long — Foreign key → PerformanceSeat.공연좌석아이디 — NOT NULL
- 공연시간아이디 (id) — Long — Foreign key → PerformanceTimeTable.공연시간아이디 — NOT NULL
Member (member)
- 유저아이디 (member_id) — Long — Primary key — NOT NULL
- 이메일 (email) — String
- 비밀번호 (password) — String
- 닉네임 (nickname) — String
- 권한 (role) — String
Performance (performance)
- 공연아이디 (performance_id) — Long — Primary key — NOT NULL
- 공연장아이디 (venue_id) — Long — Foreign key → Venue.공연장아이디 — NOT NULL
- 공연이름 (performance_name) — String
- 공연정보 (performance_info) — String
- 티켓 오픈일 (ticket_open_date) — Date
- 티켓 마감일 (ticket_close_date) — Date
PerformancePrice (performance_price)
- 공연금액아이디 (performance_price_id) — Long — Primary key — NOT NULL
- 공연아이디 (performance_id) — Long — Foreign key → Performance.공연아이디 — NOT NULL
- 좌석 등급 (seat_grade) — String
- 좌석 금액 (seat_price) — Int
PerformanceSeat (performance_seat)
- 공연좌석아이디 (performance_seat_id) — Long — Primary key — NOT NULL
- 좌석아이디 (seat_id) — Long — Foreign key → Seat.좌석아이디 — NOT NULL
- 공연아이디 (performance_id) — Long — Foreign key → Performance.공연아이디 — NOT NULL
- 공연금액아이디 (performance_price_id) — Long — Foreign key → PerformancePrice.공연금액아이디 — NOT NULL
PerformanceTimeTable (performance_time_table)
- 공연시간아이디 (performance_time_id) — Long — Primary key — NOT NULL
- 공연아이디 (performance_id) — Long — Foreign key → Performance.공연아이디 — NOT NULL
- 공연날짜 및 시간 (performance_date_time) — Date
PerformanceVenueReservation (performance_venue_reservation)
- 아이디 (id) — Long — Primary key — NOT NULL
- 공연시간아이디 (performance_time_id) — Long — Foreign key → PerformanceTimeTable.공연시간아이디 — NOT NULL
- 공연장아이디 (venue_id) — Long — Foreign key → Venue.공연장아이디 — NOT NULL
Seat (seat)
- 좌석아이디 (seat_id) — Long — Primary key — NOT NULL
- 공연장아이디 (venue_id) — Long — Foreign key → Venue.공연장아이디 — NOT NULL
- 구역 (seat_area) — String
- 좌석 번호 (seat_number) — Int
Venue (venue)
- 공연장아이디 (venue_id) — Long — Primary key — NOT NULL
- 공연장이름 (venue_name) — String
- 공연장위치 (venue_location) — String
- 공연장정보 (venue_info) — String