acq.user_request

Cascading Deletes: Deleting rows from this table will cascade to: biblio.record_entry, acq.lineitem.

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('acq.user_request_id_seq'::regclass)
usr FK	`integer`	No		→ actor.usr(id)
hold	`boolean`	No	true
pickup_lib FK	`integer`	No		→ actor.org_unit(id)
holdable_formats	`text`	Yes
phone_notify	`text`	Yes
email_notify	`boolean`	No	true
lineitem FK	`integer`	Yes		→ acq.lineitem(id)
eg_bib FK	`bigint`	Yes		→ biblio.record_entry(id)
request_date	`timestamp with time zone`	No	now()
need_before	`timestamp with time zone`	Yes
max_fee	`text`	Yes
request_type FK	`integer`	No		→ acq.user_request_type(id)
isxn	`text`	Yes
upc	`text`	Yes
title	`text`	Yes
volume	`text`	Yes
author	`text`	Yes
article_title	`text`	Yes
article_pages	`text`	Yes
publisher	`text`	Yes
location	`text`	Yes
pubdate	`text`	Yes
mentioned	`text`	Yes
other_info	`text`	Yes
cancel_reason FK	`integer`	Yes		→ acq.cancel_reason(id)
cancel_time	`timestamp with time zone`	Yes

id PK

integer

nextval('acq.user_request_id_seq'::regclass)

usr FK

integer

→ actor.usr(id)

hold

boolean

true

pickup_lib FK

integer

→ actor.org_unit(id)

holdable_formats

text

Yes

phone_notify

text

Yes

email_notify

boolean

true

lineitem FK

integer

Yes

→ acq.lineitem(id)

eg_bib FK

bigint

Yes

→ biblio.record_entry(id)

request_date

timestamp with time zone

now()

need_before

timestamp with time zone

Yes

max_fee

text

Yes

request_type FK

integer

→ acq.user_request_type(id)

isxn

text

Yes

upc

text

Yes

title

text

Yes

volume

text

Yes

author

text

Yes

article_title

text

Yes

article_pages

text

Yes

publisher

text

Yes

location

text

Yes

pubdate

text

Yes

mentioned

text

Yes

other_info

text

Yes

cancel_reason FK

integer

Yes

→ acq.cancel_reason(id)

cancel_time

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
`cancel_reason`	acq.cancel_reason(id)	NO ACTION	NO ACTION	DEFERRED	`user_request_cancel_reason_fkey`
`eg_bib`	biblio.record_entry(id)	CASCADE	NO ACTION	No	`user_request_eg_bib_fkey`
`lineitem`	acq.lineitem(id)	CASCADE	NO ACTION	No	`user_request_lineitem_fkey`
`pickup_lib`	actor.org_unit(id)	NO ACTION	NO ACTION	No	`user_request_pickup_lib_fkey`
`request_type`	acq.user_request_type(id)	NO ACTION	NO ACTION	No	`user_request_request_type_fkey`
`usr`	actor.usr(id)	NO ACTION	NO ACTION	No	`user_request_usr_fkey`