Immune_Exposure

Captures results of immune exposure.

Columns

Name	Type	Description	Foreign Key
exposure_accession	varchar(15)	The primary key for the Immune Exposure table
arm_accession	varchar(15)	The study arm to which the subject is associated	arm_2_subject.arm_accession arm_or_cohort.arm_accession
disease_ontology_id	varchar(100)	The disease ontology ID associated with the disease
disease_preferred	varchar(250)	The preferred disease associated with the exposure	lk_disease.name
disease_reported	varchar(550)	This indicated the specific disease of the host associated with the exposure
disease_stage_preferred	varchar(50)	The preferred disease stage associate with the the exposure. The Disease Stage reflects the stage of the disease at the time the experimental data was generated.	lk_disease_stage.name
disease_stage_reported	varchar(100)	This provides a broad classification of how the disease has progressed. The Disease Stage reflects the stage of the disease at the time the experimental data was generated.
exposure_material_id	varchar(100)	The NCBI or Vaccine Ontology ID associated with the exposure material.
exposure_material_preferred	varchar(200)	The preferred exposure material associated with the process	lk_exposure_material.name
exposure_material_reported	varchar(200)	This describes what substance(s) the host is exposed to and/or develops immune reactions to as part of the exposure process.
exposure_process_preferred	varchar(100)	The preferred exposure process	lk_exposure_process.name
exposure_process_reported	varchar(100)	This identifies the type of process through which a host is exposed and the type of evidence for that exposure to have happened, which are tightly intertwined. This is the only element of the four that is always mandatory.
subject_accession	varchar(15)	The subject associated with the Immune exposure record	arm_2_subject.subject_accession subject.subject_accession

Indexes

Name	Column	Description
PRIMARY	exposure_accession	BTREE
idx_immune_arm_accession	arm_accession	BTREE
idx_immune_subject_accession	subject_accession	BTREE
fk_immune_exposure_1	arm_accession	BTREE
fk_immune_exposure_1	subject_accession	BTREE
fk_immune_exposure_4	exposure_process_preferred	BTREE
fk_immune_exposure_5	exposure_material_preferred	BTREE
fk_immune_exposure_6	disease_preferred	BTREE
fk_immune_exposure_7	disease_stage_preferred	BTREE

Tables that Reference this Table

Name	Column	Table Reference	Column Reference