Location

idaddresspostal_code
1123 Main St60601
2456 Elm St60602

Company

idcompany_nameindustry
1TechCorpTechnology
2HealthCoHealthcare

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:361None
2CharlieGreen2024-02-19 12:32:362None

Internship

idtitledescriptionstart_dateend_dateoffice_address_id
(→ Location.id)
1Software EngineerDevelop and maintain software applications.2022-07-012023-08-311
2Data AnalystAnalyze data to support business decisions.2022-09-012023-12-312