Build a Website

1. I have a set of around 30 tables with entities already defined , Requirement is to create SQLs for those entities and write RESTful APIs for those tables for CRUDL (create , read ,update,List) . 2. The proposed APIs are just like Freelancer website where a user can come and post a job and other users or service providers would get notification and will quote for the job. 3. Membership module is also like Freelancer where a user and service provider can register themselves. 4. There is a need to have different finders against each entity. e.g findAjobPostedByCity or findAServicePostedByAUser [login to view URL]{city} [login to view URL]{user} 5. There must be a authentication token generated for APIs which should start with login and same authentication token must be used for subsequent calls . 6. e.g. To find and quote for a job , user must login first and if user has not logged in a messages should be sent that authentication failed and and login API URL should be sent in the same message , 7. once user calls login API in after successful authentication ,a token should be sent to user which would be used for subsequent calls . 8. Restful APIs should be secured with a proper mechanism with a concept of API Keys where a developer which has been issued with a key only can access the APIs. 9. Junit test cases are required to be written to test each operation on APIs 10. Timeline is very tight and it should be done within 2 to 3 weeks.