test

Tables (9)

seat

  • seat_id — BIGINT — Primary key — NOT NULL
  • seat_section_id — BIGINT — Foreign key → seat_section.seat_section_id — NOT NULL
  • seat_row — VARCHAR — NOT NULL
  • seat_number — BIGINT — NOT NULL

seat_section

  • seat_section_id — BIGINT — Primary key — NOT NULL
  • venue_id — BIGINT — Foreign key → venue.venue_id — NOT NULL
  • name — VARCHAR — NOT NULL
  • floor — BIGINT

show

  • show_id — BIGINT — Primary key — NOT NULL
  • venue_id — BIGINT
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • runtime_min — INT
  • age_limit — INT
  • poster_url — VARCHAR(500)
  • start_time — TIMESTAMP
  • end_time — TIMESTAMP
  • notice_url

show_schedule

  • show_schedule_id — BIGINT — Primary key — NOT NULL
  • starts_at — TIMESTAMP — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • show_id — BIGINT — Foreign key → show.show_id — NOT NULL

show_schedule (ticketing_show_schedule)

  • show_schedule_id — BIGINT — Primary key — NOT NULL
  • show_id — BIGINT
  • status — VARCHAR
  • title — VARCHAR
  • start_time — TIMESTAMP

show_schedule_seat

  • show_schedule_seat_id — BIGINT — Primary key — NOT NULL
  • show_section_price_id — BIGINT — Foreign key → show_section_price.show_section_price_id — NOT NULL
  • seat_id — BIGINT
  • status — VARCHAR(20) — NOT NULL
  • show_schedule_id — BIGINT
  • seat_row — VARCHAR
  • seat_number — VARCHAR
  • section_name — VARCHAR
  • section_floor — BIGINT

show_section_grade

  • id — BIGINT — Primary key — NOT NULL
  • show_id — BIGINT — Foreign key → show.show_id — NOT NULL
  • grade_name — VARCHAR
  • price — BIGINT

show_section_price

  • show_section_price_id — BIGINT — Primary key — NOT NULL
  • show_schedule_id — BIGINT — Foreign key → show_schedule.show_schedule_id — NOT NULL
  • seat_section_id — BIGINT
  • show_section_grade_id — BIGINT
  • is_active — BOOLEAN — NOT NULL
  • grade_name — VARCHAR
  • price — BIGINT

venue

  • venue_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • address — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL