46 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| fk_structurelt4m_lookuptreespecies |
|
|
Restrict delete | ||
| fk_structurelt4m_plot |
|
|
Cascade on delete | ||
| fk_structurelt4m_plotlocation |
|
|
Cascade on delete | ||
| fk_wzptree_stembreakage |
|
|
Restrict delete | ||
| fk_wzptree_prunging |
|
|
Restrict delete | ||
| fk_wzptree_treespecies |
|
|
Restrict delete | ||
| fk_wzptree_standlayer |
|
|
Restrict delete | ||
| fk_wzptree_treestatus |
|
|
Restrict delete | ||
| fk_wzptree_plot |
|
|
Cascade on delete | ||
| fk_wzptree_stemform |
|
|
Restrict delete | ||
| fk_position_lookupgnssquality |
|
|
Restrict delete | ||
| fk_position_plotlocation |
|
|
Cascade on delete | ||
| fk_position_plot |
|
|
Cascade on delete | ||
| fk_tract_lookupstateresponsible |
|
|
Restrict delete | ||
| fk_tract_lookupstate |
|
|
Restrict delete | ||
| fk_cluster_user_id |
|
|
Restrict delete | ||
| fk_saplings2m_plotlocation |
|
|
Cascade on delete | ||
| fk_saplings2m_lookuptreesizeclass |
|
|
Restrict delete | ||
| fk_saplings2m_plot |
|
|
Cascade on delete | ||
| fk_saplings2m_lookuptreespecies |
|
|
Restrict delete | ||
| fk_saplings2m_lookupbrowsing |
|
|
Restrict delete | ||
| fk_deadwood_lookupdecomposition |
|
|
Restrict delete | ||
| fk_deadwood_lookupdeadwoodtype |
|
|
Restrict delete | ||
| fk_deadwood_plot |
|
|
Cascade on delete | ||
| fk_deadwood_lookuptreespeciesgroup |
|
|
Restrict delete | ||
| fk_plot_lookuptreesless4metermirrored |
|
|
Restrict delete | ||
| fk_plot_cluster |
|
|
Cascade on delete | ||
| fk_plot_lookupelevationlevel |
|
|
Restrict delete | ||
| fk_plot_lookupstandstructure |
|
|
Restrict delete | ||
| fk_plot_lookupforeststatus |
|
|
Restrict delete | ||
| fk_plot_lookupmanagementtype |
|
|
Restrict delete | ||
| fk_plot_lookupgrowthdistrict |
|
|
Restrict delete | ||
| fk_plot_lookupterrainform |
|
|
Restrict delete | ||
| fk_plot_lookupmarkerstatus |
|
|
Restrict delete | ||
| fk_plot_lookuppropertytype |
|
|
Restrict delete | ||
| fk_plot_lookuppropertysizeclass |
|
|
Restrict delete | ||
| fk_plot_lookupmarkerprofile |
|
|
Restrict delete | ||
| fk_plot_lookupstanddevphase |
|
|
Restrict delete | ||
| fk_plot_lookupharvestingmethod |
|
|
Restrict delete | ||
| fk_plot_lookupstandlayer |
|
|
Restrict delete | ||
| fk_plot_lookuplanduse |
|
|
Restrict delete | ||
| fk_edge_lookupedgetype |
|
|
Restrict delete | ||
| fk_edge_lookupterrain |
|
|
Restrict delete | ||
| fk_edge_lookupedgestatus |
|
|
Restrict delete | ||
| fk_edges_plot |
|
|
Cascade on delete | ||
| fk_plot_location_plot_id |
|
|
Cascade on delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| cluster | check_select_access_by_emails_constraint | (private_ci2027_001.check_select_access_by_emails(select_access_by)) |
| cluster | check_update_access_by_emails_constraint | (private_ci2027_001.check_select_access_by_emails(update_access_by)) |
| edges | ck_edges_geometry | (st_isvalid(geometry)) |