CompanyID | Name | Location |
---|---|---|
1 | ABC Corp. | New York |
2 | XYZ Inc. | San Francisco |
RoleID | RoleName |
---|---|
1 | Economist |
2 | Statistician |
DataTypeID | DataTypeName |
---|---|
1 | Demographics |
2 | Financial Analysis |
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 |
ApplicantID | FirstName | LastName | |
---|---|---|---|
1 | John | Doe | john.doe@example.com |
2 | Jane | Smith | jane.smith@example.com |
ApplicationID | ApplicantID | JobID | SubmissionDate | Status |
---|---|---|---|---|
(→ Applicants.ApplicantID) | (→ Jobs.JobID) | |||
1 | 1 | 1 | 2023-01-01 | Pending |
2 | 2 | 2 | 2023-01-02 | Pending |