Evergreen
HomePrev Chapter 26. Database Schema Next

Schema permission

Table: grp_penalty_threshold

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
grp : integer -- UNIQUE#1, NOT NULL, REFERENCES permission.grp_tree.
org_unit : integer -- UNIQUE#1, NOT NULL, REFERENCES actor.org_unit.
penalty : integer -- UNIQUE#1, NOT NULL, REFERENCES config.standing_penalty.
threshold : numeric(8,2) -- NOT NULL,

Table: grp_perm_map

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
grp : integer -- UNIQUE#1, NOT NULL, REFERENCES permission.grp_tree.
perm : integer -- UNIQUE#1, NOT NULL, REFERENCES permission.perm_list.
depth : integer -- NOT NULL,
grantable : boolean -- NOT NULL, DEFAULT false,

Table: grp_tree

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
name : text -- UNIQUE, NOT NULL,
parent : integer -- REFERENCES permission.grp_tree.
usergroup : boolean -- NOT NULL, DEFAULT true,
perm_interval : interval -- NOT NULL, DEFAULT '3 years'::interval,
description : text --
application_perm : text --

Indexes: 

grp_tree_parent_idx : parent

Tables referencing actor.usr via Foreign Key Constraints: 

actor.usrconfig.circ_matrix_matchpoint
config.hold_matrix_matchpointpermission.grp_penalty_threshold
permission.grp_perm_mappermission.grp_tree
permission.usr_grp_map 

Table: perm_list

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
code : text -- UNIQUE, NOT NULL,
description : text --

Indexes: 

perm_list_code_idx : code

Tables referencing config.org_unit_setting_type via Foreign Key Constraints: 

config.org_unit_setting_typepermission.grp_perm_map
permission.usr_object_perm_mappermission.usr_perm_map

Table: usr_grp_map

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
usr : integer -- UNIQUE#1, NOT NULL, REFERENCES actor.usr.
grp : integer -- UNIQUE#1, NOT NULL, REFERENCES permission.grp_tree.

Table: usr_object_perm_map

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
usr : integer -- UNIQUE#1, NOT NULL, REFERENCES actor.usr.
perm : integer -- UNIQUE#1, NOT NULL, REFERENCES permission.perm_list.
object_type : text -- UNIQUE#1, NOT NULL,
object_id : text -- UNIQUE#1, NOT NULL,
grantable : boolean -- NOT NULL, DEFAULT false,

Indexes: 

uopm_usr_idx : usr

Table: usr_perm_map

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
usr : integer -- UNIQUE#1, NOT NULL, REFERENCES actor.usr.
perm : integer -- UNIQUE#1, NOT NULL, REFERENCES permission.perm_list.
depth : integer -- NOT NULL,
grantable : boolean -- NOT NULL, DEFAULT false,

Table: usr_work_ou_map

Columns: 

field name : datatype -- parameters, contraints and notes
id : serial -- PRIMARY KEY,
usr : integer -- UNIQUE#1, NOT NULL, REFERENCES actor.usr.
work_ou : integer -- UNIQUE#1, NOT NULL, REFERENCES actor.org_unit.

grp_ancestors(integer)

Function Properties
Language: SQL
Return Type: SET OF grp_tree

grp_ancestors_distance(distance integer)

Function Properties
Language: SQL
Return Type: SET OF record

grp_descendants_distance(distance integer)

Function Properties
Language: SQL
Return Type: SET OF record

usr_can_grant_perm(target_ou integer, tperm text, iuser integer)

Function Properties
Language: PLPGSQL
Return Type: boolean

usr_has_home_perm(target_ou integer, tperm text, iuser integer)

Function Properties
Language: PLPGSQL
Return Type: boolean

usr_has_object_perm(integer, text, text, text)

Function Properties
Language: SQL
Return Type: boolean

usr_has_object_perm(target_ou integer, obj_id text, obj_type text, tperm text, iuser integer)

Function Properties
Language: PLPGSQL
Return Type: boolean

usr_has_perm(integer, text, integer)

Function Properties
Language: SQL
Return Type: boolean

usr_has_perm_at(perm_code integer, user_id text)

Function Properties
Language: SQL
Return Type: SET OF integer

usr_has_perm_at_all(perm_code integer, user_id text)

Function Properties
Language: SQL
Return Type: SET OF integer

usr_has_perm_at_all_nd(perm_code integer, user_id text)

Function Properties
Language: PLPGSQL
Return Type: SET OF integer

usr_has_perm_at_nd(perm_code integer, user_id text)

Function Properties
Language: PLPGSQL
Return Type: SET OF integer

usr_has_work_perm(target_ou integer, tperm text, iuser integer)

Function Properties
Language: PLPGSQL
Return Type: boolean

usr_perms(integer)

Function Properties
Language: SQL
Return Type: SET OF usr_perm_map

Prev Up Next
Schema offline Home Schema public