Subject

Humans or animals that are the focus of a STUDY.

Columns
Name Type Description Foreign Key
subject_accession varchar(15) Primary key
ancestral_population varchar(100) Foreign key reference to LK_ANCESTRAL_POPULATION table
description varchar(4000) Free text to expand upon details
ethnicity varchar(50) Standardized value in LK_ETHNICITY table lk_ethnicity.name
gender varchar(20) Standardized value in LK_GENDER table lk_gender.name
race varchar(50) Standardized value in LK_RACE table lk_race.name
race_specify varchar(1000) Entered by the data provider when term is not in the controlled vocabulary
species varchar(50) Standardized value in LK_SPECIES table lk_species.name
strain varchar(50) Reported value
strain_characteristics varchar(500) Reported value
workspace_id int(11) Foreign key reference to WORKSPACE table workspace.workspace_id
Indexes
Name Column Description
PRIMARY subject_accession BTREE
idx_subject_gender gender BTREE
idx_subject_race race BTREE
idx_subject_species species BTREE
idx_subject_workspace workspace_id BTREE
fk_subject_2 ethnicity BTREE
Tables that Reference this Table
Name Column Table Reference Column Reference
adverse_event subject_accession subject subject_accession
arm_2_subject subject_accession subject subject_accession
assessment_component subject_accession subject subject_accession
biosample subject_accession subject subject_accession
elisa_result subject_accession subject subject_accession
elispot_result subject_accession subject subject_accession
fcs_analyzed_result subject_accession subject subject_accession
hai_result subject_accession subject subject_accession
hla_typing_result subject_accession subject subject_accession
immune_exposure subject_accession subject subject_accession
intervention subject_accession subject subject_accession
kir_typing_result subject_accession subject subject_accession
mass_spectrometry_result subject_accession subject subject_accession
mbaa_result subject_accession subject subject_accession
neut_ab_titer_result subject_accession subject subject_accession
pcr_result subject_accession subject subject_accession
protocol_deviation subject_accession subject subject_accession
reported_early_termination subject_accession subject subject_accession
subject_measure_result subject_accession subject subject_accession
Back to top