checkout_center

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_oid int8 19 null
agreement_form_config.checkout_center_oid agreement_form_config_checkout_center_oidC
allocation.checkout_center_oid fkcalloc_checkout_center_oidC
calendar_allocation_fields.checkout_center_oid calendar_allocation_fields_checkout_center_oid_fkeyC
checkout_center_default_task_profile.checkout_center_oid checkout_center_default_task_profile_checkout_center_oid_fkeyC
checkout_center_pir_pickup_option.checkout_center_oid checkout_center_pir_pickup_option_checkout_center_oid_fkeyC
checkout_center_schedule.checkout_center_oid fkccheckout_center_schedule_checkout_centerC
hold.checkout_center_oid fkchold_cc_oidC
inventory_selector.checkout_center_oid inventory_selector_checkout_center_oid_fkeyN
invoice.cc_oid fkcinvoice_cc_oidC
patron_custom_data.checkout_center_oid patron_custom_data_checkout_center_oid_fkeyC
patron_portal_property.checkout_center_oid fkapp_default_loc_oidR
person_checkout_center_signature.checkout_center_oid person_checkout_center_signature_checkout_center_oid_fkeyC
person_role_checkout_center.checkout_center_oid fkcapability_checkout_center_checkout_center_oidC
resource.checkout_center_oid resource_checkout_center_oid_fkeyC
resource_schedule.checkout_center_oid fkcresource_schedule_checkout_centerC
turndown.checkout_center_oid turndown_checkout_center_oid_fkeyN
type_allocation_usage_data.cc_oid type_allocation_usage_data_cc_oid_fkeyC
wco_application.default_checkout_center_oid fkapp_default_loc_oidR
wco_log.checkout_center_oid fkcwco_log_cc_oid
wco_station.checkout_center_oid fkcwco_station_checkout_center_oidC
name varchar 2147483647 null
description varchar 2147483647 √ null
org_oid int8 19 null
organization.obj_oid checkout_center_org_oid_fkeyC
default_delivery_type wcof_tag 2147483647 null
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
patron_portal_show_credits bool 1 √ false
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
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
fees_exclude_closed bool 1 √ false
fines_exclude_closed bool 1 √ false
usage_day_rollover time 15,6 '00:00:00'::time without time zone
billing_day_rollover time 15,6 √ 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
enable_rapid_return bool 1 √ true
allow_return_all bool 1 √ true
require_credit_to_circulate bool 1 √ false
auto_apply_credits bool 1 √ false
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 null
agreement_form_sorting wcof_tag 2147483647 null
agreement_form_grouping wcof_tag 2147483647 null
custom_agreement_form_oid int8 19 √ null
agreement_form_config.obj_oid checkout_center_custom_agreement_form_oid_fkeyR
email_template_set_oid int8 19 √ null
email_template_set.obj_oid checkout_center_email_template_set_oid_fkeyN

Indexes

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

Check Constraints

Constraint Name Constraint
check_agreement_form_grouping ((agreement_form_grouping = ANY (ARRAY['UNSERIALIZED'::wcof_tag, 'NONE'::wcof_tag])))
check_agreement_form_sorting ((agreement_form_sorting = ANY (ARRAY['ROOT-RESOURCE-TYPE'::wcof_tag, 'RESOURCE-TYPE'::wcof_tag, 'NAME'::wcof_tag])))
check_delivery_defaults ((default_delivery_type = ANY (ARRAY['NORMAL'::wcof_tag, 'FULL-DAY'::wcof_tag])))
check_form_date_time_format ((form_date_time_format = ANY (ARRAY['DAYTIME'::wcof_tag, 'ISO+TIME'::wcof_tag, 'DAYTIME+WEEKDAY'::wcof_tag])))

Relationships

Close relationships within degrees of separation