id | address | postal_code |
---|---|---|
1 | 123 Main St | 60601 |
2 | 456 Elm St | 60602 |
id | city_name | country |
---|---|---|
1 | Chicago | USA |
2 | New York | USA |
id | company_name | industry |
---|---|---|
1 | TechCorp | Technology |
2 | HealthCo | Healthcare |
id | title | description | start_date | end_date | office_address_id | city_id |
---|---|---|---|---|---|---|
(→ Office_Address.id) | (→ City.id) | |||||
1 | Software Engineer | Develop and maintain software applications. | 2022-07-01 | 2023-08-31 | 1 | 1 |
2 | Data Analyst | Analyze data to support business decisions. | 2022-09-01 | 2023-12-31 | 2 | 2 |
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 | 1 |
2 | Charlie | Green | 2024-02-19 12:32:36 | 2 | 2 |