| id | name | address | phone | |
|---|---|---|---|---|
| 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 |
| id | profession |
|---|---|
| 1 | Sales Representative |
| 2 | Marketing Manager |
| id | commission |
|---|---|
| 1 | Base Salary Plus Commission |
| 2 | Salaried Position |
| 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 |
| id | firstname | lastname | phone | |
|---|---|---|---|---|
| 1 | John | Doe | john.doe@example.com | +1 555-555-5557 |
| 2 | Jane | Smith | jane.smith@example.com | +1 555-555-5558 |
| 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 |