Table 1.1: scoring dimension_app

id

integer

id that can be used to join with the other tables in the scoring schema

key

string

the key of the app. 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 app. Allows the name of the ‘app’ 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