job_posting

idtitledescriptionit_jobsoperating_system_knowledgesalarycreated_at
1IT Support TechSupport users with computer issues.IT Support TechnicianWindows30000.02024-03-07 22:29:45
2Linux AdminManage Linux servers.IT Support TechnicianLinux40000.02024-03-07 22:29:45
3NetAdminMaintain network infrastructure.Network AdministratorWindows60000.02024-03-07 22:29:45
4CloudOps EngineerImplement cloud solutions.Network AdministratorAWS80000.02024-03-07 22:29:45
5Software DeveloperDevelop software applications.75000.02024-03-07 22:29:45
6Web DesignerDesign user interfaces.55000.02024-03-07 22:29:45

company

idnameemailwebsite
1TechCorpinfo@techcorp.comwww.techcorp.com
2SoftDev Inccontact@softdevinc.comwww.softdevinc.com
3Innovate Ltdhelpdesk@innovateltd.comwww.innovateltd.com
4DataWarehouse AGsales@datawarehouseag.comwww.datawarehouseag.com

location

idcitystatecountry
1New YorkNYUSA
2ChicagoILUSA
3LondonEnglandUK
4ParisIle-de-FranceFrance

employee

idnameemailphonecompany_idlocation_id
(→ company.id)(→ location.id)
1John Doejohn.doe@example.com123-456-789011
2Jane Smithjane.smith@example.com098-765-432112
3Alice Johnsonalice.johnson@example.com555-123-456723
4Bob Brownbob.brown@example.com555-987-654324