## Companies

id | name | address | phone | email
--- | --- | --- | --- | ---
1 | Company A | 123 Main St | +1 555-555-5555 | companyA@example.com
2 | Company B | 456 Elm St | +1 555-555-5556 | companyB@example.com

## Business_Professions

id | profession
--- | ---
1 | Sales Representative
2 | Marketing Manager

## Commissions

id | commission
--- | ---
1 | Base Salary Plus Commission
2 | Salaried Position

## Positions

id | title | description | company_id | business_profession_id | commission_id
--- | --- | --- | --- | --- | ---
|  |  | (→ Companies.id) | (→ Business_Professions.id) | (→ Commissions.id)
1 | Software Developer | Developing web applications | 1 | 1 | 1
2 | Graphic Designer | Creating visual content | 1 | 2 | 1
3 | Account Executive - Sales Representative | Closing sales deals | 2 | 1 | 2
4 | Digital Marketing Specialist | Managing online marketing campaigns | 2 | 3 | 3
5 | Product Manager - Marketing Manager | Overseeing product launches | 2 | 4 | 4

## Applicants

id | firstname | lastname | email | phone
--- | --- | --- | --- | ---
1 | John | Doe | john.doe@example.com | +1 555-555-5557
2 | Jane | Smith | jane.smith@example.com | +1 555-555-5558

## Application

id | position_id | applicant_id | application_date | status
--- | --- | --- | --- | ---
| (→ Positions.id) | (→ Applicants.id) |  |
1 | 1 | 1 | 2024-03-13 11:25:04 | Applied
2 | 2 | 2 | 2024-03-13 11:25:04 | Interview Scheduled
3 | 3 | 1 | 2024-03-13 11:25:04 | Rejected
4 | 4 | 2 | 2024-03-13 11:25:04 | Hired
5 | 5 | 1 | 2024-03-13 11:25:04 | On Hold