This repository is the schema of the database I designed while developing a prototype for the Information Technology system at Workforce Link, a recruitment start-up company based in Ipswich, Queensland.
Workforce Link is a start-up company that helps recruit prospective support workers for positions in the disability and healthcare industries. In April 2019, I was commissioned to design and implement an IT system to help streamline their loose, paper-based system. One of our goals was to host public profiles of our candidate staff that potential employers are able to search and view, similar to a social network. This was the MySQL database that I designed in order to facilitate the staff search engine.
- First, run the database definition script. This defines the database itself along with the empty tables.
- If you plan on using the prototype server, you will also need to run active sessions definition script. This is a separate database that stores user sessions.
- Add the Preloaded Lists test data. It does not matter which order you execute the SQL files in.
- Generate Support Worker test data using this generation script. You need to execute the SQL files in their numbered order. Otherwise, there may be errors.
- If you need to clear the Support Worker tables, run the Clean Support Workers script.
- ER Diagram
- Data Dictionary
- Support Worker Test Data Generator
- Original Prototype Server
- Test Data References
As of June 2021, I have decided to start cleaning up backup files of the IT system I designed for Workforce Link. On the 5th of August, I publicly released the database design, a 'Support Worker' test data generation script, and a prototype build of the final product.
On 7 August 2021, I made revisions to the original schema and released a separate version. However, I have already discontinued the WF Link project as a whole. See here as to why.
As of 28 March 2022, I have withdrawn any further plans to reboot this project.
This database design is licensed under MIT. You may use this as a basis both personal and commercial projects as long as attribution is given and the license remains intact. Although I will actively support this repository, I do not claim responsibility for if and how you use the original schema alongside the prototype server. Refer to that repository for more details. The 3rd-party test data used in this version of the database is property of their respective owners. Care has been taken to reference them appropriately and are not covered by this project's license.