Arm_Or_Cohort
A subset of the subjects in a study.
Columns
| Name | Type | Description | Foreign Key |
|---|---|---|---|
| arm_accession | varchar(15) | Primary key | |
| description | varchar(4000) | Freee text to expand upon details | |
| name | varchar(126) | Name or identifier | |
| study_accession | varchar(15) | Foreign key reference to STUDY table | study.study_accession |
| type_reported | varchar(40) | Category submitted | |
| type_preferred | varchar(40) | Category harmonized | lk_arm_type.name |
| workspace_id | int | Foreign key reference to WORKSPACE table | workspace.workspace_id |
Indexes
| Name | Column | Description |
|---|---|---|
| PRIMARY | arm_accession | BTREE |
| idx_arm_or_cohort_study | study_accession | BTREE |
| idx_arm_or_cohort_study | arm_accession | BTREE |
| idx_arm_or_cohort_workspace | workspace_id | BTREE |
| fk_arm_or_cohort_3 | type_preferred | BTREE |
Tables that Reference this Table
| Name | Column | Table Reference | Column Reference |
|---|---|---|---|
| arm_2_subject | arm_accession | arm_or_cohort | arm_accession |
| elisa_result | arm_accession | arm_or_cohort | arm_accession |
| elispot_result | arm_accession | arm_or_cohort | arm_accession |
| fcs_analyzed_result | arm_accession | arm_or_cohort | arm_accession |
| hai_result | arm_accession | arm_or_cohort | arm_accession |
| hla_typing_result | arm_accession | arm_or_cohort | arm_accession |
| immune_exposure | arm_accession | arm_or_cohort | arm_accession |
| kir_typing_result | arm_accession | arm_or_cohort | arm_accession |
| mass_spectrometry_result | arm_accession | arm_or_cohort | arm_accession |
| mbaa_result | arm_accession | arm_or_cohort | arm_accession |
| neut_ab_titer_result | arm_accession | arm_or_cohort | arm_accession |
| pcr_result | arm_accession | arm_or_cohort | arm_accession |