Subject_Measure_Result

Contains the computed results of SUBJECT_MEASURE.

Columns
Name Type Description Foreign Key
subject_measure_res_accession varchar(15) Primary key
centraltendencymeasurevalue varchar(40) Value of the central tendency measure defined in the SUBJECT_MEASURE_DEFINITION record
datavalue varchar(40) Value calculated or recorded for this measure.
dispersionmeasurevalue varchar(40) Value of the dispersion measure defined in the SUBJECT_MEASURE_DEFINITION record
study_accession varchar(15) Foreign key reference to the STUDY table study.study_accession
study_day float Reported value
subject_accession varchar(15) Foreign key reference to the SUBJECT table subject.subject_accession
subject_measure_accession varchar(15) Foreign key reference SUBJECT_MEASURE_DEFINITION table subject_measure_definition.subject_measure_accession
time_of_day varchar(40) Reported value
workspace_id int(11) Foreign key reference to WORKSPACE table
year_of_measure date Year that the measure was taken or recorded
Indexes
Name Column Description
PRIMARY subject_measure_res_accession BTREE
idx_subject_measure_result_study study_accession BTREE
idx_subject_measure_result_subject subject_accession BTREE
idx_subject_measure_result_workspace workspace_id BTREE
fk_subject_measure_result_2 subject_measure_accession BTREE
Tables that Reference this Table
Name Column Table Reference Column Reference
Back to top