Designers

idnameexperience
1Alice3
2Bob2
3Carol5
4Dave1
5Eve4

Tools

tool_namedescription
Adobe Creative SuiteA collection of graphic design software
IllustratorA vector graphics editor
PhotoshopAn image editing software
InDesignPage layout and typesetting software
Premiere ProVideo editing software

Designer_Tools

designer_idtool_name
(→ Designers.id)(→ Tools.tool_name)
1Adobe Creative Suite
1Illustrator
2Photoshop
3InDesign
4Premiere Pro
1Photoshop
3Photoshop
4Photoshop
5Photoshop

Companies

company_idcompany_namelocation
1Tech Company OneNew York
2Software Inc.San Francisco
3Web SolutionsLos Angeles
4App DevelopersChicago
5Technology GroupWashington DC

JobPostings

posting_idtitledescriptionsalaryposted_datecompany_id
(→ Companies.company_id)
1UX/UI DesignerWe need a UX/UI designer to create user interfaces for our new product line700002022-08-011
2Graphic DesignerOur team needs an experienced graphic designer to work on various projects600002022-09-012
3Web DeveloperWe are looking for a web developer to join our growing team750002022-08-053
4Mobile App DeveloperWe want a mobile app developer to help us build our next big app800002022-08-104
5Data AnalystLooking for data analyst to support business decisions650002022-08-155

Applications

application_idapplicant_nameemailresume_pathstatusjob_posting_id
(→ JobPostings.posting_id)
1John Doejohndoe@email.com/resume/john_doe.pdfPending1
2Jane Smithjanesmith@email.com/resume/jane_smith.pdfAccepted2
3Mike Brownmikebrown@email.com/resume/mike_brown.pdfRejected3
4Emily Johnsonemilyjohnson@email.com/resume/emily_johnson.pdfPending4
5Tom Greentomgreen@email.com/resume/tom_green.pdfAccepted5