Metrics and covariates are structures to organize non-timeseries and non-MRI measures. Examples include surveys, BP measures, and polysomnography scoring.
Covariates
A "covariate" is a stored value. The covariate has a name, and will be either a number or text ("string"). It will usually have a date (and possibly time) when it was measured.
The covariate information is stored in the "covariate" table. The actual values are stored separately as values in the "covariate_value" table.
Covariate table
Read only | |||||
'covariate_id' | 'int(11)' | 'NO' | 'PRI' | '' | 'auto_increment' |
'modified' | 'timestamp' | 'NO' | '' | 'CURRENT_TIMESTAMP' | 'on update CURRENT_TIMESTAMP' |
Required | |||||
'name' | 'varchar(255)' | 'NO' | '' | '' | '' |
'valtype' | 'enum(''number'',''string'')' | 'YES' | '' | '' | '' |
Optional | |||||
'valdefault' | 'varchar(255)' | 'YES' | '' | '' | '' |
'category' | 'varchar(255)' | 'YES' | '' | '' | '' |
'description' | 'varchar(4096)' | 'YES' | '' | '' | '' |
'parent_covariate_id' | 'int(11)' | 'YES' | '' | '' | '' |
'formula' | 'varchar(2048)' | 'YES' | '' | '' | '' |
Covariate_value table
Read only | |||||
'covariate_value_id' | 'int(11)' | 'NO' | 'PRI' | '' | 'auto_increment' |
'modified' | 'timestamp' | 'NO' | '' | 'CURRENT_TIMESTAMP' | 'on update CURRENT_TIMESTAMP' |
Required | |||||
'subject_id' | 'int(11)' | 'NO' | '' | '' | '' |
'covariate_id' | 'int(11)' | 'NO' | '' | '' | '' |
'value' | 'varchar(255)' | 'YES' | '' | '' | '' |
Optional | |||||
'name' | 'varchar(255)' | 'YES' | '' | '' | '' |
'datetime' | 'datetime' | 'YES' | '' | '' | '' |
'projectgroupstudy_id' | 'int(11)' | 'YES' | '' | '' | '' |
'analysissetgroupstudy_id' | 'int(11)' | 'YES' | '' | '' | '' |
'tag' | 'varchar(1024)' | 'YES' | '' | '' | '' |
'comment' | 'varchar(2048)' | 'YES' | '' | '' | '' |