56 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| fk_wzptree_stembreakage |
|
|
Restrict delete | ||
| fk_wzptree_prunging |
|
|
Restrict delete | ||
| fk_wzptree_treestate |
|
|
Restrict delete | ||
| fk_wzptree_treespecies |
|
|
Restrict delete | ||
| fk_wzptree_standlayer |
|
|
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_lookupstatelocation |
|
|
Restrict delete | ||
| fk_tract_lookupstateadministration |
|
|
Restrict delete | ||
| fk_cluster_user_id |
|
|
Restrict delete | ||
| fk_saplings2m_plotlocation |
|
|
Cascade on delete | ||
| fk_saplings2m_lookuptreesizeclass |
|
|
Restrict delete | ||
| fk_saplings2m_lookupbitten |
|
|
Restrict delete | ||
| fk_saplings2m_plot |
|
|
Cascade on delete | ||
| fk_saplings2m_lookuptreespecies |
|
|
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_lookuphabitattypesource |
|
|
Restrict delete | ||
| fk_plot_lookuptreesless4metercountfactor |
|
|
Restrict delete | ||
| fk_plot_cluster |
|
|
Cascade on delete | ||
| fk_plot_lookuplayertype |
|
|
Restrict delete | ||
| fk_plot_lookupmarkingprofile |
|
|
Restrict delete | ||
| fk_plot_lookupmanagementtype |
|
|
Restrict delete | ||
| fk_plot_lookupgrowthdistrict |
|
|
Restrict delete | ||
| fk_plot_lookupheightlayerclass |
|
|
Restrict delete | ||
| fk_plot_lookupterrainform |
|
|
Restrict delete | ||
| fk_plot_lookuppropertytype |
|
|
Restrict delete | ||
| fk_plot_lookupforesttype |
|
|
Restrict delete | ||
| fk_plot_lookuppropertysizeclass |
|
|
Restrict delete | ||
| fk_plot_lookupforestdecision |
|
|
Restrict delete | ||
| fk_plot_lookupforestrydepartment |
|
|
Restrict delete | ||
| fk_plot_lookuptreesless4meterlayer |
|
|
Restrict delete | ||
| fk_plot_lookuphabitattype |
|
|
Restrict delete | ||
| fk_plot_lookupmarkingstate |
|
|
Restrict delete | ||
| fk_plot_lookupharvestingmethod |
|
|
Restrict delete | ||
| fk_plot_lookupstandlayer |
|
|
Restrict delete | ||
| fk_plot_lookuplanduse |
|
|
Restrict delete | ||
| fk_plot_lookupuserestriction |
|
|
Restrict delete | ||
| fk_plot_samplingstrata |
|
|
Restrict delete | ||
| fk_plot_lookupstandphase |
|
|
Restrict delete | ||
| fk_saplings1m_lookuptreespecies |
|
|
Restrict delete | ||
| fk_saplings1m_plot |
|
|
Cascade on delete | ||
| fk_saplings1m_lookupbitten |
|
|
Restrict delete | ||
| fk_saplings1m_plotlocation |
|
|
Cascade on delete | ||
| fk_lookupgrowtharea |
|
|
Restrict delete | ||
| fk_edge_lookupedgetype |
|
|
Restrict delete | ||
| fk_edge_lookupedgestate |
|
|
Restrict delete | ||
| fk_edge_lookupterrain |
|
|
Restrict delete | ||
| fk_edges_plot |
|
|
Cascade on delete | ||
| fk_plot_location_plot_id |
|
|
Cascade on delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| edges | ck_edges_geometry | (st_isvalid(geometry)) |