AnsweredAssumed Answered

Opinions on how to best model this data

Question asked by DaveArndt on May 31, 2016
Latest reply on May 31, 2016 by erolst

I’m creating a solution to track inspections on 3 types of equipment.

I have a table for the inspections which contains all the necessary inspection fields for the three types of equipment (about 200 fields)

All three inspections use 90% of the 200 fields.

The customer requested that all pertinent fields be initially marked as "PASS" .

From a design standpoint which would be the best way to go about this.  I may have to deal with new fields being added or removed.  Possible additional types of equipment.

Solution A

  1. Prepopulate all the fields with “PASS”
  2. Run a script which looks at the equipment type and marks NULL the fields which don’t apply.

Solution B

  1. Prepopulate all fields using a calculation which populates according to the equipment type.

Would one solution offer better control, performance, or scaleability over the other?  Im at a loss because I can see good/bad to both options.


Thanks in advance for the suggestions.