Hospital Equipment & Maintenance Database

Aug 25, 2011
Reaction score
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?

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question