| CompanyID | Name | Industry |
|---|---|---|
| 1 | Tech Solutions Inc. | Technology |
| 2 | Healthy Living LLC | Healthcare |
| 3 | Financial Services Co. | Banking |
| 4 | Green Energy Corp. | Energy |
| 5 | Creative Studios Ltd. | Entertainment |
| LocationID | City | State | Country |
|---|---|---|---|
| 1 | New York | NY | USA |
| 2 | Los Angeles | CA | USA |
| 3 | Chicago | IL | USA |
| 4 | Toronto | ON | Canada |
| 5 | London | England | UK |
| ApplicantID | FirstName | LastName | PhoneNumber | |
|---|---|---|---|---|
| 1 | John | Doe | john.doe@example.com | +1234567890 |
| 2 | Jane | Smith | jane.smith@example.com | +0987654321 |
| 3 | Michael | Johnson | michael.johnson@example.com | +1357924680 |
| 4 | Emily | Williams | emily.williams@example.com | +0123456789 |
| 5 | David | Brown | david.brown@example.com | +9876543210 |
| JobID | Title | Description | CompanyID | Business_Profession | Working_Arrangement | LocationID | PostedDate | CloseDate |
|---|---|---|---|---|---|---|---|---|
| (→ Companies.CompanyID) | (→ Locations.LocationID) | |||||||
| 1 | Sales Manager | Manage sales team and drive revenue growth. | 1 | Sales Manager | Hybrid | 1 | CURRENT_TIMESTAMP | 2023-01-31 |
| 2 | Senior Sales Manager | Lead and manage a high-performing sales team. | 2 | Sales Manager | In-Office | 2 | CURRENT_TIMESTAMP | 2023-01-31 |
| 3 | Marketing Specialist | Create and execute marketing strategies to increase brand awareness. | 1 | Marketing Specialist | Hybrid | 1 | CURRENT_TIMESTAMP | 2023-01-31 |
| 4 | Junior Marketing Specialist | Develop and implement effective marketing campaigns. | 3 | Marketing Specialist | Remote | 3 | CURRENT_TIMESTAMP | 2023-01-31 |