Office_Address

idaddresspostal_code
1123 Main St60601
2456 Elm St60602

City

idcity_namecountry
1ChicagoUSA
2New YorkUSA

Company

idcompany_nameindustry
1TechCorpTechnology
2HealthCoHealthcare

Internship

idtitledescriptionstart_dateend_dateoffice_address_idcity_id
(→ Office_Address.id)(→ City.id)
1Software EngineerDevelop and maintain software applications.2022-07-012023-08-3111
2Data AnalystAnalyze data to support business decisions.2022-09-012023-12-3122

Department

iddepartment_namecompany_id
(→ Company.id)
1Engineering1
2Marketing1

Employee

idfirst_namelast_nameemailphone_numberhire_datedepartment_id
(→ Department.id)
1JohnDoejohn.doe@example.com555-12342022-01-011
2JaneSmithjane.smith@example.com555-56782022-02-012

Application

idapplicant_first_nameapplicant_last_nameapplication_dateinternship_idemployee_id
(→ Internship.id)(→ Employee.id)
1AliceBrown2024-02-19 12:32:3611
2CharlieGreen2024-02-19 12:32:3622