aged_hold_request

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
usr_post_code text 2147483647 √ null
usr_home_ou int4 10 null
usr_profile int4 10 null
usr_birth_year int4 10 √ null
staff_placed bool 1 null
id int4 10 null
request_time timestamptz 35,6 null
capture_time timestamptz 35,6 √ null
fulfillment_time timestamptz 35,6 √ null
checkin_time timestamptz 35,6 √ null
return_time timestamptz 35,6 √ null
prev_check_time timestamptz 35,6 √ null
expire_time timestamptz 35,6 √ null
cancel_time timestamptz 35,6 √ null
cancel_cause int4 10 √ null
cancel_note text 2147483647 √ null
target int8 19 null
current_copy int8 19 √ null
fulfillment_staff int4 10 √ null
fulfillment_lib int4 10 √ null
request_lib int4 10 null
selection_ou int4 10 null
selection_depth int4 10 null
pickup_lib int4 10 null
hold_type text 2147483647 √ null
holdable_formats text 2147483647 √ null
phone_notify bool 1 null
email_notify bool 1 null
sms_notify bool 1 null
frozen bool 1 null
thaw_date timestamptz 35,6 √ null
shelf_time timestamptz 35,6 √ null
cut_in_line bool 1 √ null
mint_condition bool 1 null
shelf_expire_time timestamptz 35,6 √ null
current_shelf_lib int4 10 √ null
behind_desk bool 1 null
hopeless_date timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
aged_hold_request_pkey Primary key Asc id
aged_hold_request_current_copy_idx Performance Asc current_copy
aged_hold_request_fulfillment_staff_idx Performance Asc fulfillment_staff
aged_hold_request_pickup_lib_idx Performance Asc pickup_lib
aged_hold_request_target_idx Performance Asc target

Relationships

Close relationships within degrees of separation