Give me the API design model, I will write the code for the RestAPI with the error handling, testing and DB integration covered. Trying to be as elaborate as possible but this is my first time creating service, so feel free to ask any questions.