10 Replies Latest reply on Aug 23, 2016 7:20 PM by beverly

    Database structure

    ldrolet

      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