Constraints

17 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
usr_work_ou_map_work_ou_fkey
usr_work_ou_map.work_ou
org_unit.id
Cascade on delete
usr_work_ou_map_usr_fkey
usr_work_ou_map.usr
usr.id
Cascade on delete
grp_tree_parent_fkey
grp_tree.parent
grp_tree.id
Restrict delete
usr_grp_map_grp_fkey
usr_grp_map.grp
grp_tree.id
Cascade on delete
usr_grp_map_usr_fkey
usr_grp_map.usr
usr.id
Cascade on delete
grp_perm_map_perm_fkey
grp_perm_map.perm
perm_list.id
Restrict delete
grp_perm_map_grp_fkey
grp_perm_map.grp
grp_tree.id
Cascade on delete
usr_perm_map_perm_fkey
usr_perm_map.perm
perm_list.id
Restrict delete
usr_perm_map_usr_fkey
usr_perm_map.usr
usr.id
Cascade on delete
usr_object_perm_map_usr_fkey
usr_object_perm_map.usr
usr.id
Cascade on delete
usr_object_perm_map_perm_fkey
usr_object_perm_map.perm
perm_list.id
Restrict delete
grp_penalty_threshold_grp_fkey
grp_penalty_threshold.grp
grp_tree.id
Cascade on delete
grp_penalty_threshold_org_unit_fkey
grp_penalty_threshold.org_unit
org_unit.id
Cascade on delete
grp_penalty_threshold_penalty_fkey
grp_penalty_threshold.penalty
standing_penalty.id
Cascade on delete
grp_tree_display_entry_grp_fkey
grp_tree_display_entry.grp
grp_tree.id
Restrict delete
grp_tree_display_entry_parent_fkey
grp_tree_display_entry.parent
grp_tree_display_entry.id
Restrict delete
grp_tree_display_entry_org_fkey
grp_tree_display_entry.org
org_unit.id
Restrict delete

Check Constraints

Table Constraint Name Constraint