Build my own CMMS! Production Equipment and Building Maintenance Use Case
Hello Airtable Community,
I am a technically trained serviceman, who is currently employed as a maintenance guy with a myriad of assets that require on going responsibilities. I have a fuel inside of me to get all the scattered and tacit knowledge shoved into a database so I can have more time to spend on projects I enjoy.
The Access relationship picture supplied was a work in progress. I was having a hard time with balancing certain things. I created 3 levels of “assets” Items, Assemblies and Parts. This is because I have equipment that has assemblies that can be replaced or repaired externally (OEM) but can be repaired in-house on a part level. Also, those assemblies can be taken off of one machine, repaired, then put back onto a different machine. The assembly level is also where any prototyping would occur when designing something with my 3d printer and trying it out. So any information about length of time in service would be important for a specific identifiable assembly. Parts l
