Assets Maintenance

The "Assets" table contains detailed information about each asset owned by the organization. This includes the model, maintenance contract reference number, supplier company name, asset make, acquisition and disposal dates, and other relevant details. This table ensures that all assets are accurately documented, providing a clear overview of the asset inventory and their maintenance contracts.

The "Fault Logs" table records any faults or issues reported with the assets. It includes the reference number, asset model, details of the staff who recorded the fault, the datetime the fault was logged, status, and a description of the fault. This table is crucial for tracking and managing asset issues, ensuring that faults are addressed promptly and efficiently.

The "Engineer Visits" table documents the visits made by engineers to address asset faults. It includes the staff and engineer names, fault log reference number, visit start and end times, and other details. This table ensures that all maintenance visits are recorded, providing a clear history of the actions taken to resolve asset issues.

The "Companies" table stores information about the companies involved in the maintenance and supply of assets. It includes the company's name, whether it is a maintenance contractor or supplier, contact details, and other relevant information. This table helps in managing relationships with external companies, ensuring that contact and service details are readily available.

The "Engineers" table contains detailed information about the engineers who conduct maintenance on the assets. It includes their full name, company name, skill type, and other relevant details. This table is essential for managing the engineers' information, ensuring that the right personnel are assigned to the appropriate maintenance tasks.

The "Contracts" table keeps track of all maintenance contracts associated with the assets. It includes the reference number, company name, start and end dates, and other relevant details. This table helps in managing and monitoring the maintenance contracts, ensuring that they are up-to-date and that all contractual obligations are met.

The "Staff" table stores information about the staff members involved in asset management and maintenance. It includes their full name, gender, photo, and other relevant details. This table ensures that staff information is well-documented, facilitating effective personnel management and communication.