Arm_2_Subject

Join table that associates Subject with ARM_OR_COHORT table records.

Columns

Name	Type	Description	Foreign Key
arm_accession	varchar(15)	Foreign key reference to ARMO_OR_COHORT table	arm_or_cohort.arm_accession
subject_accession	varchar(15)	Foreign key reference to SUBJECT table	subject.subject_accession
age_event	varchar(50)	Standardized value in the LK_AGE_EVENT table	lk_age_event.name
age_event_specify	varchar(50)	Reported value when the age event is not available in the LK_AGE_EVENT table
age_unit	varchar(25)	Standardized value in the LK_TIME_UNIT table	lk_time_unit.name
max_subject_age	float	Maximum numeric age of the subject
min_subject_age	float	Minumum numeric age of the subject
subject_phenotype	varchar(200)	Reported value
subject_location	varchar(50)	Subject geographic location.	lk_subject_location.name
max_subject_age_in_years	float	Maximum numeric age of the subject in years
min_subject_age_in_years	float	Minumum numeric age of the subject in years

Indexes

Name	Column	Description
PRIMARY	arm_accession	BTREE
PRIMARY	subject_accession	BTREE
idx_arm_2_subject_1	subject_accession	BTREE
idx_arm_2_subject_1	arm_accession	BTREE
fk_arm_2_subject_3	age_unit	BTREE
fk_arm_2_subject_4	age_event	BTREE
fk_arm_2_subject_5	subject_location	BTREE

Tables that Reference this Table

Name	Column	Table Reference	Column Reference
immune_exposure	arm_accession	arm_2_subject	arm_accession
immune_exposure	subject_accession	arm_2_subject	subject_accession