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