Assessment_Panel

Evaluations ( CRS, questionaires, ratings based on a reference scale) of subjects that do not involve drawing a sample from a subject.

Columns
Name Type Description Foreign Key
assessment_panel_accession varchar(15) Primary key
assessment_type varchar(125) Category
name_preferred varchar(125) Standardized name or identifier
name_reported varchar(125) Name or identifier
result_schema varchar(50) Standardized value in LK_RESULT_SCHEMA lk_expsample_result_schema.name
status varchar(40) Reported value
study_accession varchar(15) Foreign key reference to STUDY table study.study_accession
workspace_id int(11) Foreign key reference to WORKSPACE table workspace.workspace_id
Indexes
Name Column Description
PRIMARY assessment_panel_accession BTREE
idx_assessment_panel_study study_accession BTREE
idx_assessment_workspace workspace_id BTREE
fk_assessment_3 result_schema BTREE
Tables that Reference this Table
Name Column Table Reference Column Reference
assessment_2_file_info assessment_panel_accession assessment_panel assessment_panel_accession
assessment_component assessment_panel_accession assessment_panel assessment_panel_accession
Back to top