Table webco_5.0.public.checkout_center Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
obj_oid int8 19
agreement_form_config.checkout_center_oid agreement_form_config_checkout_center_oid
allocation.checkout_center_oid fkcalloc_checkout_center_oid
calendar_allocation_fields.checkout_center_oid calendar_allocation_fields_checkout_center_oid_fkey
checkout_center_default_task_profile.checkout_center_oid checkout_center_default_task_profile_checkout_center_oid_fkey
checkout_center_pir_pickup_option.checkout_center_oid checkout_center_pir_pickup_option_checkout_center_oid_fkey
checkout_center_schedule.checkout_center_oid fkccheckout_center_schedule_checkout_center
hold.checkout_center_oid fkchold_cc_oid
inventory_selector.checkout_center_oid inventory_selector_checkout_center_oid_fkey
invoice.cc_oid fkcinvoice_cc_oid
person_checkout_center_signature.checkout_center_oid person_checkout_center_signature_checkout_center_oid_fkey
person_role_checkout_center.checkout_center_oid fkcapability_checkout_center_checkout_center_oid
resource.checkout_center_oid resource_checkout_center_oid_fkey
turndown.checkout_center_oid turndown_checkout_center_oid_fkey
wco_application.default_checkout_center_oid fkapp_default_loc_oid
wco_log.checkout_center_oid fkcwco_log_cc_oid
wco_station.checkout_center_oid fkcwco_station_checkout_center_oid
name varchar 2147483647
description varchar 2147483647  √  null
org_oid int8 19
organization.obj_oid checkout_center_org_oid_fkey
default_delivery_type wcof_tag 2147483647
default_resource_selector wcof_tag 2147483647  √  null
timeline_zoom_factor int8 19  √  null
timeline_granularity int8 19  √  null
show_resource_timelines bool 1 true
building varchar 2147483647  √  null
room varchar 2147483647  √  null
address varchar 2147483647  √  null
telephone varchar 2147483647  √  null
print_queue varchar 2147483647  √  'wco_local'::character varying
allocation_mode wcof_tag 2147483647  √  null
pir_mode wcof_tag 2147483647  √  null
repeats_in_pir bool 1  √  null
pir_requires_approval bool 1  √  null
pir_restrict_delivery_locations bool 1  √  null
set_location_in_patron_portal wcof_tag 2147483647 'ALLOW'::wcof_tag
pir_session_timeout int4 10 15
pir_requires_event_title wcof_tag 2147483647  √  null
pir_report_problems bool 1  √  true
patron_portal_show_groups bool 1  √  true
billing_contact_name varchar 2147483647  √  null
billing_contact_phone varchar 2147483647  √  null
billing_contact_email varchar 2147483647  √  null
print_template_set varchar 2147483647  √  null
messaging_from_address varchar 2147483647  √  null
reply_to_address varchar 2147483647  √  null
day_rollover int4 10
cc_set_strike bool 1  √  null
suppress_set_strike_email_to_patron bool 1  √  true
patron_access_requires_authorization bool 1  √  true
circulation_requires_authorization bool 1  √  false
patron_portal_email_notification bool 1  √  null
patron_portal_notification_email_address varchar 2147483647  √  null
patron_portal_help_link varchar 2147483647  √  null
cc_reporting_patron bool 1  √  null
usage_exclude_closed bool 1  √  null
pir_media_cc_query bool 1  √  null
pir_motd varchar 2147483647  √  null
require_signature_on_file bool 1  √  false
force_barcode_scanning bool 1  √  null
allow_rrt_pickup bool 1  √  true
allow_rrt_autoassignment bool 1  √  true
require_scan_to_return bool 1  √  false
allow_return_all bool 1  √  true
default_allocation_times wcof_default_allocation_times 2147483647  √  null
timezone varchar 2147483647  √  null
locale varchar 2147483647  √  null
honor_external_holds _int4 10 ARRAY[]::integer[]
honor_external_fines _int4 10 ARRAY[]::integer[]
honor_external_lates _int4 10 ARRAY[]::integer[]
form_date_time_format wcof_tag 2147483647
agreement_form_sorting wcof_tag 2147483647
agreement_form_grouping wcof_tag 2147483647
custom_agreement_form_oid int8 19  √  null
agreement_form_config.obj_oid checkout_center_custom_agreement_form_oid_fkey
email_template_set_oid int8 19  √  null
email_template_set.obj_oid checkout_center_email_template_set_oid_fkey

Table contained 1 rows at Thu Feb 14 09:10 CST 2019

Indexes:
Column(s) Type Sort Constraint Name
obj_oid Primary key Asc checkout_center_pkey
name Must be unique Asc checkout_center_name_key

Close relationships  within of separation: