The Feedbacks table contains detailed records of each feedback or complaint received. This includes the reference number, organization involved, person giving the feedback, feedback content, date, type, outcome, status, results, comments, and other relevant details. This table is central to tracking the lifecycle of each feedback instance from submission to resolution.
The Actions table records actions taken in response to feedback or complaints. It includes information about the feedback reference number, staff involved, type of action, date, results, description, and other details. This table ensures that each feedback or complaint is appropriately addressed and documented.
The Peoples table maintains information about individuals related to feedback or complaints. It records their full name, gender, date of birth, address, duration of involvement, and other pertinent details. This table helps keep track of all people involved in the feedback process.
The Organisations table stores details about organizations that are part of the feedback or complaints process. This includes the organization's name, address, phone number, email, description, and other relevant details. This table is essential for managing and organizing information about the organizations involved.
The Staff table holds information about staff members who handle feedback and complaints. It includes their name, associated organization, job title, email, phone number, date of birth, and other details. This table ensures that all staff involved in the feedback process are properly recorded and can be referenced as needed.
Any support materials, such as spreadsheets and real-life work samples would be very helpful as they would help us better understand your business process.