---

erDiagram
    DISCIPLINE ||--o{ LESSON : "scheduled as"
    TEACHER ||--o{ LESSON : "teaches"
    STUDENT ||--o{ APPLICATION : "submits"
    DISCIPLINE ||--o{ APPLICATION : "requested"

    DISCIPLINE {
        int id PK
        string name
        int hours
    }
    TEACHER {
        int id PK
        string full_name
    }
    LESSON {
        int id PK
        date lesson_date
        time start_time
        string lesson_type
        int discipline_id FK
        int teacher_id FK
    }
    STUDENT {
        int id PK
        string full_name
        string organization
    }
    APPLICATION {
        int id PK
        date app_date
        string status
        int student_id FK
        int discipline_id FK
    }