Optimise ENUM types across schema

[matamadio]

• [x] Avoid abbreviations for types; must be self-explanatory, no need for side-note.

Most relevant from H schema: calc_method_enum

Current value	Should be
INF	Inferred
SIM	Simulated
OBS	Obeserved

• [ ] V schema table _loss.loss_typeenum could be simply named loss.type_enum

• [x] Remove "n/a" or "unknown" option from optional ENUM types. The field can be just left empty. Applies to:

mover.an_analysis_type_enum mover.em_analysis_type_enum mover.jd_analysis_type_enum mover.f_math_enum mover.f_mathtype_enum mover.dm_scale_ty_enum mover.im_method_enum mover.nonsampling_err_enum

• [x] Damage state ENUM requires semplification

The _mover.damage_states_all_enum_ includes many of overlapping and repeated definitions. I did cut down to 32, split into coherent blocks, which is still a lot. Suggest to simplify more.

Current _mover.damage_states_allenum

No damage
Light damage
Minor damage
Moderate damage
Major damage
Heavy damage
Complete damage

None
None to Slight
Negligible to Slight
Slight
Light
Moderate
Severe
Substantial to Heavy
Heavy
Very Heavy
Extensive
Destruction
Complete

Partial collapse
Collapse
Collapse prevention
Near Collapse
Collapsed
Washed away

Operational
Fully Operational

Immediate Occupancy
Life safety
Production loss
Not applicable

Suggested _mover.damage_states_allenum

No damage
Minor damage
Moderate damage
Major damage
Heavy damage
Destruction

[matamadio]

Review schema and optimisation

[matamadio]

The common.imt table has 60 entries (most for EQ), but some of them are duplicated, e.g. "water depth: m" is the same unit for river floods, pluvial floods, storm surge. Suggest to group the units by primary hazard, since they apply the same to processes, to reduce the size of the enum.