117 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_macrostructure |
|
|
Restrict delete | ||
| fk_megatrait_quality_lookup |
|
|
Restrict delete | ||
| fk_megatrait_quality_parent |
|
|
Cascade on delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_macrostructure |
|
|
Restrict delete | ||
| fk_junct_megastructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_microstructures |
|
|
Restrict delete | ||
| fk_macrotrait_quality_lookup |
|
|
Restrict delete | ||
| fk_macrotrait_quality_parent |
|
|
Cascade on delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_macrostructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_macrostructure |
|
|
Restrict delete | ||
| fk_microstructure |
|
|
Cascade on delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_macrostructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_microstructures |
|
|
Restrict delete | ||
| fk_junct_mesostructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_mesotrait_quality_parent |
|
|
Cascade on delete | ||
| fk_mesotrait_quality_lookup |
|
|
Restrict delete | ||
| fk_junct_megastructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_microstructures |
|
|
Restrict delete | ||
| fk_junct_mesostructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| jtbl_project_citations_projectid_fkey |
|
|
Cascade on delete | ||
| jtbl_project_citations_citationid_fkey |
|
|
Cascade on delete | ||
| fk_junct_mesostructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_mesostructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_mesostructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_microstructures |
|
|
Restrict delete | ||
| fk_junct_mesostructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_mesostructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_Tectsetting_Lookup |
|
|
Restrict delete | ||
| fk_megastructure_age_confidence |
|
|
Restrict delete | ||
| fk_horScale_Lookup |
|
|
Restrict delete | ||
| fk_depSetting_Lookup |
|
|
Restrict delete | ||
| fk_megastructure_projectID |
|
|
Null on delete | ||
| fk_sedInterface_Lookup |
|
|
Restrict delete | ||
| fk_buildupInterface_Lookup |
|
|
Restrict delete | ||
| fk_initiation_Lookup |
|
|
Restrict delete | ||
| fk_substrate_Lookup |
|
|
Restrict delete | ||
| fk_megastructure_age_basis |
|
|
Restrict delete | ||
| fk_buildupType_Lookup |
|
|
Restrict delete | ||
| fk_megastructure_age_unit |
|
|
Restrict delete | ||
| fk_vertScale_Lookup |
|
|
Restrict delete | ||
| fk_megastructure_age_qualifier |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_microstructures |
|
|
Restrict delete | ||
| jtbl_collection_citations_collectionid_fkey |
|
|
Cascade on delete | ||
| jtbl_collection_citations_citationid_fkey |
|
|
Cascade on delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_macrostructure |
|
|
Restrict delete | ||
| fk_megastructure_macrostructure |
|
|
Null on delete | ||
| fk_attitude_Lookup |
|
|
Restrict delete | ||
| fk_spacing_Lookup |
|
|
Restrict delete | ||
| fk_growthVar_Lookup |
|
|
Restrict delete | ||
| fk_aspectRation_Lookup |
|
|
Restrict delete | ||
| fk_linkage_Lookup |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_microstructures |
|
|
Restrict delete | ||
| jtbl_citationgroups_citationgroupid_fkey |
|
|
Cascade on delete | ||
| jtbl_citationgroups_citationid_fkey |
|
|
Cascade on delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_microstructures |
|
|
Restrict delete | ||
| fk_microtrait_quality_parent |
|
|
Cascade on delete | ||
| fk_microtrait_quality_lookup |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_microstructures |
|
|
Restrict delete | ||
| fk_junct_mesostructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_macrostructure |
|
|
Restrict delete | ||
| fk_junct_megastructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_mesostructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_mesostructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_macrostructure_mesostructure |
|
|
Null on delete | ||
| fk_latCont_Lookup |
|
|
Restrict delete | ||
| fk_modSkew_Lookup |
|
|
Restrict delete | ||
| fk_clotHier_Lookup |
|
|
Restrict delete | ||
| fk_lamInheritance_Lookup |
|
|
Restrict delete | ||
| fk_synRelief_Lookup |
|
|
Restrict delete | ||
| fk_wall_Lookup |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_macrostructure |
|
|
Restrict delete | ||
| fk_junct_mesostructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_microstructures |
|
|
Restrict delete | ||
| fk_mesostructure_microstructure |
|
|
Null on delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_macrostructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_junct_microstructures |
|
|
Restrict delete | ||
| fk_junct_mesostructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete | ||
| fk_photolinks_mesostructure |
|
|
Null on delete | ||
| fk_photolinks_macrostructure |
|
|
Null on delete | ||
| fk_photolinks_microstructure |
|
|
Null on delete | ||
| fk_photolinks_megastructure |
|
|
Null on delete | ||
| fk_junct_mesostructure |
|
|
Restrict delete | ||
| fk_junct_lookup |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| tbl_megastructuredata | chk_megastructure_interpreted_age_pair | (((megainterpretedage IS NULL) AND (megainterpretedageunitid IS NULL)) OR ((megainterpretedage IS NOT NULL) AND (megainterpretedageunitid IS NOT NULL))) |
| spatial_ref_sys | spatial_ref_sys_srid_check | ((srid > 0) AND (srid <= 998999)) |