erDiagram
    User {
        int id pk
        string login
        string firstname
        string lastname
        string middlename
        date birthday
        int user_worker_id fk
    }

    Patient {
        string firstname
        string lastname
        string middlename
        date birthday
    }

    UserWorker {
        int id pk
        int role_id fk
        int specialization_id fk
    }

    Role {
        int id pk
        string title
    }

    Specialization {
        int id pk
        string title
    }

    PatientVisitResult {
        int id pk
        %% регистратор
        int user_id fk
        %% пациент
        int patient_id fk
        int visit_result_id fk
        datetime date
    }

    VisitResult {
        int id pk
        string diagnosis
        string note
    }

    User ||--o{ UserWorker : ""
    Role ||--o{ UserWorker : ""
    Specialization ||--o{ UserWorker : ""

    User ||--o{ PatientVisitResult : ""
    Patient ||--o{ PatientVisitResult : ""
    PatientVisitResult ||--o| VisitResult : ""

Loading