Hi, thanks for posting an interesting project.
I viewed your database file and I guess you are or were using Laravel framework to save this data as all of the tables have the same kind of timestamps like "created_at", "updated_at" and "deleted_at"
I'm a PHP/Laravel developer with 5+ years of experience and I have worked on many of RESTful API-s.
I know the concepts of REST deeply and if you want the same coding in Laravel framework, We can simply write route resources, as the Laravel has a good support for RESTful applications.
If you're not using or you don't want to use Laravel framework, no problem, we can even write our own, minimalistic framework which will support REST, will be faster and easily editable for other developers :)
Can you share more about your project? For example what methods do you want to use in your api calls, like create, read, update, delete only?
So, with all of that, I think I can easily help you out with the project.
Please send a message and let's get started ASAP.
Thanks.
George.