action.hold_request_note

Cascading Deletes: Deleting rows from this table will cascade to: action.hold_request.

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`bigint`	No	nextval('action.hold_request_note_id_seq'::regclass)
hold FK	`bigint`	No		→ action.hold_request(id)
title	`text`	No
body	`text`	No
slip	`boolean`	No	false
pub	`boolean`	No	false
staff	`boolean`	No	false

id PK

bigint

nextval('action.hold_request_note_id_seq'::regclass)

hold FK

bigint

→ action.hold_request(id)

title

text

body

text

slip

boolean

false

pub

boolean

false

staff

boolean

false

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`hold`	action.hold_request(id)	CASCADE	NO ACTION	DEFERRED	`hold_request_note_hold_fkey`

hold

action.hold_request(id)

CASCADE

NO ACTION

DEFERRED

hold_request_note_hold_fkey

Indexes

Index Method Definition

Index	Method	Definition
`hold_request_note_pkey` PK	btree	`CREATE UNIQUE INDEX hold_request_note_pkey ON action.hold_request_note USING btree (id)`
`ahrn_hold_idx`	btree	`CREATE INDEX ahrn_hold_idx ON action.hold_request_note USING btree (hold)`

hold_request_note_pkey PK

btree

CREATE UNIQUE INDEX hold_request_note_pkey ON action.hold_request_note USING btree (id)

ahrn_hold_idx

btree

CREATE INDEX ahrn_hold_idx ON action.hold_request_note USING btree (hold)