| id | name | address | phoneNumber |
|---|---|---|---|
| 1 | Company A | 123 Main St | 555-1234 |
| 2 | Company B | 456 Elm St | 555-5678 |
| 3 | Company C | 789 Oak St | 555-9012 |
| 4 | Company D | 321 Pine St | 555-1357 |
| 5 | Company E | 999 Maple Ave | 555-2468 |
| id | locationName | description |
|---|---|---|
| 1 | University's Main Library | The main library of a large university. |
| 2 | City Hall | A government building that serves as the administrative center of a city. |
| 3 | Private School | An independent school not funded by public taxes. |
| 4 | Hospital | A medical institution providing healthcare services. |
| 5 | Research Center | A facility dedicated to scientific research. |
| id | title | description | startDate | endDate | companyId |
|---|---|---|---|---|---|
| (→ Companies.id) | |||||
| 1 | Software Developer | Developing software applications. | 2022-01-01 | 2023-12-31 | 1 |
| 2 | Graphic Designer | Creating visual content. | 2022-02-01 | 2023-12-31 | 1 |
| 3 | Data Analyst | Analyzing data sets. | 2022-03-01 | 2023-12-31 | 2 |
| 4 | HR Specialist | Managing employee relations. | 2022-04-01 | 2023-12-31 | 2 |
| 5 | Marketing Manager | Overseeing marketing campaigns. | 2022-05-01 | 2023-12-31 | 3 |
| id | informationType | jobTitle | salary | jobDescription | locationId |
|---|---|---|---|---|---|
| (→ Locations.id) | |||||
| 1 | Librarian | Librarian | 50000 | Organizing and managing library resources. | 1 |
| 2 | Librarian | Library Assistant | 35000 | Assisting with various tasks in the library. | 2 |
| 3 | Archivist | Archivist | 45000 | Preserving historical documents and records. | 1 |
| 4 | Archivist | Records Management Specialist | 40000 | Implementing records management systems. | 3 |
| 5 | Curator | Curator | 55000 | Managing collections and exhibitions. | 4 |