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