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