Office

IDOffice_AddressCity
1123 Main StNew York
2456 Elm StLos Angeles
3789 Oak StChicago
4012 Pine StMiami
5321 Fir StBoston

Department

IDName
1Engineering
2Marketing
3Human Resources
4Finance
5IT

Internship_Position

IDPosition_TitleDescriptionDuration
1Software Engineering InternHelp develop software applications.12
2Graphic Design InternCreate visual designs for marketing materials.12
3HR InternAssist with recruitment and onboarding processes.12
4Financial Analyst InternAnalyze financial data and support decision-making.12
5Network Engineer InternSupport network infrastructure and troubleshoot issues.12

Employee

IDFirst_NameLast_NameEmailPhone_NumberHire_Date
1JohnDoejohn.doe@example.com+1 234-567-89012024-02-19 12:27:01
2JaneSmithjane.smith@example.com+1 345-678-90122024-02-19 12:27:01
3AliceJohnsonalice.johnson@example.com+1 456-789-01232024-02-19 12:27:01
4BobWilliamsbob.williams@example.com+1 567-890-12342024-02-19 12:27:01
5EmmaBrownemma.brown@example.com+1 678-901-23452024-02-19 12:27:01

Job_Posting

IDTitleDescriptionRequired_SkillsSalaryApplication_DeadlineOffice_IDDepartments_IDInternships_ID
(→ Office.ID)(→ Department.ID)(→ Internship_Position.ID)
1Software DeveloperDesign, code, and maintain software systems.JavaScript, HTML, CSS80000.02023-05-31 23:59:5911None
2Digital Marketing SpecialistPlan and execute digital marketing campaigns.SEO, SEM, Social Media60000.02023-05-31 23:59:5922None
3RecruiterSource, screen, and interview candidates.Applicant Tracking Systems50000.02023-05-31 23:59:5933None
4AccountantPrepare financial reports and analyze data.Excel, QuickBooks65000.02023-05-31 23:59:5944None
5System AdministratorInstall, configure, and maintain computer systems.Linux, Windows Server70000.02023-05-31 23:59:5955None

Applicant

IDFull_nameEmailPhone_numberResume_urlDate_appliedJob_posting_id
(→ Job_Posting.ID)
1John Doejohndoe@email.com+1 234-567-8901https://www.example.com/resume-john-doe2024-02-19 12:27:011
2Jane Smithjanesmith@email.com+1 345-678-9012https://www.example.com/resume-jane-smith2024-02-19 12:27:012
3Alice Johnsonalicejohnson@email.com+1 456-789-0123https://www.example.com/resume-alice-johnson2024-02-19 12:27:013
4Bob Williamsbobwilliams@email.com+1 567-890-1234https://www.example.com/resume-bob-williams2024-02-19 12:27:014
5Emma Brownemmabrown@email.com+1 678-901-2345https://www.example.com/resume-emma-brown2024-02-19 12:27:015