actor.usr_standing_penalty

User standing penalties

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

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: usr_standing_penalty_org_unit_fkey, usr_standing_penalty_staff_fkey, usr_standing_penalty_standing_penalty_fkey, usr_standing_penalty_usr_fkey.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('actor.usr_message_id_seq'::regclass)
org_unit FK	`integer`	No		→ actor.org_unit(id)
usr FK	`integer`	No		→ actor.usr(id)
standing_penalty FK	`integer`	No		→ config.standing_penalty(id)
staff FK	`integer`	Yes		→ actor.usr(id)
set_date	`timestamp with time zone`	Yes	now()
stop_date	`timestamp with time zone`	Yes
usr_message FK	`bigint`	Yes		→ actor.usr_message(id)

id PK

integer

nextval('actor.usr_message_id_seq'::regclass)

org_unit FK

integer

→ actor.org_unit(id)

usr FK

integer

→ actor.usr(id)

standing_penalty FK

integer

→ config.standing_penalty(id)

staff FK

integer

Yes

→ actor.usr(id)

set_date

timestamp with time zone

Yes

now()

stop_date

timestamp with time zone

Yes

usr_message FK

bigint

Yes

→ actor.usr_message(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`org_unit`	actor.org_unit(id)	CASCADE	NO ACTION	DEFERRED	`usr_standing_penalty_org_unit_fkey`
`staff`	actor.usr(id)	SET NULL	NO ACTION	DEFERRED	`usr_standing_penalty_staff_fkey`
`standing_penalty`	config.standing_penalty(id)	CASCADE	NO ACTION	DEFERRED	`usr_standing_penalty_standing_penalty_fkey`
`usr`	actor.usr(id)	CASCADE	NO ACTION	DEFERRED	`usr_standing_penalty_usr_fkey`
`usr_message`	actor.usr_message(id)	NO ACTION	NO ACTION	No	`usr_standing_penalty_usr_message_fkey`

org_unit

actor.org_unit(id)

CASCADE

NO ACTION

DEFERRED

usr_standing_penalty_org_unit_fkey

staff

actor.usr(id)

SET NULL

NO ACTION

DEFERRED

usr_standing_penalty_staff_fkey

standing_penalty

config.standing_penalty(id)

CASCADE

NO ACTION

DEFERRED

usr_standing_penalty_standing_penalty_fkey

usr

actor.usr(id)

CASCADE

NO ACTION

DEFERRED

usr_standing_penalty_usr_fkey

usr_message

actor.usr_message(id)

NO ACTION

usr_standing_penalty_usr_message_fkey

Indexes

Index Method Definition

Index	Method	Definition
`usr_standing_penalty_pkey` PK	btree	`CREATE UNIQUE INDEX usr_standing_penalty_pkey ON actor.usr_standing_penalty USING btree (id)`
`actor_usr_standing_penalty_staff_idx`	btree	`CREATE INDEX actor_usr_standing_penalty_staff_idx ON actor.usr_standing_penalty USING btree (staff)`
`actor_usr_standing_penalty_usr_idx`	btree	`CREATE INDEX actor_usr_standing_penalty_usr_idx ON actor.usr_standing_penalty USING btree (usr)`
`usr_standing_penalty_usr_message_idx`	btree	`CREATE INDEX usr_standing_penalty_usr_message_idx ON actor.usr_standing_penalty USING btree (usr_message)`

usr_standing_penalty_pkey PK

btree

CREATE UNIQUE INDEX usr_standing_penalty_pkey ON actor.usr_standing_penalty USING btree (id)

actor_usr_standing_penalty_staff_idx

btree

CREATE INDEX actor_usr_standing_penalty_staff_idx ON actor.usr_standing_penalty USING btree (staff)

actor_usr_standing_penalty_usr_idx

btree

CREATE INDEX actor_usr_standing_penalty_usr_idx ON actor.usr_standing_penalty USING btree (usr)

usr_standing_penalty_usr_message_idx

btree

CREATE INDEX usr_standing_penalty_usr_message_idx ON actor.usr_standing_penalty USING btree (usr_message)