Spring Boot Backend and Database for Complaint Management System

Need to develop Database, REST API's and triggers for complaint management system for an organization (using azure AD for authentication) and external vendors to post any problem/suggestion they find in the working environment. complaint management system for an organization to post any problem/suggestion they find in the working environment. It will mainly contain 4 types of users - the user who just have access to posting and viewing his complaint page - the moderator/incident officer who will have the list of complaints of his particular area/plant - the admin who can add new moderator/incident officer and also authorize the user kyc (after user sign ups he'll have to wait for admin to update the database) - super admin who can add an admin, moderator or user The CMS will have the following functionality - (FOR USER) 1. the user will first have to sign up with some values after which he'll get a pop up with message "registration complete, password will be sent on registered email after completetion of KYC) 2. user log in with his mobile_no and auto generated password 3. a one time option to change password after 1st log in 4. after logging, the user we'll have following options - post a complaint/incident with upto 5 photos - view all his posted complaints/incident its details and status - ability to give a feedback of the system with auto populated "to" and "cc" field in the mail (FOR MODERATOR/INCIDENT OFFICER) 1. Moderator/incident officer sign in with LDAP Authentication and Role Authorization (since both mod and admin will be part of internal organization) 2. 8 filter options and ability to see complaints assigned to his area/plant 3. ability to change the status of the incident/complaint 4. ability to assign the task of resolving the incident to a person using outlook with complaint details pre-populated in email 5. ability to access user page as well (FOR ADMIN) 1. ability to add new moderator/incident officers 2. ability to view all the complaints/incidents 3. ability to view all incidents area/plant wise 4. have count of total number of users and incident officers 5. have count of total number of incidents 6. have count of total number of incidents solved and pending 7. ability to send mail to an incident officer/moderator regarding pending complaint (FOR SUPER ADMIN) 1. ability to add new admin The developer will have to work with me for better clarity. There are some additional things as well which I'm forgetting.