Table 2.1: scoring dimension_category

The purpose of this table is to hold the display data and any data which is not calculated

Field	Type	Description

Field	Type	Description
id	integer	id that can be used to join with the other tables in the scoring schema
key	string	the key of the category. If this field is changed in the domain language then a new row is created in this table
key_display	string	the display value of the category. Allows the name of the ‘category’ to be changed but doesn’t cause new row to be created
created_datetime	datetime	when the record was inserted
updated_datetime	datetime	when the record was updated