actor.usr_delta_history

↑ actor schema

Cascading Deletes: Rows in this table will be automatically deleted when rows are deleted from: actor.usr.

Written by External Triggers: This table can receive writes triggered by operations on other tables:

record_usr_delta on actor.usr → INSERT into this table

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`bigint`	No	nextval('actor.usr_delta_history_id_seq'::regclass)
eg_user FK	`integer`	Yes		→ actor.usr(id)
eg_ws FK	`integer`	Yes		→ actor.workstation(id)
usr_id FK	`integer`	No		→ actor.usr(id)
change_time	`timestamp with time zone`	No	now()
delta	`jsonb`	No
keylist	`text[]`	Yes

id PK

bigint

nextval('actor.usr_delta_history_id_seq'::regclass)

eg_user FK

integer

Yes

→ actor.usr(id)

eg_ws FK

integer

Yes

→ actor.workstation(id)

usr_id FK

integer

→ actor.usr(id)

change_time

timestamp with time zone

now()

delta

jsonb

keylist

text[]

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`eg_user`	actor.usr(id)	SET NULL	CASCADE	No	`usr_delta_history_eg_user_fkey`
`eg_ws`	actor.workstation(id)	SET NULL	CASCADE	No	`usr_delta_history_eg_ws_fkey`
`usr_id`	actor.usr(id)	CASCADE	CASCADE	No	`usr_delta_history_usr_id_fkey`

eg_user

actor.usr(id)

SET NULL

CASCADE

usr_delta_history_eg_user_fkey

eg_ws

actor.workstation(id)

SET NULL

CASCADE

usr_delta_history_eg_ws_fkey

usr_id

actor.usr(id)

CASCADE

usr_delta_history_usr_id_fkey

Indexes

Index Method Definition

Index	Method	Definition
`usr_delta_history_pkey` PK	btree	`CREATE UNIQUE INDEX usr_delta_history_pkey ON actor.usr_delta_history USING btree (id)`

usr_delta_history_pkey PK

btree

CREATE UNIQUE INDEX usr_delta_history_pkey ON actor.usr_delta_history USING btree (id)