id | name | experience |
---|---|---|
1 | Alice | 3 |
2 | Bob | 2 |
3 | Carol | 5 |
4 | Dave | 1 |
5 | Eve | 4 |
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_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 |
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 |
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 |
application_id | applicant_name | 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 |