Subject_Measure_Definition

Contains computed measures for a SUBJECT.

Columns

Name	Type	Description	Foreign Key
subject_measure_accession	varchar(15)	Primary key
algorithm	varchar(1024)	Formula for calculating secondary measures
description	varchar(4000)	Free text to expand upon details
measureofcentraltendency	varchar(40)	Whether mean, median or mode was utilized when there is a central tendency calculation performed
measureofdispersion	varchar(40)	Variability or spread in a variable or probability calculation, such as variance, standard deviation, or interquartile range
measuretype	varchar(40)	Description of the nature of the measure
name	varchar(125)	Name or identifier
outcometype	varchar(70)	A characterization of the type of measurement being described
study_accession	varchar(15)	Foreign key reference to the STUDY table	study.study_accession
timeframe	varchar(256)	A textual description of the timeframe involved in this measure (e.g. all days of the year)
unitofmeasure	varchar(40)	Reported value
workspace_id	int(11)	Foreign key reference to WORKSPACE table

Indexes

Name	Column	Description
PRIMARY	subject_measure_accession	BTREE
idx_subject_measure_study	study_accession	BTREE
idx_subject_measure_workspace	workspace_id	BTREE

Tables that Reference this Table

Name	Column	Table Reference	Column Reference
subject_measure_result	subject_measure_accession	subject_measure_definition	subject_measure_accession