---

erDiagram
    shows ||--|{ show_cast : "Входит в труппу"
    shows ||--|{ tour_schedule : "Организует гастроли"
    shows ||--|{ circus_program : "Планирует показы"
    employees ||--|{ show_cast : "Участвует в роли"

    shows {
        int show_id PK
        string title
        string stage_director
        string production_designer
        string conductor
        string author
        string genre
        string show_type
    }
    
    employees {
        int employee_id PK
        string last_name
        string first_name
        string middle_name
        int birth_year
        int hire_year
        int experience_years
        string position
        string gender
        string address
        string city
        string phone_number
    }
    
    show_cast {
        int cast_id PK
        int show_id FK
        int employee_id FK
        string role_name
    }
    
    tour_schedule {
        int tour_id PK
        int show_id FK
        date start_date
        date end_date
        string venue
    }
    
    circus_program {
        int program_id PK
        int show_id FK
        date premiere_date
        string run_period
        string show_times
        decimal ticket_price
    }