Hi All
Just wondering if someone could give me an idea of how to structure a machinery component (asset / maintenance) database. I'm struggling with machinery having lots of components, which has lots of components, each of which have components :banghead: all which have to be tracked and recorded based on time. (E.g. car, with four wheels, which have nuts, hubcap, tyres - would want to know which wheel the nuts belonged to, and when they were lasted changed out - this is a simplified example of what I am talking about).
I just can't picture what the structure should look like. Any input would be appreciated.
Thanks
Just wondering if someone could give me an idea of how to structure a machinery component (asset / maintenance) database. I'm struggling with machinery having lots of components, which has lots of components, each of which have components :banghead: all which have to be tracked and recorded based on time. (E.g. car, with four wheels, which have nuts, hubcap, tyres - would want to know which wheel the nuts belonged to, and when they were lasted changed out - this is a simplified example of what I am talking about).
I just can't picture what the structure should look like. Any input would be appreciated.
Thanks