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 |