id | name | address | phone_number |
---|---|---|---|
1 | Company A | Address A | Phone Number A |
2 | Company B | Address B | Phone Number B |
3 | Company C | Address C | Phone Number C |
4 | Company D | Address D | Phone Number D |
5 | Company E | Address E | Phone Number E |
id | company_id | department_name |
---|---|---|
(→ Companies.id) | ||
1 | 1 | HR Department |
2 | 1 | IT Department |
3 | 2 | Marketing Department |
4 | 2 | Finance Department |
5 | 3 | Engineering Department |
id | title | description | salary | post_date | department_id |
---|---|---|---|---|---|
(→ Departments.id) | |||||
1 | Software Engineer | Develop software solutions. | 70000 | 2022-06-01 | 1 |
2 | Data Analyst | Analyze data and provide insights. | 60000 | 2022-06-02 | 2 |
3 | Project Manager | Lead projects and coordinate teams. | 80000 | 2022-06-03 | 3 |
4 | Web Developer | Design and develop websites. | 65000 | 2022-06-04 | 4 |
5 | Graphic Designer | Create visual designs. | 50000 | 2022-06-05 | 5 |
id | first_name | last_name | phone_number | |
---|---|---|---|---|
1 | John | Smith | johnsmith@email.com | 123-456-7890 |
2 | Jane | Doe | janedoe@email.com | 098-765-4321 |
3 | Alice | Brown | alicebrown@email.com | 555-123-4567 |
4 | Charlie | White | charliewhite@email.com | 555-456-7890 |
5 | David | Green | davidgreen@email.com | 555-789-1234 |
id | job_posting_id | applicant_id | status | application_date |
---|---|---|---|---|
(→ JobPostings.id) | (→ Applicants.id) | |||
1 | 1 | 1 | Pending | 2022-06-01 |
2 | 1 | 2 | Rejected | 2022-06-02 |
3 | 2 | 1 | Accepted | 2022-06-03 |
4 | 2 | 2 | Rejected | 2022-06-04 |
5 | 3 | 1 | Interview Scheduled | 2022-06-05 |
id | career_option | university_id |
---|---|---|
(→ Universities.id) | ||
1 | Chemist | 1 |
2 | Chemist | 2 |
3 | Geoscientist | 1 |
4 | Geoscientist | 2 |
5 | Environmental Scientist | 1 |
id | name |
---|---|
1 | Massachusetts Institute of Technology (MIT) |
2 | Stanford University |
3 | California Institute of Technology (Caltech) |
4 | Harvard University |
5 | Princeton University |