Hi All,
I am having trouble designing a database that keeps track of periodic maintenance done on a large amount of equipment in a hospital. The equipment is heating and air conditioning equipment. There are different types of equipment, i.e., chillers, fans, isolation rooms, fridges, etc., and within each type of equipment, there are specific equipment IDs (i.e., Chiller 01). For each specific piece of equipment, there are numerous points that need to be checked/calibrated periodically. There are about 7000 different points and I am trying to figure out what kind of tables I would need to organize this data so that the technicians can enter their PM data into the database, and the Building operators can pull a report at any given time, showing that the technician has done the work for say, January - Isolation Rooms.
Any input?
I am having trouble designing a database that keeps track of periodic maintenance done on a large amount of equipment in a hospital. The equipment is heating and air conditioning equipment. There are different types of equipment, i.e., chillers, fans, isolation rooms, fridges, etc., and within each type of equipment, there are specific equipment IDs (i.e., Chiller 01). For each specific piece of equipment, there are numerous points that need to be checked/calibrated periodically. There are about 7000 different points and I am trying to figure out what kind of tables I would need to organize this data so that the technicians can enter their PM data into the database, and the Building operators can pull a report at any given time, showing that the technician has done the work for say, January - Isolation Rooms.
Any input?