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