action.batch_hold_event

↑ action schema

Cascading Deletes: Deleting rows from this table will cascade to: container.user_bucket, actor.usr.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('action.batch_hold_event_id_seq'::regclass)
staff FK	`integer`	No		→ actor.usr(id)
bucket FK	`integer`	No		→ container.user_bucket(id)
target	`integer`	No
hold_type	`text`	No	'T'::text
run_date	`timestamp with time zone`	No	now()
cancelled	`timestamp with time zone`	Yes

id PK

integer

nextval('action.batch_hold_event_id_seq'::regclass)

staff FK

integer

→ actor.usr(id)

bucket FK

integer

→ container.user_bucket(id)

target

integer

hold_type

text

'T'::text

run_date

timestamp with time zone

now()

cancelled

timestamp with time zone

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`bucket`	container.user_bucket(id)	CASCADE	CASCADE	No	`batch_hold_event_bucket_fkey`
`staff`	actor.usr(id)	CASCADE	CASCADE	No	`batch_hold_event_staff_fkey`

bucket

container.user_bucket(id)

CASCADE

batch_hold_event_bucket_fkey

staff

actor.usr(id)

CASCADE

batch_hold_event_staff_fkey

Indexes

Index Method Definition

Index	Method	Definition
`batch_hold_event_pkey` PK	btree	`CREATE UNIQUE INDEX batch_hold_event_pkey ON action.batch_hold_event USING btree (id)`

batch_hold_event_pkey PK

btree

CREATE UNIQUE INDEX batch_hold_event_pkey ON action.batch_hold_event USING btree (id)

Referenced By

The following tables have foreign keys pointing to action.batch_hold_event (1 referencing table(s)):

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

Table	Referencing Column(s)	Referenced Column(s)	Constraint
action.batch_hold_event_map	`batch_hold_event`	`id`	`batch_hold_event_map_batch_hold_event_fkey`

action.batch_hold_event_map

batch_hold_event

id

batch_hold_event_map_batch_hold_event_fkey