hold_request

265 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('action.hold_request_id_seq'::regclass)
batch_hold_event_map.hold batch_hold_event_map_hold_fkey C
emergency_closing_hold.hold emergency_closing_hold_hold_fkey C
hold_copy_map.hold hold_copy_map_hold_fkey C
hold_notification.hold hold_notification_hold_fkey C
hold_request_note.hold hold_request_note_hold_fkey C
hold_request_reset_reason_entry.hold hold_request_reset_reason_entry_hold_fkey R
hold_transit_copy.hold hold_transit_copy_hold_fkey N
request_time timestamptz 35,6 now()
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
hold_request_cancel_cause.id hold_request_cancel_cause_fkey N
cancel_note text 2147483647 √ null
canceled_by int4 10 √ null
usr.id hold_request_canceled_by_fkey R
canceling_ws int4 10 √ null
workstation.id hold_request_canceling_ws_fkey R
target int8 19 null
current_copy int8 19 √ null
fulfillment_staff int4 10 √ null
usr.id hold_request_fulfillment_staff_fkey R
fulfillment_lib int4 10 √ null
org_unit.id hold_request_fulfillment_lib_fkey R
request_lib int4 10 null
org_unit.id hold_request_request_lib_fkey R
requestor int4 10 null
usr.id hold_request_requestor_fkey R
usr int4 10 null
usr.id hold_request_usr_fkey R
selection_ou int4 10 null
org_unit.id hold_request_selection_ou_fkey R
selection_depth int4 10 0
pickup_lib int4 10 null
org_unit.id hold_request_pickup_lib_fkey R
hold_type text 2147483647 √ null
hold_type.hold_type hold_request_hold_type_fkey R
holdable_formats text 2147483647 √ null
phone_notify text 2147483647 √ null
email_notify bool 1 false
sms_notify text 2147483647 √ null
sms_carrier int4 10 √ null
sms_carrier.id hold_request_sms_carrier_fkey R
frozen bool 1 false
thaw_date timestamptz 35,6 √ null
shelf_time timestamptz 35,6 √ null
cut_in_line bool 1 √ null
mint_condition bool 1 true
shelf_expire_time timestamptz 35,6 √ null
current_shelf_lib int4 10 √ null
org_unit.id hold_request_current_shelf_lib_fkey R
behind_desk bool 1 false
hopeless_date timestamptz 35,6 √ null
acq_request int4 10 √ null
user_request.id hold_request_acq_request_fkey R

Indexes

Constraint Name Type Sort Column(s)
hold_request_pkey Primary key Asc id
hold_fulfillment_time_idx Performance Asc fulfillment_time
hold_request_capture_protect_idx Must be unique Asc current_copy
hold_request_copy_capture_time_idx Performance Asc/Asc current_copy + capture_time
hold_request_current_copy_before_cap_idx Performance Asc current_copy
hold_request_current_copy_idx Performance Asc current_copy
hold_request_fulfillment_staff_idx Performance Asc fulfillment_staff
hold_request_hopeless_date_idx Performance Asc hopeless_date
hold_request_open_captured_shelf_lib_idx Performance Asc current_shelf_lib
hold_request_open_idx Performance Asc id
hold_request_pickup_lib_idx Performance Asc pickup_lib
hold_request_prev_check_time_idx Performance Asc prev_check_time
hold_request_requestor_idx Performance Asc requestor
hold_request_target_idx Performance Asc target
hold_request_time_idx Performance Asc request_time
hold_request_usr_idx Performance Asc usr

Check Constraints

Constraint Name Constraint
sms_check (((sms_notify IS NULL) OR (sms_carrier IS NOT NULL)))

Relationships

Close relationships within degrees of separation