## Time_Periods

ID | Name
--- | ---
1 | Ancient Rome
2 | Middle Ages

## Historians

ID | Name | BirthDate | DeathDate | EraID
--- | --- | --- | --- | ---
|  |  |  | (→ Time_Periods.ID)
1 | Plutarch | 46 AD | 120 AD | 1
2 | Gibbon | 1737 | 1794 | 2

## Archeologists

ID | Name | BirthDate | DeathDate | EraID
--- | --- | --- | --- | ---
|  |  |  | (→ Time_Periods.ID)
1 | Howard Carter | 1874 | 1939 | 1
2 | Zahi Hawass | 1947 | 2021 | 3

## JobPostings

ID | Title | Description | Location | Salary | PostedDate | ClosingDate
--- | --- | --- | --- | --- | --- | ---
1 | Software Engineer | Develop and maintain software applications. | New York | 80000.0 | 2023-01-01 | 2023-02-01
2 | Data Scientist | Analyze large datasets and provide insights. | San Francisco | 100000.0 | 2023-01-15 | 2023-02-15

## Applicants

ID | FirstName | LastName | EmailAddress | PhoneNumber | ApplicationDate
--- | --- | --- | --- | --- | ---
1 | John | Smith | johnsmith@email.com | 123-456-7890 | 2023-01-10
2 | Jane | Doe | janedoe@email.com | 098-765-4321 | 2023-01-15

## Applications

ApplicationID | ApplicantID | JobPostingID | SubmissionDate | Status
--- | --- | --- | --- | ---
| (→ Applicants.ID) | (→ JobPostings.ID) |  |
1 | 1 | 1 | 2023-01-15 | Pending
2 | 2 | 2 | 2023-01-20 | Rejected