Contract_2_Study
Join table that associates a funding source to a study.
Columns
| Name | Type | Description | Foreign Key |
|---|---|---|---|
| contract_grant_id | int | Foreign key reference to CONTRACT_GRANT table | contract_grant.contract_grant_id |
| study_accession | varchar(15) | Foreign key reference to STUDY table | study.study_accession |
Indexes
| Name | Column | Description |
|---|---|---|
| PRIMARY | contract_grant_id | BTREE |
| PRIMARY | study_accession | BTREE |
| idx_contract_grant_2_study_study | study_accession | BTREE |
| idx_contract_grant_2_study_study | contract_grant_id | BTREE |
Tables that Reference this Table
| Name | Column | Table Reference | Column Reference |
|---|---|---|---|