user_request

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('acq.user_request_id_seq'::regclass)
hold_request.acq_request hold_request_acq_request_fkey R
usr int4 10 null
usr.id user_request_usr_fkey R
hold bool 1 true
pickup_lib int4 10 null
org_unit.id user_request_pickup_lib_fkey R
holdable_formats text 2147483647 √ null
phone_notify text 2147483647 √ null
email_notify bool 1 true
lineitem int4 10 √ null
lineitem.id user_request_lineitem_fkey C
eg_bib int8 19 √ null
record_entry.id user_request_eg_bib_fkey C
request_date timestamptz 35,6 now()
need_before timestamptz 35,6 √ null
max_fee text 2147483647 √ null
request_type int4 10 null
user_request_type.id user_request_request_type_fkey R
isxn text 2147483647 √ null
upc text 2147483647 √ null
title text 2147483647 √ null
volume text 2147483647 √ null
author text 2147483647 √ null
article_title text 2147483647 √ null
article_pages text 2147483647 √ null
publisher text 2147483647 √ null
location text 2147483647 √ null
pubdate text 2147483647 √ null
mentioned text 2147483647 √ null
other_info text 2147483647 √ null
cancel_reason int4 10 √ null
cancel_reason.id user_request_cancel_reason_fkey R
cancel_time timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
user_request_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation