typha_we_ticket (temp)
Tables (4)
performances
- performance_id — INT
- title — VARCHAR(200) — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- runtime — INT — NOT NULL
- age_rating — ENUM('전체관람가', '7세이상', '12세이상', '15세이상', '18세이상') — NOT NULL
- genre — ENUM('뮤지컬', '연극', '콘서트', '클래식', '무용', '국악', '기타') — NOT NULL
- venue_id — INT — NOT NULL
- main_image — LONGBLOB
- detail_image — LONGBLOB
- agency_name — VARCHAR(100) — NOT NULL
- ticket_open_datetime — DATETIME — NOT NULL
seat_pricing
- pricing_id — INT
- performance_id — INT — NOT NULL
- seat_grade — ENUM('VIP', 'R석', 'S석', 'A석', 'B석', 'C석', '스탠딩') — NOT NULL
- price — INT — NOT NULL
seats
- performance_id — INT — Primary key — NOT NULL
- seat_number — VARCHAR(20) — Primary key — NOT NULL
- reservation_status — ENUM('available', 'reserved', 'sold')
venues
- 공연장 ID (venue_id) — INT
- name — VARCHAR(150) — NOT NULL
- location — VARCHAR(300) — NOT NULL