72 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| locations_ibfk_2 |
|
|
Restrict delete | ||
| locations_ibfk_1 |
|
|
Restrict delete | ||
| storagedata_ibfk_1 |
|
|
Cascade on delete | ||
| storagedata_ibfk_2 |
|
|
Cascade on delete | ||
| dataset_export_jobs_ibfk_1 |
|
|
Null on delete | ||
| groups_ibfk_1 |
|
|
Cascade on delete | ||
| markers_ibfk_1 |
|
|
Cascade on delete | ||
| institutions_ibfk_1 |
|
|
Restrict delete | ||
| images_ibfk_1 |
|
|
Cascade on delete | ||
| fileresources_ibfk_1 |
|
|
Cascade on delete | ||
| groupmembers_ibfk_1 |
|
|
Cascade on delete | ||
| image_to_tag_ibfk_imagetag |
|
|
Cascade on delete | ||
| image_to_tag_ibfk_image |
|
|
Cascade on delete | ||
| compounds_ibfk_1 |
|
|
Cascade on delete | ||
| compounddata_ibfk_2 |
|
|
Cascade on delete | ||
| compounddata_ibfk_1 |
|
|
Null on delete | ||
| compounddata_ibfk_4 |
|
|
Cascade on delete | ||
| compounddata_ibfk_3 |
|
|
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 | ||
| climatedata_ibfk_3 |
|
|
Cascade on delete | ||
| climatedata_ibfk_1 |
|
|
Cascade on delete | ||
| climatedata_ibfk_2 |
|
|
Cascade on delete | ||
| pedigrees_ibfk_1 |
|
|
Cascade on delete | ||
| pedigrees_ibfk_3 |
|
|
Cascade on delete | ||
| pedigrees_ibfk_2 |
|
|
Cascade on delete | ||
| attributedata_ibfk_1 |
|
|
Cascade on delete | ||
| links_ibfk_1 |
|
|
Cascade on delete | ||
| comments_ibfk_1 |
|
|
Cascade on delete | ||
| mapdefinitions_ibfk_1 |
|
|
Cascade on delete | ||
| mapdefinitions_ibfk_2 |
|
|
Cascade on delete | ||
| mapdefinitions_ibfk_3 |
|
|
Cascade on delete | ||
| climateoverlays_ibfk_1 |
|
|
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 | ||
| phenotypedata_ibfk_1 |
|
|
Cascade on delete | ||
| phenotypedata_ibfk_3 |
|
|
Cascade on delete | ||
| phenotypedata_ibfk_2 |
|
|
Cascade on delete | ||
| phenotypedata_ibfk_5 |
|
|
Null on delete | ||
| phenotypedata_ibfk_4 |
|
|
Null on delete | ||
| phenotypedata_ibfk_6 |
|
|
Null on delete | ||
| climates_ibfk_1 |
|
|
Restrict delete | ||
| germinatebase_ibfk_mlsstatus |
|
|
Null on delete | ||
| germinatebase_ibfk_collsrc |
|
|
Null on delete | ||
| germinatebase_ibfk_institution |
|
|
Null on delete | ||
| germinatebase_ibfk_location |
|
|
Null on delete | ||
| germinatebase_ibfk_entityparent |
|
|
Null on delete | ||
| germinatebase_ibfk_biologicalstatus |
|
|
Null on delete | ||
| germinatebase_ibfk_entitytype |
|
|
Null on delete | ||
| germinatebase_ibfk_taxonomy |
|
|
Null on delete | ||
| phenotypes_ibfk_1 |
|
|
Null on delete | ||
| pedigreedefinitions_ibfk_3 |
|
|
Cascade on delete | ||
| pedigreedefinitions_ibfk_1 |
|
|
Cascade on delete | ||
| pedigreedefinitions_ibfk_2 |
|
|
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 |
|---|