grp_tree

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('permission.grp_tree_id_seq'::regclass)
usr.profile actor_usr_profile_fkey R
circ_matrix_matchpoint.grp circ_matrix_matchpoint_grp_fkey R
hold_matrix_matchpoint.requestor_grp hold_matrix_matchpoint_requestor_grp_fkey R
hold_matrix_matchpoint.usr_grp hold_matrix_matchpoint_usr_grp_fkey R
group_mfa_factor_map.grp group_mfa_factor_map_grp_fkey C
grp_penalty_threshold.grp grp_penalty_threshold_grp_fkey C
grp_perm_map.grp grp_perm_map_grp_fkey C
grp_tree.parent grp_tree_parent_fkey R
grp_tree_display_entry.grp grp_tree_display_entry_grp_fkey R
usr_grp_map.grp usr_grp_map_grp_fkey C
name text 2147483647 null
parent int4 10 √ null
grp_tree.id grp_tree_parent_fkey R
usergroup bool 1 true
perm_interval interval 49,6 '3 years'::interval
description text 2147483647 √ null
application_perm text 2147483647 √ null
hold_priority int4 10 0
mfa_allowed bool 1 false
mfa_required bool 1 false

Indexes

Constraint Name Type Sort Column(s)
grp_tree_pkey Primary key Asc id
grp_tree_name_key Must be unique Asc name
grp_tree_parent_idx Performance Asc parent

Relationships

Close relationships within degrees of separation