AnsweredAssumed Answered

Database structure

Question asked by ldrolet on Aug 23, 2016
Latest reply on Aug 23, 2016 by beverly

I would like to know if there is a best practice for database table structure in a case such as this :  A mechanical maintenance application needs to log 3 types of info: in house technician time for repair, parts bought for repair, and subcontract fees for specialized work.  Is it better to have one tables to log all these (with all fields not used by all types) or is it a best practice to segregate them into 3 separate tables, all liked to the equipment table?

 

Thanks

Outcomes