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 |