permission.perm_list

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default
id PK	`integer`	No	nextval('permission.perm_list_id_seq'::regclass)
code	`text`	No
description	`text`	Yes

id PK

integer

nextval('permission.perm_list_id_seq'::regclass)

code

text

description

text

Yes

(id)

Index Method Definition

Index	Method	Definition
`perm_list_pkey` PK	btree	`CREATE UNIQUE INDEX perm_list_pkey ON permission.perm_list USING btree (id)`
`perm_list_code_key` UNIQUE	btree	`CREATE UNIQUE INDEX perm_list_code_key ON permission.perm_list USING btree (code)`
`perm_list_code_idx`	btree	`CREATE INDEX perm_list_code_idx ON permission.perm_list USING btree (code)`

perm_list_pkey PK

btree

CREATE UNIQUE INDEX perm_list_pkey ON permission.perm_list USING btree (id)

perm_list_code_key UNIQUE

btree

CREATE UNIQUE INDEX perm_list_code_key ON permission.perm_list USING btree (code)

perm_list_code_idx

btree

CREATE INDEX perm_list_code_idx ON permission.perm_list USING btree (code)

Trigger Timing Event Level Function

Trigger	Timing	Event	Level	Function
`maintain_perm_i18n_tgr`	AFTER	UPDATE	ROW	`evergreen.oils_i18n_id_tracking()`

maintain_perm_i18n_tgr

AFTER

UPDATE

ROW

Function: evergreen.oils_i18n_id_tracking()
Timing: AFTER UPDATE ROW

BEGIN
    PERFORM oils_i18n_update_apply( OLD.id::TEXT, NEW.id::TEXT, TG_ARGV[0]::TEXT );
    RETURN NEW;
END;

The following tables have foreign keys pointing to permission.perm_list (10 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

Table	Referencing Column(s)	Referenced Column(s)	Constraint
config.org_unit_setting_type	`update_perm`	`id`	`update_perm_fkey`
config.org_unit_setting_type	`view_perm`	`id`	`view_perm_fkey`
config.remoteauth_profile	`perm`	`id`	`remoteauth_profile_perm_fkey`
config.z3950_source	`use_perm`	`id`	`use_perm_fkey`
openapi.endpoint_perm_map	`perm`	`id`	`endpoint_perm_map_perm_fkey`
openapi.endpoint_set_perm_map	`perm`	`id`	`endpoint_set_perm_map_perm_fkey`
openapi.perm_set_perm_map	`perm`	`id`	`perm_set_perm_map_perm_fkey`
permission.grp_perm_map	`perm`	`id`	`grp_perm_map_perm_fkey`
permission.usr_object_perm_map	`perm`	`id`	`usr_object_perm_map_perm_fkey`
permission.usr_perm_map	`perm`	`id`	`usr_perm_map_perm_fkey`