## Companies

CompanyID | Name | Location
--- | --- | ---
1 | ABC Corp. | New York
2 | XYZ Inc. | San Francisco

## Roles

RoleID | RoleName
--- | ---
1 | Economist
2 | Statistician

## DataTypes

DataTypeID | DataTypeName
--- | ---
1 | Demographics
2 | Financial Analysis

## Jobs

JobID | Title | Description | PostedDate | CompanyID | ROLEID | DATAID
--- | --- | --- | --- | --- | --- | ---
|  |  |  | (→ Companies.CompanyID) | (→ Roles.RoleID) | (→ DataTypes.DataTypeID)
1 | Economic Analyst | Analyze economic data... | 2023-01-01 | 1 | 1 | 1
2 | Economic Analyst | Analyze economic data... | 2023-01-02 | 2 | 1 | 2
3 | Statistical Analyst | Analyze statistical data... | 2023-01-01 | 1 | 2 | 1
4 | Statistical Analyst | Analyze statistical data... | 2023-01-02 | 2 | 2 | 2

## Applicants

ApplicantID | FirstName | LastName | Email
--- | --- | --- | ---
1 | John | Doe | john.doe@example.com
2 | Jane | Smith | jane.smith@example.com

## ApplicationJobs

ApplicationID | ApplicantID | JobID | SubmissionDate | Status
--- | --- | --- | --- | ---
| (→ Applicants.ApplicantID) | (→ Jobs.JobID) |  |
1 | 1 | 1 | 2023-01-01 | Pending
2 | 2 | 2 | 2023-01-02 | Pending