89 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| locations_ibfk_2 |
|
|
Restrict delete | ||
| locations_ibfk_1 |
|
|
Restrict delete | ||
| groups_ibfk_1 |
|
|
Cascade on delete | ||
| markers_ibfk_1 |
|
|
Cascade on delete | ||
| taxonomyproviderslinks_ibfk_2 |
|
|
Cascade on delete | ||
| taxonomyproviderslinks_ibfk_1 |
|
|
Cascade on delete | ||
| projectcollaborators_ibfk_2 |
|
|
Cascade on delete | ||
| projectcollaborators_ibfk_1 |
|
|
Cascade on delete | ||
| institutions_ibfk_1 |
|
|
Restrict delete | ||
| images_ibfk_1 |
|
|
Cascade on delete | ||
| fileresources_ibfk_1 |
|
|
Cascade on delete | ||
| fileresources_ibfk_2 |
|
|
Null on delete | ||
| groupmembers_ibfk_1 |
|
|
Cascade on delete | ||
| germplasmdatawarnings_ibfk_1 |
|
|
Cascade on delete | ||
| germplasmdatawarnings_ibfk_2 |
|
|
Cascade on delete | ||
| image_to_tag_ibfk_imagetag |
|
|
Cascade on delete | ||
| image_to_tag_ibfk_image |
|
|
Cascade on delete | ||
| datasetmembers_ibfk_1 |
|
|
Cascade on delete | ||
| datasetmembers_ibfk_2 |
|
|
Cascade on delete | ||
| datasetaccesslogs_ibfk_1 |
|
|
Cascade on delete | ||
| datasets_ibfk_license |
|
|
Null on delete | ||
| datasets_ibfk_datasettypes |
|
|
Cascade on delete | ||
| datasets_ibfk_experiment |
|
|
Cascade on delete | ||
| datasets_ibfk_dataset_state |
|
|
Cascade on delete | ||
| mcpd_ibfk_4 |
|
|
Cascade on delete | ||
| mcpd_ibfk_1 |
|
|
Cascade on delete | ||
| mcpd_ibfk_3 |
|
|
Cascade on delete | ||
| mcpd_ibfk_2 |
|
|
Cascade on delete | ||
| climatedata_ibfk_3 |
|
|
Cascade on delete | ||
| climatedata_ibfk_1 |
|
|
Cascade on delete | ||
| climatedata_ibfk_2 |
|
|
Cascade on delete | ||
| germplasminstitutions_ibfk_1 |
|
|
Cascade on delete | ||
| germplasminstitutions_ibfk_2 |
|
|
Cascade on delete | ||
| pedigrees_ibfk_1 |
|
|
Cascade on delete | ||
| pedigrees_ibfk_3 |
|
|
Cascade on delete | ||
| pedigrees_ibfk_2 |
|
|
Cascade on delete | ||
| pedigrees_ibfk_4 |
|
|
Cascade on delete | ||
| datasetfileresources_ibfk_1 |
|
|
Cascade on delete | ||
| datasetfileresources_ibfk_2 |
|
|
Cascade on delete | ||
| trialsetup_ibfk_5 |
|
|
Null on delete | ||
| trialsetup_ibfk_3 |
|
|
Null on delete | ||
| trialsetup_ibfk_4 |
|
|
Null on delete | ||
| trialsetup_ibfk_1 |
|
|
Cascade on delete | ||
| trialsetup_ibfk_2 |
|
|
Cascade on delete | ||
| attributedata_ibfk_1 |
|
|
Cascade on delete | ||
| links_ibfk_1 |
|
|
Cascade on delete | ||
| stories_ibfk_2 |
|
|
Null on delete | ||
| stories_ibfk_1 |
|
|
Null on delete | ||
| comments_ibfk_1 |
|
|
Cascade on delete | ||
| storysteps_ibfk_1 |
|
|
Cascade on delete | ||
| storysteps_ibfk_2 |
|
|
Null on delete | ||
| mapdefinitions_ibfk_1 |
|
|
Cascade on delete | ||
| mapdefinitions_ibfk_2 |
|
|
Cascade on delete | ||
| mapdefinitions_ibfk_3 |
|
|
Cascade on delete | ||
| datasetpermissions_ibfk_2 |
|
|
Cascade on delete | ||
| datasetpermissions_ibfk_1 |
|
|
Cascade on delete | ||
| datasetcollaborators_ibfk_2 |
|
|
Cascade on delete | ||
| datasetcollaborators_ibfk_1 |
|
|
Cascade on delete | ||
| experiments_ibfk_1 |
|
|
Null on delete | ||
| mapoverlays_ibfk_1 |
|
|
Cascade on delete | ||
| projectpublications_ibfk_2 |
|
|
Cascade on delete | ||
| projectpublications_ibfk_1 |
|
|
Cascade on delete | ||
| phenotypedata_ibfk_2 |
|
|
Cascade on delete | ||
| phenotypedata_ibfk_7 |
|
|
Cascade on delete | ||
| climates_ibfk_1 |
|
|
Restrict delete | ||
| germinatebase_ibfk_location |
|
|
Null on delete | ||
| germinatebase_ibfk_entityparent |
|
|
Null on delete | ||
| germinatebase_ibfk_entitytype |
|
|
Null on delete | ||
| germinatebase_ibfk_taxonomy |
|
|
Null on delete | ||
| projects_ibfk_1 |
|
|
Null on delete | ||
| phenotypes_ibfk_2 |
|
|
Null on delete | ||
| phenotypes_ibfk_1 |
|
|
Null on delete | ||
| pedigreedefinitions_ibfk_3 |
|
|
Cascade on delete | ||
| pedigreedefinitions_ibfk_4 |
|
|
Cascade on delete | ||
| pedigreedefinitions_ibfk_1 |
|
|
Cascade on delete | ||
| pedigreedefinitions_ibfk_2 |
|
|
Cascade on delete | ||
| projectgroups_ibfk_2 |
|
|
Cascade on delete | ||
| projectgroups_ibfk_1 |
|
|
Cascade on delete | ||
| licensedata_ibfk_2 |
|
|
Cascade on delete | ||
| licensedata_ibfk_1 |
|
|
Cascade on delete | ||
| datasetmeta_ibfk_1 |
|
|
Cascade on delete | ||
| datasetlocations_ibfk_1 |
|
|
Cascade on delete | ||
| datasetlocations_ibfk_2 |
|
|
Cascade on delete | ||
| news_ibfk_1 |
|
|
Cascade on delete | ||
| usergroupmembers_ibfk_1 |
|
|
Cascade on delete | ||
| licenselogs_ibfk_1 |
|
|
Cascade on delete | ||
| publicationdata_ibfk_1 |
|
|
Cascade on delete | ||
| synonyms_ibfk_1 |
|
|
Cascade on delete | ||
| collaborators_ibfk_1 |
|
|
Null on delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|