actor.usr_privacy_waiver

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

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`bigint`	No	nextval('actor.usr_privacy_waiver_id_seq'::regclass)
usr FK	`bigint`	No		→ actor.usr(id)
name	`text`	No
place_holds	`boolean`	Yes	false
pickup_holds	`boolean`	Yes	false
view_history	`boolean`	Yes	false
checkout_items	`boolean`	Yes	false

id PK

bigint

nextval('actor.usr_privacy_waiver_id_seq'::regclass)

usr FK

bigint

→ actor.usr(id)

name

text

place_holds

boolean

Yes

false

pickup_holds

boolean

Yes

false

view_history

boolean

Yes

false

checkout_items

boolean

Yes

false

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`usr`	actor.usr(id)	CASCADE	NO ACTION	DEFERRED	`usr_privacy_waiver_usr_fkey`

usr

actor.usr(id)

CASCADE

NO ACTION

DEFERRED

usr_privacy_waiver_usr_fkey

Indexes

Index Method Definition

Index	Method	Definition
`usr_privacy_waiver_pkey` PK	btree	`CREATE UNIQUE INDEX usr_privacy_waiver_pkey ON actor.usr_privacy_waiver USING btree (id)`
`actor_usr_privacy_waiver_usr_idx`	btree	`CREATE INDEX actor_usr_privacy_waiver_usr_idx ON actor.usr_privacy_waiver USING btree (usr)`

usr_privacy_waiver_pkey PK

btree

CREATE UNIQUE INDEX usr_privacy_waiver_pkey ON actor.usr_privacy_waiver USING btree (id)

actor_usr_privacy_waiver_usr_idx

btree

CREATE INDEX actor_usr_privacy_waiver_usr_idx ON actor.usr_privacy_waiver USING btree (usr)