## Location

id | address | postal_code
--- | --- | ---
1 | 123 Main St | 60601
2 | 456 Elm St | 60602

## Company

id | company_name | industry
--- | --- | ---
1 | TechCorp | Technology
2 | HealthCo | Healthcare

## Department

id | department_name | company_id
--- | --- | ---
|  | (→ Company.id)
1 | Engineering | 1
2 | Marketing | 1

## Employee

id | first_name | last_name | email | 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

## Application

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

## Internship

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