We are currently using an online database for our client tracking and data reporting. Issues with restrictions are forcing us to migrate to a different database and we've decided to look into building our own customized database.
The project is to rebuild the database on our server using MySQL (or MariaDB) in the php Symfony framework. The front end will allow our internal staff to add/remove/update records in the database.
The database has multiple nested tables such that its very dynamic.
The initial project will be kept simple and if successful, we will continue to contract to add further functionality in subsequent milestones. Thus, this project will start with the getting the initial interface started with a simplified version of the final backend database.
The deliverable for this project will be as follows:
A user will go to the website and be presented with the initial table. This master "clients" table will have 2 fields (ID, First Name) for each client. The "clients" table will also have 1 nested table named "Children" which will have 2 fields (ID, First Name).
1) The initial screen presented to the user will show a list of the current clients with their id.
2) The user needs to be able to view a detail screen of any client
3) The user needs to be able to add/edit/remove clients in the "clients" table.
4) The user needs to be able to view/add/edit/remove an unlimited number of children via a "children" sub-table within the "clients" table
Later phases (not part of this current project bid) will include adding more fields and sub-tables, streamlining the user interface, securing the website with login, adding search functionality, data reporting, etc.
I am willing to pay higher rates for the most experienced freelancers