Companies

CompanyIDNameLocation
1ABC Corp.New York
2XYZ Inc.San Francisco

Roles

RoleIDRoleName
1Economist
2Statistician

DataTypes

DataTypeIDDataTypeName
1Demographics
2Financial Analysis

Jobs

JobIDTitleDescriptionPostedDateCompanyIDROLEIDDATAID
(→ Companies.CompanyID)(→ Roles.RoleID)(→ DataTypes.DataTypeID)
1Economic AnalystAnalyze economic data...2023-01-01111
2Economic AnalystAnalyze economic data...2023-01-02212
3Statistical AnalystAnalyze statistical data...2023-01-01121
4Statistical AnalystAnalyze statistical data...2023-01-02222

Applicants

ApplicantIDFirstNameLastNameEmail
1JohnDoejohn.doe@example.com
2JaneSmithjane.smith@example.com

ApplicationJobs

ApplicationIDApplicantIDJobIDSubmissionDateStatus
(→ Applicants.ApplicantID)(→ Jobs.JobID)
1112023-01-01Pending
2222023-01-02Pending