Replace various value tables with a more general approach?

[johanvonboer]

Currently, tbl_analysis_entities is linked to various types of data or value-tables depending on the analysis type, it looks something like this:

tbl_analysis_entities
-> tbl_measured_values
-> tbl_analysis_entity_dimensions
-> tbl_analysis_entity_ages
-> tbl_abundances (taxon_id, abundance)
-> tbl_geochronology (various dating fields)
-> tbl_dendro_dates

How about just replacing all of these with a more general approach of having a single key/value table, like this:

tbl_analysis_entities -> tbl_analysis_entities_values (columns: value_id, analysis_entity_id, key, value)