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 | varchar(20) | Category | |
| workspace_id | int(11) | 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 |
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 |