| id | address | postal_code |
|---|---|---|
| 1 | 123 Main St | 60601 |
| 2 | 456 Elm St | 60602 |
| id | company_name | industry |
|---|---|---|
| 1 | TechCorp | Technology |
| 2 | HealthCo | Healthcare |
| id | department_name | company_id |
|---|---|---|
| (→ Company.id) | ||
| 1 | Engineering | 1 |
| 2 | Marketing | 1 |
| id | first_name | last_name | phone_number | hire_date | department_id | |
|---|---|---|---|---|---|---|
| (→ Department.id) | ||||||
| 1 | John | Doe | john.doe@example.com | 555-1234 | 2022-01-01 | 1 |
| 2 | Jane | Smith | jane.smith@example.com | 555-5678 | 2022-02-01 | 2 |
| id | applicant_first_name | applicant_last_name | application_date | internship_id | employee_id |
|---|---|---|---|---|---|
| (→ Internship.id) | (→ Employee.id) | ||||
| 1 | Alice | Brown | 2024-02-19 12:32:36 | 1 | None |
| 2 | Charlie | Green | 2024-02-19 12:32:36 | 2 | None |
| id | title | description | start_date | end_date | office_address_id |
|---|---|---|---|---|---|
| (→ Location.id) | |||||
| 1 | Software Engineer | Develop and maintain software applications. | 2022-07-01 | 2023-08-31 | 1 |
| 2 | Data Analyst | Analyze data to support business decisions. | 2022-09-01 | 2023-12-31 | 2 |