## Designers

id | name | experience
--- | --- | ---
1 | Alice | 3
2 | Bob | 2
3 | Carol | 5
4 | Dave | 1
5 | Eve | 4

## Tools

tool_name | description
--- | ---
Adobe Creative Suite | A collection of graphic design software
Illustrator | A vector graphics editor
Photoshop | An image editing software
InDesign | Page layout and typesetting software
Premiere Pro | Video editing software

## Designer_Tools

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

## Companies

company_id | company_name | location
--- | --- | ---
1 | Tech Company One | New York
2 | Software Inc. | San Francisco
3 | Web Solutions | Los Angeles
4 | App Developers | Chicago
5 | Technology Group | Washington DC

## JobPostings

posting_id | title | description | salary | posted_date | company_id
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Companies.company_id)
1 | UX/UI Designer | We need a UX/UI designer to create user interfaces for our new product line | 70000 | 2022-08-01 | 1
2 | Graphic Designer | Our team needs an experienced graphic designer to work on various projects | 60000 | 2022-09-01 | 2
3 | Web Developer | We are looking for a web developer to join our growing team | 75000 | 2022-08-05 | 3
4 | Mobile App Developer | We want a mobile app developer to help us build our next big app | 80000 | 2022-08-10 | 4
5 | Data Analyst | Looking for data analyst to support business decisions | 65000 | 2022-08-15 | 5

## Applications

application_id | applicant_name | email | resume_path | status | job_posting_id
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ JobPostings.posting_id)
1 | John Doe | johndoe@email.com | /resume/john_doe.pdf | Pending | 1
2 | Jane Smith | janesmith@email.com | /resume/jane_smith.pdf | Accepted | 2
3 | Mike Brown | mikebrown@email.com | /resume/mike_brown.pdf | Rejected | 3
4 | Emily Johnson | emilyjohnson@email.com | /resume/emily_johnson.pdf | Pending | 4
5 | Tom Green | tomgreen@email.com | /resume/tom_green.pdf | Accepted | 5