Contract_2_Study
Join table that associates a funding source to a study.
Columns
Name |
Type |
Description |
Foreign Key |
contract_grant_id |
int(11) |
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 |
|
|
|
|