As per the original design: Difficulty; Structure; Structure qualifier (e.g. inverted); Direction; Water; Warnings)
Having a single pilsi field as free text in the squeezes table will result in incorrect classifications. The classifiers should be fixed (in the front end select from a drop down or point & click). Minimum requirement should be Difficulty and Structure.
Splitting fields should also make database searches much simpler (e.g. how many grade 7, inverted, downwards keyholes in water OR mud in Victoria).
As per the original design: Difficulty; Structure; Structure qualifier (e.g. inverted); Direction; Water; Warnings) Having a single pilsi field as free text in the squeezes table will result in incorrect classifications. The classifiers should be fixed (in the front end select from a drop down or point & click). Minimum requirement should be Difficulty and Structure.
Splitting fields should also make database searches much simpler (e.g. how many grade 7, inverted, downwards keyholes in water OR mud in Victoria).