Chapter 17. Schema permission

Table of Contents

Tables in permission
grp_penalty_threshold
grp_perm_map
grp_tree
perm_list
usr_grp_map
usr_object_perm_map
usr_perm_map
usr_work_ou_map
Functions in permission

Below are the tables, views and functions for permission

Tables in permission

grp_penalty_threshold

  • id serial PRIMARY KEY
  • grp integer UNIQUE #1 NOT NULL REFERENCES permission.table.grp-tree
  • org_unit integer UNIQUE #1 NOT NULL REFERENCES actor.table.org-unit
  • penalty integer UNIQUE #1 NOT NULL REFERENCES config.table.standing-penalty
  • threshold numeric(8,2) NOT NULL

grp_perm_map

  • id serial PRIMARY KEY
  • grp integer UNIQUE #1 NOT NULL REFERENCES permission.table.grp-tree
  • perm integer UNIQUE #1 NOT NULL REFERENCES permission.table.perm-list
  • depth integer NOT NULL
  • grantable boolean NOT NULL DEFAULT false

grp_tree

  • id serial PRIMARY KEY
  • name text UNIQUE NOT NULL
  • parent integer REFERENCES permission.table.grp-tree
  • usergroup boolean NOT NULL DEFAULT true
  • perm_interval interval NOT NULL DEFAULT '3 years'::interval
  • description text
  • application_perm text
  • hold_priority integer NOT NULL

Indexes on grp_tree

  • grp_tree_parent_idx parent

Tables referencing via foreign key constraints

  • actor.usr
  • config.circ_matrix_matchpoint
  • config.hold_matrix_matchpoint
  • permission.grp_penalty_threshold
  • permission.grp_perm_map
  • permission.grp_tree
  • permission.usr_grp_map

perm_list

  • id serial PRIMARY KEY
  • code text UNIQUE NOT NULL
  • description text

Indexes on perm_list

  • perm_list_code_idx code

Tables referencing via foreign key constraints

  • config.org_unit_setting_type
  • config.z3950_source
  • permission.grp_perm_map
  • permission.usr_object_perm_map
  • permission.usr_perm_map

usr_grp_map

  • id serial PRIMARY KEY
  • usr integer UNIQUE #1 NOT NULL REFERENCES actor.table.usr
  • grp integer UNIQUE #1 NOT NULL REFERENCES permission.table.grp-tree

usr_object_perm_map

  • id serial PRIMARY KEY
  • usr integer UNIQUE #1 NOT NULL REFERENCES actor.table.usr
  • perm integer UNIQUE #1 NOT NULL REFERENCES permission.table.perm-list
  • object_type text UNIQUE #1 NOT NULL
  • object_id text UNIQUE #1 NOT NULL
  • grantable boolean NOT NULL DEFAULT false

Indexes on usr_object_perm_map

  • uopm_usr_idx usr

usr_perm_map

  • id serial PRIMARY KEY
  • usr integer UNIQUE #1 NOT NULL REFERENCES actor.table.usr
  • perm integer UNIQUE #1 NOT NULL REFERENCES permission.table.perm-list
  • depth integer NOT NULL
  • grantable boolean NOT NULL DEFAULT false

usr_work_ou_map

  • id serial PRIMARY KEY
  • usr integer UNIQUE #1 NOT NULL REFERENCES actor.table.usr
  • work_ou integer UNIQUE #1 NOT NULL REFERENCES actor.table.org-unit