test2

Tables (7)

seat

  • seat_id — BIGINT — Primary key — NOT NULL
  • seat_section_id — BIGINT — Foreign key → seat_section.seat_section_id — NOT NULL
  • row_label — VARCHAR(20) — NOT NULL
  • col_no — INT — NOT NULL
  • seat_label — VARCHAR(50)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

seat_section

  • seat_section_id — BIGINT — Primary key — NOT NULL
  • venue_id — BIGINT — Foreign key → venue.venue_id — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • floor — INT
  • sort_order — INT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

show

  • show_id — BIGINT — Primary key — NOT NULL
  • venue_id — BIGINT — Foreign key → venue.venue_id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • runtime_min — INT
  • age_limit — INT
  • poster_url — VARCHAR(500)
  • start_at — TIMESTAMP
  • end_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

show_schedule

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

show_schedule_seat

  • show_schedule_seat_id — BIGINT — Primary key — NOT NULL
  • show_schedule_id — BIGINT — Foreign key → show_schedule.show_schedule_id — NOT NULL
  • seat_id — BIGINT — Foreign key → seat.seat_id — NOT NULL
  • show_section_price_id — BIGINT — Foreign key → show_section_price.show_section_price_id — NOT NULL
  • show_id — BIGINT — NOT NULL
  • venue_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • hold_token — VARCHAR(100)
  • hold_expires_at — TIMESTAMP
  • grade_snapshot — VARCHAR(50)
  • price_snapshot — BIGINT
  • show_section_price_grade_name_snapshot — VARCHAR(50)
  • show_section_price_color_code_snapshot — VARCHAR(20)
  • show_section_price_sort_order_snapshot — INT
  • seat_section_id_snapshot — BIGINT — NOT NULL
  • seat_section_code_snapshot — VARCHAR(50) — NOT NULL
  • seat_section_name_snapshot — VARCHAR(100) — NOT NULL
  • seat_section_floor_snapshot — INT
  • seat_section_sort_order_snapshot — INT
  • seat_row_label_snapshot — VARCHAR(20) — NOT NULL
  • seat_col_no_snapshot — INT — NOT NULL
  • seat_label_snapshot — VARCHAR(50)
  • seat_display_key — VARCHAR(120) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

show_section_price

  • show_section_price_id — BIGINT — Primary key — NOT NULL
  • show_id — BIGINT — Foreign key → show.show_id — NOT NULL
  • seat_section_id — BIGINT — Foreign key → seat_section.seat_section_id — NOT NULL
  • grade_name — VARCHAR(50) — NOT NULL
  • price — BIGINT — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • color_code — VARCHAR(20)
  • sort_order — INT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

venue

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