Table webco_4.4.1.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
authset_checkout_center.checkout_center_oid fkauthset_checkout_center_checkout_center_oid
calendar_allocation_fields.checkout_center_oid calendar_allocation_fields_checkout_center_oid_fkey
checkout_center_auto_email.checkout_center_oid fkextcheckout_cernter_oid
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_cehckout_center
invoice.cc_oid fkcinvoice_cc_oid
person_checkout_center_signature.checkout_center_oid person_checkout_center_signature_checkout_center_oid_fkey
pir_person_checkout_center.checkout_center_oid fkcpir_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
pickup_default wcof_tag 2147483647
return_default wcof_tag 2147483647
default_delivery_type wcof_tag 2147483647
default_resource_selector wcof_tag 2147483647  √  null
timeline_zoom_factor int8 19  √  null
timeline_granularity int8 19  √  null
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
pir_session_timeout int4 10 15
pir_report_problems bool 1  √  true
billing_contact_name varchar 2147483647  √  null
billing_contact_phone varchar 2147483647  √  null
billing_contact_email varchar 2147483647  √  null
email_template_set 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
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
crestron_host varchar 2147483647  √  null
crestron_port int8 19  √  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
default_allocation_times wcof_default_allocation_times 2147483647  √  null
timezone varchar 2147483647  √  null
locale varchar 2147483647  √  null
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

Table contained 1 rows at Fri Mar 24 10:48 CDT 2017

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: