permission.grp_penalty_threshold

↑ permission schema

Cascading Deletes: Deleting rows from this table will cascade to: permission.grp_tree, actor.org_unit, config.standing_penalty.

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: grp_penalty_threshold_grp_fkey, grp_penalty_threshold_org_unit_fkey, grp_penalty_threshold_penalty_fkey.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('permission.grp_penalty_threshold_id_seq'::regclass)
grp FK	`integer`	No		→ permission.grp_tree(id)
org_unit FK	`integer`	No		→ actor.org_unit(id)
penalty FK	`integer`	No		→ config.standing_penalty(id)
threshold	`numeric(8,2)`	No

id PK

integer

nextval('permission.grp_penalty_threshold_id_seq'::regclass)

grp FK

integer

→ permission.grp_tree(id)

org_unit FK

integer

→ actor.org_unit(id)

penalty FK

integer

→ config.standing_penalty(id)

threshold

numeric(8,2)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`grp`	permission.grp_tree(id)	CASCADE	NO ACTION	DEFERRED	`grp_penalty_threshold_grp_fkey`
`org_unit`	actor.org_unit(id)	CASCADE	NO ACTION	DEFERRED	`grp_penalty_threshold_org_unit_fkey`
`penalty`	config.standing_penalty(id)	CASCADE	NO ACTION	DEFERRED	`grp_penalty_threshold_penalty_fkey`

grp

permission.grp_tree(id)

CASCADE

NO ACTION

DEFERRED

grp_penalty_threshold_grp_fkey

org_unit

actor.org_unit(id)

CASCADE

NO ACTION

DEFERRED

grp_penalty_threshold_org_unit_fkey

penalty

config.standing_penalty(id)

CASCADE

NO ACTION

DEFERRED

grp_penalty_threshold_penalty_fkey

Unique Constraints

penalty_grp_once: (grp, penalty, org_unit)

Indexes

Index Method Definition

Index	Method	Definition
`grp_penalty_threshold_pkey` PK	btree	`CREATE UNIQUE INDEX grp_penalty_threshold_pkey ON permission.grp_penalty_threshold USING btree (id)`
`penalty_grp_once` UNIQUE	btree	`CREATE UNIQUE INDEX penalty_grp_once ON permission.grp_penalty_threshold USING btree (grp, penalty, org_unit)`

grp_penalty_threshold_pkey PK

btree

CREATE UNIQUE INDEX grp_penalty_threshold_pkey ON permission.grp_penalty_threshold USING btree (id)

penalty_grp_once UNIQUE

btree

CREATE UNIQUE INDEX penalty_grp_once ON permission.grp_penalty_threshold USING btree (grp, penalty, org_unit)