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.
- Prepopulate all the fields with “PASS”
- Run a script which looks at the equipment type and marks NULL the fields which don’t apply.
- 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.