erDiagram
    COMPANY {
        int id PK
        string name
        string sector
    }
    TALENTPARTNER {
        string name
        string email
    }
    ROLE-STATUS {
        string status
        string description
    }
    ROLE-TYPE {
        string type
        string description
    }
    ROLE {
        int id
        string company
        string department
        string role-type
        string status
        string owner
        date start-date
        data created
    }
    CANDIDATE {
        string productCode
        int quantity
        float pricePerUnit
    }
    COMPANY ||--o{ ROLE : roles
    TALENTPARTNER ||--o{ COMPANY : working-with
    TALENTPARTNER ||--o{ ROLE : owner
    ROLE ||--o| ROLE-TYPE : type
    ROLE ||--o| ROLE-STATUS : status
    CANDIDATE ||--o{ ROLE : appying-for