erDiagram
    Profile {
    }
    Publication {
    }
    WorkExperience {
    }
    JobOpportunity {
    }
    Contract {
    }
    Project {
    }
    Skill {
    }
    Client {
    }
    Course {
    }
    Degree {
    }
    Person {
    }
    Organization {
    }
    Award {
    }
    Article {
    }

%% Profile table %%
    Profile |{--o{ Publication : publications
    Profile |{--o{ WorkExperience : work_experiences
    Profile |{--o{ JobOpportunity : job_oportunities
    
%% Job oportunity table %%
	%% No new relationships %%

%% Work experience table %%
	WorkExperience ||--o{ Contract : contracts
	WorkExperience ||--o{ Project : projects
	WorkExperience |o--o{ Publication : publications

%% Project table %%
	Project }|--o{ Skill : skills_used
	Project }|--|| Client : client_supervisor
    Project }|--|| Contract : contracts

%% Contract table %%
	%% No new relationships %%

%% Skill table %%
    Skill }|--o| Skill : parent
    Skill }|--o{ Course : skills_used

%% Course table %%
    Course ||--o| Degree : part_of

%% Article table %%
    Article }o--o{ Project : related_project
    Article }o--o{ Skill : related_skill

%% Client table %%
    Client ||--o| Person : is_a
    Client ||--o| Organization : is_a

%% Publication table %%
    %% No new relationships %%

%% Degree table %%
    Degree ||--o| Organization : granted_by

%% Award table %%
    Award }o--|{ Project : related_project