University Campus Maintenance

The Buildings table provides a comprehensive record of each building on campus, including its name, description, address, and contact details. It is essential for managing building-specific information and facilitating communication regarding maintenance needs.

The Rooms table details individual rooms within each building, including their codes, types, and associated building names. This table helps in organizing and managing room-specific maintenance tasks and facility requirements.

The Room Facilities table lists the facilities available in each room, including inventory IDs and details. It helps in tracking and managing the amenities and equipment present in each room, ensuring that all facilities are properly accounted for and maintained.

The Works table tracks maintenance tasks and work orders related to campus facilities. It includes details such as task descriptions, statuses, due dates, and assigned users. This table is crucial for managing and prioritizing maintenance work to ensure timely completion.

The List of Facilities table contains a catalog of all facilities available across the campus. It helps in standardizing facility information and ensuring that all relevant facilities are listed and can be easily referenced for maintenance and planning purposes.

Together, these tables enable effective management of campus maintenance, from tracking the condition and facilities of buildings and rooms to managing specific maintenance tasks and ensuring all campus infrastructure is properly maintained.