SchemaSpy Analysis of webco_5.0.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Thu Feb 14 09:10 CST 2019
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

webco_5.0.public contains 1291 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Children Parents Comments
person academic_career varchar 2147483647  √  null
person_ext academic_career varchar 2147483647  √  null
person academic_level varchar 2147483647  √  null
person_ext academic_level varchar 2147483647  √  null
pir_auth_ext academic_level varchar 2147483647  √  null
resource accessories _varchar 2147483647 ARRAY[]::character varying[]
resource_ext accessories varchar 2147483647  √  null
allocation account_code varchar 2147483647  √  null
wco_log action wcof_tag 2147483647  √  null
hold active bool 1  √  null
task_type active bool 1  √  null
tax_rate active bool 1 true
term active bool 1  √  null
checkout_center address varchar 2147483647  √  null
sched_staffed_location address varchar 2147483647  √  null
organization admin_id int8 19  √  null
person.obj_oid fkcorg_admin_id
task_type affiliated_allocation_task wcof_tag 2147483647  √  null
allocation_log agent int8 19  √  null
allocation agent_oid int8 19  √  1
person.obj_oid fkcalloc_agent_oid
inventory_note agent_oid int8 19  √  null
person.obj_oid inventory_note_agent_oid_fkey
ticket agent_oid int8 19  √  1
person.obj_oid fkticket_agent
ticket_log agent_oid int8 19  √  1
person.obj_oid fkcticket_log_agent_oid
turndown agent_oid int8 19  √  null
wco_log agent_oid int8 19  √  1
person.obj_oid fkcwco_log_agent_oid
resource aggregate_value odcl_money 2147483647  √  null
checkout_center agreement_form_grouping wcof_tag 2147483647
checkout_center agreement_form_sorting wcof_tag 2147483647
checkout_center allocation_mode wcof_tag 2147483647  √  null
allocation_accompanying_person allocation_oid int8 19
allocation.obj_oid allocation_accompanying_person_allocation_oid_fkey
allocation_group allocation_oid int8 19
allocation.obj_oid allocation_group_allocation_oid_fkey
allocation_item_building_pass allocation_oid int8 19
allocation.obj_oid allocation_item_building_pass_allocation_oid_fkey
allocation_log allocation_oid int8 19  √  null
allocation.obj_oid fkcalloc_log_alloc_oid
allocation_repeat_rule allocation_oid int8 19
allocation.obj_oid allocation_repeat_rule_allocation_oid_fkey
coalesced_deliver_to_v allocation_oid int8 19  √  null
invoice allocation_oid int8 19  √  null
allocation.obj_oid fkcinvoice_alloc_oid
resource_schedule allocation_oid int8 19  √  null
allocation.obj_oid fkcresource_schedule_alloc_oid
task allocation_oid int8 19  √  null
allocation.obj_oid task_allocation_oid_fkey
turndown allocation_oid int8 19  √  null
allocation.obj_oid turndown_allocation_oid_fkey
allocation allocation_state wcof_tag 2147483647  √  null
inventory allow_add_unexpected bool 1  √  false
inventory allow_manual varchar 2147483647
checkout_center allow_return_all bool 1  √  true
checkout_center allow_rrt_autoassignment bool 1  √  true
checkout_center allow_rrt_pickup bool 1  √  true
inventory allow_update_location bool 1  √  false
bibliographic_record alternative_title wcof_collated_string 2147483647  √  null
bibliographic_record_ext alternative_title varchar 2147483647  √  null
invoice_line amount odcl_money 2147483647  √  null
wco_application api_post_limit int4 10  √  134217728
ldap_profile application_dn varchar 2147483647  √  null
ldap_profile application_password varchar 2147483647  √  null
allocation approved bool 1  √  null
bibliographic_record archive_catalog_number varchar 2147483647  √  null
bibliographic_record_ext archive_catalog_number varchar 2147483647  √  null
bibliographic_record archive_date timestamptz 35,6  √  null
bibliographic_record_ext archive_date varchar 2147483647  √  null
resource asset_tag varchar 2147483647  √  null
resource_ext asset_tag varchar 2147483647  √  null
resource_ext assigned_department varchar 2147483647  √  null
resource assigned_department_oid int8 19  √  null
department.obj_oid fkcres_department
resource_ext assigned_person varchar 2147483647  √  null
resource assigned_person_oid int8 19  √  null
person.obj_oid fkcres_person
file_attachment attached_to_class cl_class 2147483647
file_attachment attached_to_oid int8 19
wco_application attachment_limit int4 10  √  104857600
calendar_authentication auth_type varchar 2147483647
bibliographic_record author wcof_collated_string_list 2147483647  √  null
bibliographic_record_ext author varchar 2147483647  √  null
resource_type_ext authorization_required varchar 2147483647  √  null
resource_type authorized bool 1  √  null
authset_delegation authset_oid int8 19  √  null
authset.obj_oid fkcauthset_delegation_authset_oid
authset_entry authset_oid int8 19  √  null
authset_ext authsets varchar 2147483647  √  null
allocation auto_circulate bool 1  √  null
inventory auto_close bool 1  √  false
entity_auto_email auto_email_oid int8 19  √  null
auto_email.obj_oid fkcheckout_center_auto_email_auto_email_oid
inventory auto_open bool 1  √  false
person avatar varchar 2147483647  √  null
invoice balance odcl_money 2147483647  √  null
invoice_charges balance numeric 131089  √  null
invoice_payments balance numeric 131089  √  null
person barcode varchar 2147483647  √  null
person_ext barcode varchar 2147483647  √  null
resource barcode varchar 2147483647  √  null
resource_ext barcode varchar 2147483647  √  null
ldap_profile base varchar 2147483647 ''::character varying
entity_auto_email bcc varchar 2147483647  √  null
scheduled_message_rule bcc varchar 2147483647  √  null
resource_ext biblio_id varchar 2147483647  √  null
holding bibliographic_record_oid int8 19
bibliographic_record.obj_oid fkholding_bibliographic_record
department_ext billing_contact varchar 2147483647  √  null
checkout_center billing_contact_email varchar 2147483647  √  null
checkout_center billing_contact_name varchar 2147483647  √  null
department billing_contact_oid int8 19  √  null
person.obj_oid fkcdepartment_billing_contact_oid
checkout_center billing_contact_phone varchar 2147483647  √  null
allocation billing_type wcof_tag 2147483647  √  null
resource budget_number varchar 2147483647  √  null
resource_ext budget_number varchar 2147483647  √  null
checkout_center building varchar 2147483647  √  null
sched_staffed_location building varchar 2147483647  √  null
wco_request_log bytes_used int8 19  √  null
holding call_number varchar 2147483647  √  null
resource_ext call_number varchar 2147483647  √  null
resource capacity int4 10  √  null
resource_ext capacity varchar 2147483647  √  null
resource_type caption varchar 2147483647  √  null
resource_type_ext caption varchar 2147483647  √  null
bibliographic_record captions wcof_tag 2147483647  √  null
bibliographic_record_ext captions varchar 2147483647  √  null
system_capability category varchar 2147483647  √  null
entity_auto_email cc varchar 2147483647  √  null
scheduled_message_rule cc varchar 2147483647  √  null
invoice cc_oid int8 19  √  null
checkout_center.obj_oid fkcinvoice_cc_oid
checkout_center cc_reporting_patron bool 1  √  null
checkout_center cc_set_strike bool 1  √  null
resource_type_certification certification_id varchar 2147483647  √  null
resource_type_certification_ext certification_id varchar 2147483647  √  null
allocation charge_duration interval 49,6  √  null
pir_auth_ext checkout_center varchar 2147483647  √  null
resource_ext checkout_center varchar 2147483647  √  null
agreement_form_config checkout_center_oid int8 19  √  null
checkout_center.obj_oid agreement_form_config_checkout_center_oid
allocation checkout_center_oid int8 19  √  null
checkout_center.obj_oid fkcalloc_checkout_center_oid
calendar_allocation_fields checkout_center_oid int8 19  √  null
checkout_center.obj_oid calendar_allocation_fields_checkout_center_oid_fkey
checkout_center_default_task_profile checkout_center_oid int8 19
checkout_center.obj_oid checkout_center_default_task_profile_checkout_center_oid_fkey
checkout_center_pir_pickup_option checkout_center_oid int8 19  √  null
checkout_center.obj_oid checkout_center_pir_pickup_option_checkout_center_oid_fkey
checkout_center_schedule checkout_center_oid int4 10  √  null
checkout_center.obj_oid fkccheckout_center_schedule_checkout_center
hold checkout_center_oid int8 19  √  null
checkout_center.obj_oid fkchold_cc_oid
inventory_selector checkout_center_oid int8 19  √  null
checkout_center.obj_oid inventory_selector_checkout_center_oid_fkey
migrated_resource checkout_center_oid int8 19  √  null
person_checkout_center_signature checkout_center_oid int8 19  √  null
checkout_center.obj_oid person_checkout_center_signature_checkout_center_oid_fkey
person_role_checkout_center checkout_center_oid int4 10
checkout_center.obj_oid fkcapability_checkout_center_checkout_center_oid
resource checkout_center_oid int8 19
checkout_center.obj_oid resource_checkout_center_oid_fkey
turndown checkout_center_oid int8 19  √  null
checkout_center.obj_oid turndown_checkout_center_oid_fkey
wco_log checkout_center_oid int8 19  √  null
checkout_center.obj_oid fkcwco_log_cc_oid
wco_request_log checkout_center_oid int8 19  √  null
wco_station checkout_center_oid int8 19  √  null
checkout_center.obj_oid fkcwco_station_checkout_center_oid
checkout_center_schedule_node checkout_center_schedule_oid int4 10
checkout_center_schedule.obj_oid fkcchekout_center_schedule_node_checkout_center_schedule
authset_ext checkout_centers varchar 2147483647  √  null
resource circulating bool 1  √  null
resource_ext circulating varchar 2147483647  √  null
checkout_center circulation_requires_authorization bool 1  √  false
inventory_selector circulation_status varchar 2147483647  √  null
department city varchar 2147483647  √  null
department_ext city varchar 2147483647  √  null
organization city varchar 2147483647  √  null
person city varchar 2147483647  √  null
person_ext city varchar 2147483647  √  null
integration_log class varchar 2147483647  √  null
invoice class wcof_tag 2147483647  √  null
wco_log class varchar 2147483647  √  null
session_client_info client_info json 2147483647
person client_name varchar 2147483647  √  null
inventory close_date timestamptz 35,6  √  null
ticket close_date timestamptz 35,6  √  null
account_code code varchar 2147483647
account_code_ext code varchar 2147483647  √  null
department_code code varchar 2147483647
bibliographic_record color varchar 2147483647  √  null
bibliographic_record_ext color varchar 2147483647  √  null
tax_rate compound bool 1 false
resource condition_note varchar 2147483647  √  null
resource_ext condition_note varchar 2147483647  √  null
agreement_form_config config json 2147483647 '{"version":"1.0","general":{"pageSize":"letter","units":"in","margin":".5"},"title":{"text":"WebCheckout Agreement","align":"right","logo":"","logoAlign":"left"},"header":{"patron":{"name":true,"ID":false,"telephone":true,"email":true,"address":false,"address2":false,"cityStateZip":false,"contactPerson":true,"barcode":false,"department":false},"operator":"operator ID","eventTitle":false,"renewal":false},"contents":{"active":[{"key":"item","header":"Item","width":"1.5","specifier":"id"},{"key":"desc","header":"Description","width":"2.5","rType":true,"topLevelRType":false,"homeLocation":true,"accessories":false,"components":true,"mediaTitle":false},{"key":"qty","header":"Qty","width":".875"},{"key":"return","header":"Return Time","width":".875"},{"key":"fee","header":"Est''d fee","width":".875"},{"key":"feeSubtotal","header":"Est''d subtotal","width":".875"}],"inactive":[{"key":"aggValue","header":"Aggregate Value","width":".5"},{"key":"condition","header":"Condition Note","width":".5"}]},"footer":{"notes":true,"setup":false,"feeTotal":false},"signatory":{"accompany":false}}'::json
find_config config json 2147483647
organization constrain_account_codes bool 1  √  null
subscription_contact contact_data varchar 2147483647
allocation contact_name_string varchar 2147483647  √  null
group_ext contact_note varchar 2147483647  √  null
person contact_note varchar 2147483647  √  null
section contact_note varchar 2147483647  √  null
section_ext contact_note varchar 2147483647  √  null
wco_group contact_note varchar 2147483647  √  null
section contact_oid int8 19  √  null
wco_group contact_oid int8 19  √  null
person.obj_oid fkcwco_group_contact_oid
allocation contact_person int8 19  √  null
person.obj_oid fkcalloc_contact_person
allocation contact_phone_string varchar 2147483647  √  null
subscription_contact contact_type wcof_tag 2147483647
group_ext contact_unique_identifier varchar 2147483647  √  null
section_ext contact_unique_identifier varchar 2147483647  √  null
resource_ext container_unique_identifier varchar 2147483647  √  null
resource containing_resource_oid int8 19  √  null
resource.obj_oid fkres_cont_res
bibliographic_record contributor wcof_collated_string_list 2147483647  √  null
bibliographic_record_ext contributor varchar 2147483647  √  null
allocation copy_of int8 19  √  null
allocation.obj_oid allocation_copy_of_fkey
bibliographic_record country varchar 2147483647  √  null
bibliographic_record_ext country varchar 2147483647  √  null
department country varchar 2147483647  √  null
department_ext country varchar 2147483647  √  null
organization country varchar 2147483647  √  null
person country varchar 2147483647  √  null
person_ext country varchar 2147483647  √  null
bibliographic_record course varchar 2147483647  √  null
bibliographic_record_ext course varchar 2147483647  √  null
hold created timestamptz 35,6  √  null
integration_log created int8 19  √  null
wco_group created timestamptz 35,6  √  null
invoice created_by int8 19  √  1
person.obj_oid fkcinvoice_created_by
invoice_line created_by int8 19  √  1
person.obj_oid fkinv_line_created_by
authset created_date timestamptz 35,6  √  null
authset_entry created_date timestamptz 35,6  √  null
section created_date timestamptz 35,6  √  null
section_member created_date timestamptz 35,6  √  null
resource creating_operator_oid int8 19  √  null
invoice creation_date timestamptz 35,6  √  null
invoice_line creation_date timestamptz 35,6  √  null
resource creation_date timestamptz 35,6  √  null
allocation creation_note varchar 2147483647  √  null
allocation creation_time timestamptz 35,6  √  null
allocation credit_card_type varchar 2147483647  √  null
invoice credit_card_type varchar 2147483647  √  null
account_code_ext csv_line_number int4 10  √  null
authset_ext csv_line_number int4 10  √  null
bibliographic_record_ext csv_line_number int4 10  √  null
department_ext csv_line_number int4 10  √  null
group_ext csv_line_number int4 10  √  null
person_ext csv_line_number int4 10  √  null
pir_auth_ext csv_line_number int4 10  √  null
resource_ext csv_line_number int4 10  √  null
resource_type_certification_ext csv_line_number int4 10  √  null
resource_type_ext csv_line_number int4 10  √  null
section_ext csv_line_number int4 10  √  null
section_member_ext csv_line_number int4 10  √  null
resource current_schedule_oid int8 19  √  null
checkout_center custom_agreement_form_oid int8 19  √  null
agreement_form_config.obj_oid checkout_center_custom_agreement_form_oid_fkey
custom_property_booleans custom_property_oid int8 19
custom_property.obj_oid custom_property_booleans_custom_property_oid_fkey
custom_property_integers custom_property_oid int8 19
custom_property.obj_oid custom_property_integers_custom_property_oid_fkey
custom_property_money custom_property_oid int8 19
custom_property.obj_oid custom_property_money_custom_property_oid_fkey
custom_property_strings custom_property_oid int8 19
custom_property.obj_oid custom_property_strings_custom_property_oid_fkey
custom_property_timestamps custom_property_oid int8 19
custom_property.obj_oid custom_property_timestamps_custom_property_oid_fkey
inventory_item date timestamptz 35,6  √  null
inventory_note date timestamptz 35,6  √  null
person_checkout_center_signature date timestamptz 35,6  √  null
ticket_log date timestamptz 35,6  √  null
turndown date timestamptz 35,6  √  null
invoice date_paid timestamptz 35,6  √  null
ticket date_returned timestamptz 35,6  √  null
ticket date_sent_out timestamptz 35,6  √  null
checkout_center_schedule_node day_number int4 10
checkout_center day_rollover int4 10
checkout_center_schedule_node days_from_sunday int4 10  √  null
checkout_center default_allocation_times wcof_default_allocation_times 2147483647  √  null
organization default_allocation_times wcof_default_allocation_times 2147483647  √  null
organization default_billing_type wcof_tag 2147483647  √  null
wco_application default_checkout_center_oid int8 19 1
checkout_center.obj_oid fkapp_default_loc_oid
checkout_center default_delivery_type wcof_tag 2147483647
wco_application default_hide_empty_properties bool 1 true
task_type default_notes varchar 2147483647  √  null
wco_application default_org_oid int8 19 1
organization.obj_oid fkapp_default_org_oid
task_type default_relative_task_time wcof_relative_task_time 2147483647  √  null
task_type default_required_assignments int4 10  √  null
checkout_center default_resource_selector wcof_tag 2147483647  √  null
scheduled_message_rule delay interval 49,6  √  null
authset_ext delegated_orgs varchar 2147483647  √  null
custom_property delete_at_startup bool 1  √  false
account_code deleted bool 1  √  false
account_code_ext deleted varchar 2147483647  √  null
department deleted bool 1  √  null
department_ext deleted varchar 2147483647  √  null
integration_log deleted int8 19  √  null
resource deleted bool 1 false
resource_type deleted bool 1  √  null
sched_shift deleted bool 1  √  null
sched_staff_assignment deleted bool 1  √  null
calendar_allocation_fields deliver_to bool 1  √  null
coalesced_deliver_to_v deliver_to varchar 2147483647  √  null
allocation deliver_to_oid int8 19  √  null
resource.obj_oid fkcalloc_deliver_to_oid
allocation deliver_to_string varchar 2147483647  √  null
calendar_allocation_fields delivery_people bool 1  √  null
allocation delivery_type wcof_tag 2147483647  √  null
person department varchar 2147483647  √  null
person_ext department varchar 2147483647  √  null
pir_auth_ext department varchar 2147483647  √  null
account_code_ext department_name varchar 2147483647  √  null
account_code department_oid int8 19  √  null
department.obj_oid fkcdepartment_oid
department_code department_oid int8 19  √  null
department.obj_oid fkcdepartment_code_department_oid
agreement_form_config description varchar 2147483647  √  null
authset description varchar 2147483647  √  null
authset_ext description varchar 2147483647  √  null
auto_email description varchar 2147483647  √  null
bibliographic_record description varchar 2147483647  √  null
bibliographic_record_ext description varchar 2147483647  √  null
checkout_center description varchar 2147483647  √  null
email_template description varchar 2147483647  √  null
email_template_set description varchar 2147483647  √  null
file_attachment description varchar 2147483647  √  null
group_ext description varchar 2147483647  √  null
hold description varchar 2147483647  √  null
inventory description varchar 2147483647  √  null
invoice description varchar 2147483647  √  null
invoice_line description varchar 2147483647  √  null
ldap_profile description varchar 2147483647  √  null
message_type description varchar 2147483647 ''::character varying
resource description varchar 2147483647  √  null
resource_ext description varchar 2147483647  √  null
resource_type description varchar 2147483647  √  null
resource_type_certification description varchar 2147483647  √  null
resource_type_certification_ext description varchar 2147483647  √  null
resource_type_ext description varchar 2147483647  √  null
sched_scheduling_group description varchar 2147483647  √  null
sched_staffed_location description varchar 2147483647  √  null
scheduled_message_type description varchar 2147483647  √  null
section description varchar 2147483647  √  null
section_ext description varchar 2147483647  √  null
system_role description varchar 2147483647  √  null
task_profile description varchar 2147483647  √  null
term description varchar 2147483647  √  null
ticket_log description varchar 2147483647  √  null
wco_group description varchar 2147483647  √  null
resource_type description_url varchar 2147483647  √  null
resource_type_ext description_url varchar 2147483647  √  null
resource destination bool 1  √  null
resource_ext destination varchar 2147483647  √  null
bibliographic_record digital_catalog_number varchar 2147483647  √  null
bibliographic_record_ext digital_catalog_number varchar 2147483647  √  null
bibliographic_record digitized bool 1  √  null
bibliographic_record_ext digitized varchar 2147483647  √  null
bibliographic_record director wcof_collated_string 2147483647  √  null
bibliographic_record_ext director varchar 2147483647  √  null
holding distributor varchar 2147483647  √  null
resource_ext distributor varchar 2147483647  √  null
ldap_profile dn_attribute varchar 2147483647  √  null
ldap_profile dn_prefix varchar 2147483647  √  null
ldap_profile dn_suffix varchar 2147483647  √  null
ldap_profile dsa_host varchar 2147483647 '127.0.0.1'::character varying
ldap_profile dsa_port int4 10 636
invoice due_date timestamptz 35,6  √  null
organization due_days interval 49,6  √  null
wco_request_log edit_allocation_oid int8 19  √  null
bibliographic_record edition varchar 2147483647  √  null
bibliographic_record_ext edition varchar 2147483647  √  null
resource_type_certification effective_date timestamptz 35,6
resource_type_certification_ext effective_date varchar 2147483647  √  null
allocation effective_end_time timestamptz 35,6  √  null
wco_request_log effective_operator_oid int8 19  √  null
department email varchar 2147483647  √  null
department_ext email varchar 2147483647  √  null
group_ext email varchar 2147483647  √  null
person email varchar 2147483647  √  null
person_ext email varchar 2147483647  √  null
section email varchar 2147483647  √  null
section_ext email varchar 2147483647  √  null
wco_group email varchar 2147483647  √  null
person email_local varchar 2147483647  √  null
email_template_set_template email_template_oid int8 19
email_template.obj_oid email_template_set_template_email_template_oid_fkey
checkout_center email_template_set_oid int8 19  √  null
email_template_set.obj_oid checkout_center_email_template_set_oid_fkey
email_template_set_template email_template_set_oid int8 19
email_template_set.obj_oid email_template_set_template_email_template_set_oid_fkey
organization email_template_set_oid int8 19  √  null
email_template_set.obj_oid organization_email_template_set_oid_fkey
wco_application enable_ldap bool 1 false
wco_application enable_sso bool 1 false
entity_auto_email enabled bool 1  √  null
scheduled_message_rule enabled bool 1  √  true
authset end_date timestamptz 35,6  √  null
authset_ext end_date varchar 2147483647  √  null
group_ext end_date varchar 2147483647  √  null
inventory end_date timestamptz 35,6  √  null
section end_date timestamptz 35,6  √  null
section_ext end_date varchar 2147483647  √  null
section_member end_date timestamptz 35,6  √  null
section_member_ext end_date varchar 2147483647  √  null
wco_group end_date timestamptz 35,6  √  null
wco_request_log end_locked_allocations _int8 19  √  null
allocation end_time timestamptz 35,6  √  null
allocation_repeat_rule end_time timestamptz 35,6  √  null
integration_log end_time timestamptz 35,6  √  null
resource_schedule end_time timestamptz 35,6  √  null
sched_shift end_time timestamptz 35,6  √  null
sched_staff_availability end_time timestamptz 35,6  √  null
wco_task_log end_time timestamptz 35,6  √  null
checkout_center_schedule_node end_time_minutes int4 10  √  null
auto_email entity_class cl_class 2147483647  √  null
custom_property entity_class cl_class 2147483647
entity_auto_email entity_class cl_class 2147483647
message_type entity_class cl_class 2147483647  √  null
scheduled_message_history entity_class cl_class 2147483647  √  null
scheduled_message_rule entity_class cl_class 2147483647
scheduled_message_type entity_class cl_class 2147483647  √  null
find_config entity_default bool 1  √  null
custom_property_booleans entity_oid int8 19
custom_property_integers entity_oid int8 19
custom_property_money entity_oid int8 19
custom_property_strings entity_oid int8 19
custom_property_timestamps entity_oid int8 19
entity_auto_email entity_oid int8 19
scheduled_message_history entity_oid int8 19  √  null
scheduled_message_rule entity_oid int8 19
subscription entity_oid int8 19  √  null
scheduled_message_type entity_property wcof_tag 2147483647  √  null
scheduled_message_type entity_state wcof_tag 2147483647  √  null
scheduled_message_type entity_timeslot wcof_tag 2147483647  √  null
email_serialization entity_type cl_class 2147483647
find_config entity_type cl_class 2147483647
subscription entity_type varchar 2147483647  √  null
task_profile entity_type cl_class 2147483647
authset_entry entry_class cl_class 2147483647  √  null
authset_entry entry_oid int8 19  √  null
custom_property equal_term varchar 2147483647  √  null
bibliographic_record era varchar 2147483647 'AD'::character varying
bibliographic_record_ext era varchar 2147483647  √  null
scheduled_message_type era wcof_tag 2147483647  √  null
wco_application error_timeout int4 10  √  5
ticket est_close_date timestamptz 35,6  √  null
allocation event_description varchar 2147483647  √  null
calendar_allocation_fields event_description bool 1  √  null
invoice event_description varchar 2147483647  √  null
resource_schedule event_group uuid 2147483647
resource_type_certification expiration_date timestamptz 35,6  √  null
resource_type_certification_ext expiration_date varchar 2147483647  √  null
allocation expire_time timestamptz 35,6  √  null
authentication expires timestamptz 35,6  √  null
hold expires timestamptz 35,6  √  null
person expires timestamptz 35,6  √  null
person_ext expires varchar 2147483647  √  null
allocation_item_building_pass explicit bool 1  √  null
person external_id varchar 2147483647  √  null
person_ext external_id varchar 2147483647  √  null
ldap_rule fail_to_db bool 1 false
migrations failure_message varchar 2147483647  √  null
resource_type_fallback fallback_oid int8 19
resource_type.obj_oid resource_type_fallback_fallback_oid_fkey
department fax varchar 2147483647  √  null
department_ext fax varchar 2147483647  √  null
person fax varchar 2147483647  √  null
person_ext fax varchar 2147483647  √  null
resource_ext file_id varchar 2147483647  √  null
file_attachment file_name varchar 2147483647
file_attachment file_size int8 19
import_session files _varchar 2147483647 ARRAY[]::character varying[]
organization fine_account varchar 2147483647  √  null
person first_name varchar 2147483647  √  null
person_ext first_name varchar 2147483647  √  null
resource first_schedule_oid int8 19  √  null
task fixed_time timestamptz 35,6  √  null
checkout_center force_barcode_scanning bool 1  √  null
checkout_center form_date_time_format wcof_tag 2147483647
bibliographic_record format varchar 2147483647  √  null
bibliographic_record_ext format varchar 2147483647  √  null
resource_container_tcm gen int8 19  √  null
resource_location_tcm gen int8 19  √  null
rtype_tree_tcm gen int8 19  √  null
bibliographic_record genre varchar 2147483647  √  null
bibliographic_record_ext genre varchar 2147483647  √  null
wco_request_log get_parameters _varchar 2147483647  √  null
allocation_item_building_pass granted bool 1  √  null
custom_property greater_equal_term varchar 2147483647  √  null
authset group_oid int8 19  √  null
section group_oid int8 19  √  null
authset_ext group_unique_identifier varchar 2147483647  √  null
pir_auth_ext group_unique_identifier varchar 2147483647  √  null
section_ext group_unique_identifier varchar 2147483647  √  null
find_config guid varchar 2147483647  √  null
resource hardware_version varchar 2147483647  √  null
resource_ext hardware_version varchar 2147483647  √  null
authentication hash varchar 2147483647  √  null
authset_path head_oid int8 19
authset.obj_oid fkauthset_path_head_oid
bundle_path head_oid int8 19
custom_property hidden bool 1  √  false
invoice hold_date timestamptz 35,6  √  null
organization hold_days interval 49,6  √  null
hold hold_type varchar 2147483647  √  null
inventory_selector home_location_oid int8 19  √  null
resource.obj_oid inventory_selector_home_location_oid_fkey
resource_ext home_location_string varchar 2147483647  √  null
inventory_selector homeless bool 1  √  null
checkout_center honor_external_fines _int4 10 ARRAY[]::integer[]
organization honor_external_fines _int4 10 ARRAY[]::integer[]
checkout_center honor_external_holds _int4 10 ARRAY[]::integer[]
organization honor_external_holds _int4 10 ARRAY[]::integer[]
checkout_center honor_external_lates _int4 10 ARRAY[]::integer[]
organization honor_external_lates _int4 10 ARRAY[]::integer[]
resource hostname varchar 2147483647  √  null
resource_ext hostname varchar 2147483647  √  null
allocation id varchar 2147483647  √  null
calendar_allocation_fields id bool 1  √  null
bibliographic_record identifier varchar 2147483647
bibliographic_record_ext identifier varchar 2147483647  √  null
resource_type image_url varchar 2147483647  √  null
resource_type_ext image_url varchar 2147483647  √  null
wco_request_log imho_element varchar 2147483647  √  null
email_serialization immutable bool 1  √  null
find_config immutable bool 1  √  null
wco_application import_person_by_barcode bool 1 false
inventory_selector include_contained bool 1 false
inventory include_instructions bool 1  √  false
inventory include_maint_notes bool 1  √  false
wco_log instance int8 19  √  null
inventory instructions varchar 2147483647  √  null
scheduled_message_rule interval interval 49,6  √  null
inventory_item inventoried_assigned_department_oid int8 19  √  null
department.obj_oid inventory_item_inventoried_assigned_department_oid_fkey
inventory_item inventoried_assigned_person_oid int8 19  √  null
person.obj_oid inventory_item_inventoried_assigned_person_oid_fkey
inventory_item inventoried_home_location_oid int8 19  √  null
resource.obj_oid inventory_item_inventoried_home_location_oid_fkey
resource_ext inventory_date varchar 2147483647  √  null
inventory_item inventory_oid int8 19
inventory.obj_oid inventory_item_inventory_oid_fkey
inventory_note inventory_oid int8 19
inventory.obj_oid inventory_note_inventory_oid_fkey
inventory_selector inventory_oid int8 19
inventory.obj_oid inventory_selector_inventory_oid_fkey
inventory inventory_on_checkout bool 1  √  false
inventory inventory_on_return bool 1  √  false
invoice invoice_id varchar 2147483647  √  null
invoice_line_tax_rate invoice_line_oid int8 19  √  null
invoice_line.obj_oid invoice_line_tax_rate_invoice_line_oid_fkey
hold invoice_oid int8 19  √  null
invoice.obj_oid fkchold_invoice_oid
invoice_charges invoice_oid int8 19  √  null
invoice_line invoice_oid int8 19  √  null
invoice.obj_oid invoice_line_invoice_oid_fkey
invoice_payments invoice_oid int8 19  √  null
invoice_tax_rate invoice_oid int8 19  √  null
invoice.obj_oid invoice_tax_rate_invoice_oid_fkey
invoices_pending_export invoice_oid int8 19  √  null
invoice.obj_oid invoices_pending_export_invoice_oid_fkey
invoice invoice_status wcof_tag 2147483647  √  null
wco_log ip_addr int8 19  √  null
resource ip_address varchar 2147483647  √  null
resource_ext ip_address varchar 2147483647  √  null
task_type is_allocation_task bool 1  √  null
email_template is_default bool 1 false
bibliographic_record isbn wcof_isbn_number 2147483647  √  null
bibliographic_record_ext isbn varchar 2147483647  √  null
patron_class key varchar 2147483647
string_map key varchar 2147483647
system_capability key wcof_tag 2147483647
wco_features key varchar 2147483647
inventory_selector kit_components bool 1  √  null
custom_property label varchar 2147483647
resource label_id varchar 2147483647
resource_ext label_id varchar 2147483647  √  null
bibliographic_record language varchar 2147483647  √  null
bibliographic_record_ext language varchar 2147483647  √  null
resource last_inventoried_date timestamptz 35,6  √  null
person last_name varchar 2147483647  √  null
person_ext last_name varchar 2147483647  √  null
allocation last_renewal timestamptz 35,6  √  null
scheduled_message_history last_updated timestamptz 35,6  √  null
late_returns late_returns int8 19  √  null
person late_returns int8 19  √  null
inventory_selector latest_inventory_date timestamptz 35,6  √  null
ldap_rule ldap_profile_oid int8 19  √  null
ldap_profile.obj_oid ldap_rule_ldap_profile_oid_fkey
custom_property less_equal_term varchar 2147483647  √  null
wco_application licence varchar 2147483647  √  null
resource_type link_text varchar 2147483647  √  null
resource_type_ext link_text varchar 2147483647  √  null
bibliographic_record loc_control_number varchar 2147483647  √  null
bibliographic_record_ext loc_control_number varchar 2147483647  √  null
checkout_center locale varchar 2147483647  √  null
organization locale varchar 2147483647  √  null
wco_application locale varchar 2147483647  √  null
resource location_note varchar 2147483647  √  null
resource_ext location_note varchar 2147483647  √  null
ticket location_note varchar 2147483647  √  null
ticket location_oid int8 19  √  null
resource.obj_oid fkticket_location
resource location_resource_oid int8 19  √  null
resource.obj_oid fkcres_loc_res
wco_request_log locked_allocations _int8 19  √  null
wco_log log_text varchar 2147483647  √  null
allocation_log login_agent int8 19  √  null
wco_request_log login_operator_oid int8 19  √  null
ldap_profile lookup_dn bool 1 true
resource mac_address varchar 2147483647  √  null
resource_ext mac_address varchar 2147483647  √  null
sched_staff manager bool 1  √  null
resource manufacturer varchar 2147483647  √  null
resource_ext manufacturer varchar 2147483647  √  null
agreement_form_config markup varchar 2147483647 'The undersigned acknowledges receiving the listed equipment in good condition and accepts full liability for damage or loss including concealed or unreported damage discovered after return.'::character varying
resource max_quantity int4 10  √  null
section_member member_oid int8 19  √  null
person.obj_oid fkc_section_member_member_oid
section_member_ext member_unique_identifier varchar 2147483647  √  null
subscription_notification message varchar 2147483647  √  null
scheduled_message_type message_format wcof_tag 2147483647  √  null
auto_email message_type_oid int8 19  √  null
message_type.obj_oid fkauto_email_message_type_oid
email_template message_type_oid int8 19
message_type.obj_oid email_template_message_type_oid_fkey
email_template_set_template message_type_oid int8 19
message_type.obj_oid email_template_set_template_message_type_oid_fkey
scheduled_message_type message_type_oid int8 19  √  null
message_type.obj_oid fkscheduled_message_type_message_type_oid
checkout_center messaging_from_address varchar 2147483647  √  null
organization messaging_from_address varchar 2147483647  √  null
inventory_selector metaclass wcof_tag 2147483647  √  null
resource metaclass wcof_tag 2147483647
resource_ext metaclass varchar 2147483647  √  null
inventory_selector minimum_value odcl_money 2147483647  √  null
resource model varchar 2147483647  √  null
resource_ext model varchar 2147483647  √  null
invoice modified timestamptz 35,6  √  null
invoice_line modified timestamptz 35,6  √  null
person modified timestamptz 35,6  √  null
resource modified timestamptz 35,6  √  null
resource_type modified timestamptz 35,6  √  null
wco_group modified timestamptz 35,6  √  null
invoice modified_by int8 19  √  null
person.obj_oid fkcinvoice_modified_by
invoice_line modified_by int8 19  √  1
person.obj_oid fkinv_line_modified_by
authset modified_date timestamptz 35,6  √  null
section modified_date timestamptz 35,6  √  null
message_type module varchar 2147483647  √  null
bibliographic_record more_info varchar 2147483647  √  null
bibliographic_record_ext more_info varchar 2147483647  √  null
scheduled_message_history most_recent timestamptz 35,6  √  null
wco_application motd_text varchar 2147483647  √  null
wco_application multiple_ip bool 1  √  null
agreement_form_config name varchar 2147483647 'Agreement Form'::character varying
authset name varchar 2147483647  √  null
authset_ext name varchar 2147483647  √  null
checkout_center name varchar 2147483647
department name varchar 2147483647
department_ext name varchar 2147483647  √  null
email_serialization name varchar 2147483647  √  null
email_template name varchar 2147483647  √  null
email_template_set name varchar 2147483647  √  null
find_config name varchar 2147483647  √  null
group_ext name varchar 2147483647  √  null
inventory name varchar 2147483647  √  null
ldap_profile name varchar 2147483647
ldap_rule name varchar 2147483647
migrations name varchar 2147483647
organization name varchar 2147483647  √  null
organization_credit_card_type name varchar 2147483647  √  null
patron_class name varchar 2147483647
resource_type name varchar 2147483647  √  null
resource_type_ext name varchar 2147483647  √  null
sched_scheduling_group name varchar 2147483647
sched_shift name varchar 2147483647  √  null
sched_staff_availability name varchar 2147483647  √  null
sched_staffed_location name varchar 2147483647
scheduled_message_type name varchar 2147483647  √  null
section name varchar 2147483647  √  null
section_ext name varchar 2147483647  √  null
system_role name varchar 2147483647
task_profile name varchar 2147483647  √  null
task_type name varchar 2147483647  √  null
tax_rate name varchar 256
term name varchar 2147483647  √  null
ticket name varchar 2147483647
ticket_problem_type name varchar 2147483647  √  null
ticket_remedy_type name varchar 2147483647  √  null
wco_group name varchar 2147483647  √  null
wco_station name varchar 2147483647  √  null
migrated_resource new_org_oid int8 19  √  null
migrated_resource new_resource_type_oid int8 19  √  null
resource next_schedule_oid int8 19  √  null
allocation nonexpiring bool 1  √  null
account_code note varchar 2147483647  √  null
account_code_ext note varchar 2147483647  √  null
allocation note varchar 2147483647  √  null
authset note varchar 2147483647  √  null
calendar_allocation_fields note bool 1  √  null
department_code note varchar 2147483647  √  null
group_ext note varchar 2147483647  √  null
person note varchar 2147483647  √  null
person_ext note varchar 2147483647  √  null
section note varchar 2147483647  √  null
section_ext note varchar 2147483647  √  null
wco_group note varchar 2147483647  √  null
sched_shift notes varchar 2147483647  √  null
task notes varchar 2147483647  √  null
wco_application notice_timeout int4 10  √  2
account_code obj_oid int8 19
account_code_ext obj_oid int8 19
agreement_form_config obj_oid int8 19
checkout_center.custom_agreement_form_oid checkout_center_custom_agreement_form_oid_fkey
allocation obj_oid int8 19
allocation.copy_of allocation_copy_of_fkey
allocation_accompanying_person.allocation_oid allocation_accompanying_person_allocation_oid_fkey
allocation_group.allocation_oid allocation_group_allocation_oid_fkey
allocation_group.source_allocation_oid fkcalloc_group_src_alloc_oid
allocation_item_building_pass.allocation_oid allocation_item_building_pass_allocation_oid_fkey
allocation_log.allocation_oid fkcalloc_log_alloc_oid
allocation_repeat_rule.allocation_oid allocation_repeat_rule_allocation_oid_fkey
invoice.allocation_oid fkcinvoice_alloc_oid
resource_schedule.allocation_oid fkcresource_schedule_alloc_oid
task.allocation_oid task_allocation_oid_fkey
turndown.allocation_oid turndown_allocation_oid_fkey
allocation_accompanying_person obj_oid int8 19
allocation_group obj_oid int8 19
allocation_item_building_pass obj_oid int8 19
allocation_log obj_oid int8 19
allocation_repeat_rule obj_oid int8 19
allocation_group.rule_oid fkcalloc_group_rule_oid
authentication obj_oid int8 19
person.obj_oid fkcauthentication_obj_oid
authset obj_oid int8 19
authset_delegation.authset_oid fkcauthset_delegation_authset_oid
authset_path.head_oid fkauthset_path_head_oid
authset_path.tail_oid fkauthset_path_tail_oid
authset_delegation obj_oid int8 19
authset_entry obj_oid int8 19
authset_ext obj_oid serial 10  √  nextval('authset_ext_obj_oid_seq'::regclass)
authset_path obj_oid int8 19
auto_email obj_oid int8 19
entity_auto_email.auto_email_oid fkcheckout_center_auto_email_auto_email_oid
bibliographic_record obj_oid int8 19
holding.bibliographic_record_oid fkholding_bibliographic_record
bibliographic_record_ext obj_oid int8 19
bundle_path obj_oid int8 19
calendar_allocation_fields obj_oid int8 19
calendar_authentication obj_oid int8 19
checkout_center 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
checkout_center_default_task_profile obj_oid int8 19
checkout_center_pir_pickup_option obj_oid int8 19
checkout_center_schedule obj_oid int4 10
checkout_center_schedule.parent_oid fkccheckout_center_schedule_parent
checkout_center_schedule_node.checkout_center_schedule_oid fkcchekout_center_schedule_node_checkout_center_schedule
checkout_center_schedule_node obj_oid int4 10
circulation_policy obj_oid int8 19
custom_property obj_oid int8 19
custom_property_booleans.custom_property_oid custom_property_booleans_custom_property_oid_fkey
custom_property_integers.custom_property_oid custom_property_integers_custom_property_oid_fkey
custom_property_money.custom_property_oid custom_property_money_custom_property_oid_fkey
custom_property_strings.custom_property_oid custom_property_strings_custom_property_oid_fkey
custom_property_timestamps.custom_property_oid custom_property_timestamps_custom_property_oid_fkey
department obj_oid int8 19
account_code.department_oid fkcdepartment_oid
allocation.paying_department_oid fkcalloc_paying_department_oid
department_code.department_oid fkcdepartment_code_department_oid
inventory_item.inventoried_assigned_department_oid inventory_item_inventoried_assigned_department_oid_fkey
invoice.paying_dept_oid fkcinvoice_paying_dept_oid
resource.assigned_department_oid fkcres_department
department_code obj_oid int8 19
department_ext obj_oid int8 19
email_serialization obj_oid int8 19
email_template obj_oid int8 19
email_template_set_template.email_template_oid email_template_set_template_email_template_oid_fkey
email_template_set obj_oid int8 19
checkout_center.email_template_set_oid checkout_center_email_template_set_oid_fkey
email_template_set_template.email_template_set_oid email_template_set_template_email_template_set_oid_fkey
organization.email_template_set_oid organization_email_template_set_oid_fkey
email_template_set_template obj_oid int8 19
entity_auto_email obj_oid int8 19
file_attachment obj_oid int8 19
find_config obj_oid int8 19
group_ext obj_oid serial 10  √  nextval('group_ext_obj_oid_seq'::regclass)
hold obj_oid int8 19
holding obj_oid int8 19
import_session obj_oid int8 19
integration_log obj_oid int8 19
inventory obj_oid int8 19
inventory_item.inventory_oid inventory_item_inventory_oid_fkey
inventory_note.inventory_oid inventory_note_inventory_oid_fkey
inventory_selector.inventory_oid inventory_selector_inventory_oid_fkey
inventory_item obj_oid int8 19
inventory_note obj_oid int8 19
inventory_note.parent_note_oid inventory_note_parent_note_oid_fkey
inventory_selector obj_oid int8 19
invoice obj_oid int8 19
hold.invoice_oid fkchold_invoice_oid
invoice_line.invoice_oid invoice_line_invoice_oid_fkey
invoice_tax_rate.invoice_oid invoice_tax_rate_invoice_oid_fkey
invoices_pending_export.invoice_oid invoices_pending_export_invoice_oid_fkey
invoice_line obj_oid int8 19
invoice_line_tax_rate.invoice_line_oid invoice_line_tax_rate_invoice_line_oid_fkey
invoice_line_tax_rate obj_oid int8 19
invoice_tax_rate obj_oid int8 19
invoices_pending_export obj_oid int8 19
ldap_profile obj_oid int8 19
ldap_rule.ldap_profile_oid ldap_rule_ldap_profile_oid_fkey
ldap_rule obj_oid int8 19
message_type obj_oid int8 19
auto_email.message_type_oid fkauto_email_message_type_oid
email_template.message_type_oid email_template_message_type_oid_fkey
email_template_set_template.message_type_oid email_template_set_template_message_type_oid_fkey
scheduled_message_type.message_type_oid fkscheduled_message_type_message_type_oid
migrated_resource obj_oid int8 19
organization obj_oid int8 19
authset_delegation.org_oid fkcauthset_delegation_org_oid
checkout_center.org_oid checkout_center_org_oid_fkey
email_template.organization_oid email_template_organization_oid_fkey
email_template_set.organization_oid email_template_set_organization_oid_fkey
hold.organization_oid fkchold_organization_oid
inventory.organization_oid inventory_organization_oid_fkey
invoice.org_oid fkcinvoice_org_oid
person_role.organization_oid fkcapability_organization_oid
resource_type.org_oid fkcresource_type_org_oid
sched_staffed_location.org_oid sched_staffed_location_org_oid_fkey
task.organization_oid task_organization_oid_fkey
task_profile.organization_oid task_profile_organization_oid_fkey
task_type.organization_oid task_type_organization_oid_fkey
tax_rate.organization_oid fk_taxrates_organization_oid
wco_application.default_org_oid fkapp_default_org_oid
wco_group.organization_oid fkcwco_group_organization_oid
wco_log.org_oid fkcwco_log_org_oid
organization_credit_card_type obj_oid int8 19
patron_class obj_oid int8 19
allocation.patron_class_oid fkcpatron_class_oid
circulation_policy.patron_class_oid fkpatron_class_oid
ldap_rule.patron_class_oid ldap_rule_patron_class_oid_fkey
person.patron_class_oid fkcpatron_class_oid
person obj_oid int8 19
allocation.agent_oid fkcalloc_agent_oid
allocation.contact_person fkcalloc_contact_person
allocation.original_agent_oid fkallocation_original_agent_oid
allocation.patron_oid fkcalloc_patron_oid
allocation.payee_oid fkcalloc_payee_oid
allocation_accompanying_person.person_oid allocation_accompanying_person_person_oid_fkey
authentication.obj_oid fkcauthentication_obj_oid
department.billing_contact_oid fkcdepartment_billing_contact_oid
file_attachment.upload_person_oid fkfile_attachment_upload_person_oid
hold.person_oid fkchold_person_oid
inventory_item.inventoried_assigned_person_oid inventory_item_inventoried_assigned_person_oid_fkey
inventory_item.scanning_agent_oid inventory_item_scanning_agent_oid_fkey
inventory_note.agent_oid inventory_note_agent_oid_fkey
invoice.created_by fkcinvoice_created_by
invoice.modified_by fkcinvoice_modified_by
invoice.person_oid fkcinvoice_person_oid
invoice.real_payee fkcinvoice_real_payee
invoice_line.created_by fkinv_line_created_by
invoice_line.modified_by fkinv_line_modified_by
organization.admin_id fkcorg_admin_id
person_checkout_center_signature.person_oid person_checkout_center_signature_person_oid_fkey
person_role.person_oid fkcapability_person_oid
resource.assigned_person_oid fkcres_person
resource_schedule.return_agent_oid fkcresource_schedule_return_agent_oid
resource_type_certification.person_oid resource_type_certification_person_oid_fkey
sched_staff.person_oid sched_staff_person_oid_fkey
sched_staff_availability.person_oid sched_staff_availability_person_oid_fkey
section_member.member_oid fkc_section_member_member_oid
subscription.person_oid fksubscription_person_oid
task_person.person_oid task_person_person_oid_fkey
ticket.agent_oid fkticket_agent
ticket.patron_oid fkticket_patron
ticket.responsible_op_oid fkticket_responsible_op
ticket.vendor_oid fkticket_vendor
ticket_log.agent_oid fkcticket_log_agent_oid
turndown.patron_oid turndown_patron_oid_fkey
wco_group.contact_oid fkcwco_group_contact_oid
wco_log.agent_oid fkcwco_log_agent_oid
wco_log.responsible_agent_oid fkcwco_log_reps_agent_oid
person_checkout_center_signature obj_oid int8 19
person_ext obj_oid int8 19
person_role obj_oid int4 10
person_role_capability.person_role_oid fkcapability_authorization_capability_oid
person_role_checkout_center.person_role_oid fkcapability_checkout_center_capability_oid
person_role_capability obj_oid int4 10
person_role_checkout_center obj_oid int4 10
pir_auth_ext obj_oid int8 19
resource obj_oid int8 19
allocation.deliver_to_oid fkcalloc_deliver_to_oid
holding.resource_oid fkholding_resource
inventory_item.inventoried_home_location_oid inventory_item_inventoried_home_location_oid_fkey
inventory_item.resource_oid inventory_item_resource_oid_fkey
inventory_note.resource_oid inventory_note_resource_oid_fkey
inventory_selector.home_location_oid inventory_selector_home_location_oid_fkey
inventory_selector.resource_oid inventory_selector_resource_oid_fkey
invoice_line.resource_oid fkinv_line_res
resource.containing_resource_oid fkres_cont_res
resource.location_resource_oid fkcres_loc_res
resource_schedule.proposed_resource_oid fkcresource_schedule_proposed_resource_oid
resource_schedule.scheduled_resource_oid fkcresource_schedule_scheduled_resource_oid
ticket.location_oid fkticket_location
ticket.resource_oid fkticket_res
resource_ext obj_oid int8 19
resource_schedule obj_oid int8 19
resource_type obj_oid int8 19
inventory_selector.resource_type_oid inventory_selector_resource_type_oid_fkey
resource.rtype_oid resource_rtype_oid_fkey
resource_type_certification.resource_type_oid resource_type_certification_resource_type_oid_fkey
resource_type_fallback.fallback_oid resource_type_fallback_fallback_oid_fkey
resource_type_fallback.type_oid resource_type_fallback_type_oid_fkey
resource_type_certification obj_oid int8 19
resource_type_certification_ext obj_oid int8 19
resource_type_ext obj_oid int8 19
resource_type_fallback obj_oid int8 19
rrt_bundle obj_oid int8 19
sched_scheduling_group obj_oid int8 19
sched_scheduling_group_member.scheduling_group_oid sched_scheduling_group_member_scheduling_group_oid_fkey
sched_staff_assignment.scheduling_group_oid staff_assignment_sched_group_oid
sched_staff_assignment.unpublished_scheduling_group_oid staff_assignment_unppublished_sched_group_oid
sched_scheduling_group_member obj_oid int8 19
sched_shift obj_oid int8 19
sched_staff_assignment.shift_oid staff_assignment_shift_oid
sched_staff obj_oid int8 19
sched_scheduling_group_member.staff_oid sched_scheduling_group_member_staff_oid_fkey
sched_staff_assignment.staff_oid staff_assignment_staff_oid
sched_staff_assignment.unpublished_staff_oid staff_assignment_unpub_staff_oid
sched_staffing_limit.staff_oid sched_staffing_limit_staff_oid_fkey
sched_staff_assignment obj_oid int8 19
sched_staff_availability obj_oid int8 19
sched_staffed_location obj_oid int8 19
sched_scheduling_group.staffed_location_oid sched_scheduling_group_staffed_location_oid_fkey
sched_shift.staffed_location_oid sched_shift_staffed_location_oid_fkey
sched_staff.staffed_location_oid sched_staff_staffed_location_oid_fkey
sched_staffing_limit obj_oid int8 19
scheduled_message_history obj_oid int8 19
scheduled_message_rule obj_oid int8 19
scheduled_message_type obj_oid int8 19
section obj_oid int8 19
section_member.section_oid fkc_section_member_section_oid
section_ext obj_oid serial 10  √  nextval('section_ext_obj_oid_seq'::regclass)
section_member obj_oid int8 19
section_member_ext obj_oid serial 10  √  nextval('section_member_ext_obj_oid_seq'::regclass)
session_client_info obj_oid int8 19
subscription obj_oid int8 19
subscription_contact.subscription_oid fksubscription_notification_subscription
subscription_notification.subscription_oid fksubscription_notification_subscription
subscription_contact obj_oid int8 19
subscription_notification obj_oid int8 19
system_capability obj_oid serial 10  √  nextval('hibernate_sequence'::regclass)
person_role_capability.system_capability_oid fkcapability_authorization_authorization_oid
system_role_capability.system_capability_oid system_role_cap_auth
system_role obj_oid serial 10  √  nextval('hibernate_sequence'::regclass)
person_role.system_role_oid fkcapability_role_oid
system_role_capability.system_role_oid system_role_cap_role
system_role_capability obj_oid int8 19
task obj_oid int8 19
task_person.task_oid task_person_task_oid_fkey
task_person obj_oid int8 19
task_profile obj_oid int8 19
checkout_center_default_task_profile.task_profile_oid checkout_center_default_task_profile_task_profile_oid_fkey
task_profile_task_type.task_profile_oid task_profile_task_type_task_profile_oid_fkey
task_profile_task_type obj_oid int8 19
task_type obj_oid int8 19
task.task_type_oid task_task_type_oid_fkey
task_profile_task_type.task_type_oid task_profile_task_type_task_type_oid_fkey
tax_rate obj_oid int8 19
invoice_line_tax_rate.tax_rate_oid invoice_line_tax_rate_tax_rate_oid_fkey
invoice_tax_rate.tax_rate_oid invoice_tax_rate_tax_rate_oid_fkey
term obj_oid int8 19
ticket obj_oid int8 19
ticket_log.ticket_oid fkcticket_log_ticket_oid
ticket_log obj_oid int8 19
ticket_problem_type obj_oid int8 19
ticket_remedy_type obj_oid int8 19
turndown obj_oid int8 19
wco_application obj_oid int8 19
wco_group obj_oid int8 19
wco_log obj_oid int8 19
wco_request_log obj_oid int8 19
wco_station obj_oid int8 19
wco_task_log obj_oid int8 19
migrated_resource old_org_oid int8 19  √  null
migrated_resource old_resource_type_oid int8 19  √  null
inventory_selector online_status varchar 2147483647  √  null
inventory open_date timestamptz 35,6  √  null
ticket open_date timestamptz 35,6  √  null
ldap_rule operator bool 1 false
wco_application operator_logout_url varchar 2147483647  √  null
authset org_oid int8 19  √  null
authset_delegation org_oid int8 19  √  null
organization.obj_oid fkcauthset_delegation_org_oid
checkout_center org_oid int8 19
organization.obj_oid checkout_center_org_oid_fkey
invoice org_oid int8 19  √  null
organization.obj_oid fkcinvoice_org_oid
resource_type org_oid int8 19  √  null
organization.obj_oid fkcresource_type_org_oid
sched_staffed_location org_oid int8 19
organization.obj_oid sched_staffed_location_org_oid_fkey
wco_log org_oid int8 19  √  null
organization.obj_oid fkcwco_log_org_oid
authset_ext organization varchar 2147483647  √  null
group_ext organization varchar 2147483647  √  null
resource_type_ext organization varchar 2147483647  √  null
email_template organization_oid int8 19  √  null
organization.obj_oid email_template_organization_oid_fkey
email_template_set organization_oid int8 19
organization.obj_oid email_template_set_organization_oid_fkey
hold organization_oid int8 19  √  null
organization.obj_oid fkchold_organization_oid
inventory organization_oid int8 19  √  null
organization.obj_oid inventory_organization_oid_fkey
person organization_oid int8 19  √  null
person_role organization_oid int4 10
organization.obj_oid fkcapability_organization_oid
task organization_oid int8 19
organization.obj_oid task_organization_oid_fkey
task_profile organization_oid int8 19  √  null
organization.obj_oid task_profile_organization_oid_fkey
task_type organization_oid int8 19  √  null
organization.obj_oid task_type_organization_oid_fkey
tax_rate organization_oid int8 19  √  null
organization.obj_oid fk_taxrates_organization_oid
turndown organization_oid int8 19  √  null
wco_group organization_oid int8 19
organization.obj_oid fkcwco_group_organization_oid
account_code origin varchar 2147483647
account_code_ext origin varchar 2147483647
authset origin varchar 2147483647
authset_ext origin varchar 2147483647
bibliographic_record origin varchar 2147483647
bibliographic_record_ext origin varchar 2147483647
department origin varchar 2147483647
department_ext origin varchar 2147483647
group_ext origin varchar 2147483647
import_session origin varchar 2147483647  √  null
ldap_rule origin varchar 2147483647  √  null
person origin varchar 2147483647
person_ext origin varchar 2147483647
pir_auth_ext origin varchar 2147483647
resource origin varchar 2147483647
resource_ext origin varchar 2147483647
resource_type origin varchar 2147483647
resource_type_certification origin varchar 2147483647
resource_type_certification_ext origin varchar 2147483647  √  null
resource_type_ext origin varchar 2147483647
section origin varchar 2147483647  √  null
section_ext origin varchar 2147483647
section_member origin varchar 2147483647  √  null
section_member_ext origin varchar 2147483647
wco_group origin varchar 2147483647
wco_request_log origin varchar 2147483647  √  null
allocation original_agent_oid int8 19  √  null
person.obj_oid fkallocation_original_agent_oid
person other_name varchar 2147483647  √  null
person_ext other_name varchar 2147483647  √  null
entity_auto_email override_to varchar 2147483647  √  null
scheduled_message_rule override_to varchar 2147483647  √  null
resource_type_ext parent varchar 2147483647  √  null
inventory_note parent_note_oid int8 19  √  null
inventory_note.obj_oid inventory_note_parent_note_oid_fkey
checkout_center_schedule parent_oid int4 10  √  null
checkout_center_schedule.obj_oid fkccheckout_center_schedule_parent
resource_type parent_oid int8 19  √  null
resource_parent parent_resource_oid int8 19  √  null
person_ext password varchar 2147483647  √  null
authentication password_version int4 10
authset_path path varchar 2147483647
bundle_path path varchar 2147483647  √  null
resource_type path varchar 2147483647  √  null
checkout_center patron_access_requires_authorization bool 1  √  true
person_ext patron_class varchar 2147483647  √  null
pir_auth_ext patron_class varchar 2147483647  √  null
allocation patron_class_oid int8 19  √  null
patron_class.obj_oid fkcpatron_class_oid
circulation_policy patron_class_oid int8 19
patron_class.obj_oid fkpatron_class_oid
ldap_rule patron_class_oid int8 19  √  null
patron_class.obj_oid ldap_rule_patron_class_oid_fkey
person patron_class_oid int8 19
patron_class.obj_oid fkcpatron_class_oid
wco_application patron_logout_url varchar 2147483647  √  null
calendar_allocation_fields patron_name bool 1  √  null
allocation patron_oid int8 19  √  null
person.obj_oid fkcalloc_patron_oid
late_returns patron_oid int8 19  √  null
ticket patron_oid int8 19  √  null
person.obj_oid fkticket_patron
turndown patron_oid int8 19  √  null
person.obj_oid turndown_patron_oid_fkey
checkout_center patron_portal_email_notification bool 1  √  null
checkout_center patron_portal_help_link varchar 2147483647  √  null
checkout_center patron_portal_notification_email_address varchar 2147483647  √  null
checkout_center patron_portal_show_groups bool 1  √  true
pir_auth_ext patron_unique_identifier varchar 2147483647  √  null
allocation payee_oid int8 19  √  null
person.obj_oid fkcalloc_payee_oid
invoice paying_account varchar 2147483647  √  null
allocation paying_department_oid int8 19  √  null
department.obj_oid fkcalloc_paying_department_oid
invoice paying_dept_oid int8 19  √  null
department.obj_oid fkcinvoice_paying_dept_oid
invoice payment_rule wcof_tag 2147483647  √  null
allocation payment_type wcof_tag 2147483647  √  null
bibliographic_record performers wcof_collated_string_list 2147483647  √  null
bibliographic_record_ext performers varchar 2147483647  √  null
resource_type_certification_ext person varchar 2147483647  √  null
allocation_accompanying_person person_oid int8 19  √  null
person.obj_oid allocation_accompanying_person_person_oid_fkey
calendar_authentication person_oid int4 10
hold person_oid int8 19  √  null
person.obj_oid fkchold_person_oid
invoice person_oid int8 19  √  null
person.obj_oid fkcinvoice_person_oid
person_checkout_center_signature person_oid int8 19  √  null
person.obj_oid person_checkout_center_signature_person_oid_fkey
person_role person_oid int4 10
person.obj_oid fkcapability_person_oid
resource_type_certification person_oid int8 19  √  null
person.obj_oid resource_type_certification_person_oid_fkey
sched_staff person_oid int8 19
person.obj_oid sched_staff_person_oid_fkey
sched_staff_availability person_oid int8 19
person.obj_oid sched_staff_availability_person_oid_fkey
subscription person_oid int8 19
person.obj_oid fksubscription_person_oid
task_person person_oid int8 19
person.obj_oid task_person_person_oid_fkey
person_role_capability person_role_oid int4 10
person_role.obj_oid fkcapability_authorization_capability_oid
person_role_checkout_center person_role_oid int4 10
person_role.obj_oid fkcapability_checkout_center_capability_oid
person person_type varchar 2147483647  √  null
allocation pickup_instructions varchar 2147483647  √  null
calendar_allocation_fields pickup_instructions bool 1  √  null
checkout_center_pir_pickup_option pickup_option wcof_tag 2147483647  √  null
calendar_allocation_fields pickup_people bool 1  √  null
authentication pin_hash varchar 2147483647  √  null
authentication pin_version int4 10
checkout_center pir_media_cc_query bool 1  √  null
checkout_center pir_mode wcof_tag 2147483647  √  null
checkout_center pir_motd varchar 2147483647  √  null
wco_application pir_motd varchar 2147483647  √  null
resource_type pir_p bool 1  √  true
resource_type_ext pir_p varchar 2147483647  √  null
checkout_center pir_report_problems bool 1  √  true
checkout_center pir_requires_approval bool 1  √  null
checkout_center pir_requires_event_title wcof_tag 2147483647  √  null
checkout_center pir_restrict_delivery_locations bool 1  √  null
checkout_center pir_session_timeout int4 10 15
allocation po_number varchar 2147483647  √  null
invoice po_number varchar 2147483647  √  null
circulation_policy policy_class wcof_tag 2147483647  √  null
circulation_policy policy_object_class varchar 2147483647  √  null
circulation_policy policy_object_oid int8 19  √  null
circulation_policy policy_value varchar 2147483647  √  null
wco_request_log post_parameters _varchar 2147483647  √  null
department postal_code varchar 2147483647  √  null
department_ext postal_code varchar 2147483647  √  null
organization postal_code varchar 2147483647  √  null
person postal_code varchar 2147483647  √  null
person_ext postal_code varchar 2147483647  √  null
resource previous_schedule_oid int8 19  √  null
checkout_center print_queue varchar 2147483647  √  'wco_local'::character varying
wco_station print_queue varchar 2147483647  √  null
checkout_center print_template_set varchar 2147483647  √  null
ldap_rule priority int4 10
ticket priority int8 19  √  null
ticket problem_type varchar 2147483647  √  null
bibliographic_record producer wcof_collated_string 2147483647  √  null
bibliographic_record_ext producer varchar 2147483647  √  null
bibliographic_record program_type varchar 2147483647  √  null
bibliographic_record_ext program_type varchar 2147483647  √  null
allocation project_code varchar 2147483647  √  null
invoice project_code varchar 2147483647  √  null
custom_property property_name varchar 2147483647
custom_property property_type wcof_property_type 2147483647
resource_schedule proposed_resource_oid int8 19  √  null
resource.obj_oid fkcresource_schedule_proposed_resource_oid
wco_application ps_accepted_terms varchar 2147483647  √  null
bibliographic_record publication_year int8 19  √  null
bibliographic_record_ext publication_year varchar 2147483647  √  null
sched_shift published bool 1  √  null
sched_staff_assignment published bool 1  √  null
bibliographic_record publisher varchar 2147483647  √  null
bibliographic_record_ext publisher varchar 2147483647  √  null
resource purchase_date timestamptz 35,6  √  null
resource_ext purchase_date varchar 2147483647  √  null
resource purchase_note varchar 2147483647  √  null
resource purchase_order varchar 2147483647  √  null
resource_ext purchase_order varchar 2147483647  √  null
ticket purchase_order varchar 2147483647  √  null
invoice_line quantity int8 19  √  null
wco_request_log query_path varchar 2147483647  √  null
patron_class rank int4 10
system_role rank int4 10
tax_rate rate numeric 131089
invoice ready_to_bill bool 1  √  null
allocation real_end_time timestamptz 35,6  √  null
resource_schedule real_end_time timestamptz 35,6  √  null
invoice real_payee int8 19  √  null
person.obj_oid fkcinvoice_real_payee
allocation real_start_time timestamptz 35,6  √  null
resource_schedule real_start_time timestamptz 35,6  √  null
allocation reference_id varchar 2147483647  √  null
invoice reference_id varchar 2147483647  √  null
task relative_time wcof_relative_task_time 2147483647  √  null
ticket remedy_type varchar 2147483647  √  null
allocation renewal_count int8 19  √  null
ticket repair_cost odcl_money 2147483647  √  null
ticket repair_cost_labor odcl_money 2147483647  √  null
ticket repair_cost_note varchar 2147483647  √  null
ticket repair_cost_parts odcl_money 2147483647  √  null
ticket repair_price odcl_money 2147483647  √  null
ticket repair_warranty_labor varchar 2147483647  √  null
ticket repair_warranty_parts varchar 2147483647  √  null
scheduled_message_rule repeat bool 1  √  false
checkout_center repeats_in_pir bool 1  √  null
resource replacement_date timestamptz 35,6  √  null
resource_ext replacement_date varchar 2147483647  √  null
checkout_center reply_to_address varchar 2147483647  √  null
organization reply_to_address varchar 2147483647  √  null
resource_schedule requested_rtype_oid int8 19
inventory require_location bool 1  √  false
checkout_center require_scan_to_return bool 1  √  false
checkout_center require_signature_on_file bool 1  √  false
task required_assignments int4 10  √  null
resource_type requires_certification bool 1 false
resource_type_ext requires_certification varchar 2147483647  √  null
ticket resolution wcof_tag 2147483647  √  null
holding resource_oid int8 19
resource.obj_oid fkholding_resource
inventory_item resource_oid int8 19
resource.obj_oid inventory_item_resource_oid_fkey
inventory_note resource_oid int8 19  √  null
resource.obj_oid inventory_note_resource_oid_fkey
inventory_selector resource_oid int8 19  √  null
resource.obj_oid inventory_selector_resource_oid_fkey
invoice_line resource_oid int8 19  √  null
resource.obj_oid fkinv_line_res
migrated_resource resource_oid int8 19  √  null
resource_parent resource_oid int8 19  √  null
ticket resource_oid int8 19  √  null
resource.obj_oid fkticket_res
inventory_selector resource_type_oid int8 19  √  null
resource_type.obj_oid inventory_selector_resource_type_oid_fkey
resource_type_certification resource_type_oid int8 19  √  null
resource_type.obj_oid resource_type_certification_resource_type_oid_fkey
resource_ext resource_type_unique_identifier varchar 2147483647  √  null
resource_type_certification_ext resource_type_unique_identifier varchar 2147483647  √  null
authset_ext resource_types varchar 2147483647  √  null
calendar_allocation_fields resource_types bool 1  √  null
calendar_allocation_fields resources bool 1  √  null
wco_request_log response_time_stamp timestamptz 35,6  √  null
wco_log responsible_agent_oid int8 19  √  1
person.obj_oid fkcwco_log_reps_agent_oid
ticket responsible_op_oid int8 19  √  1
person.obj_oid fkticket_responsible_op
organization restricted bool 1  √  null
holding restrictions varchar 2147483647  √  null
resource_ext restrictions varchar 2147483647  √  null
import_session result int8 19  √  null
custom_property result_column bool 1  √  null
resource_schedule return_agent_oid int8 19  √  1
person.obj_oid fkcresource_schedule_return_agent_oid
resource_type_certification revocation_date timestamptz 35,6  √  null
resource_type_certification_ext revocation_date varchar 2147483647  √  null
resource_type_certification revocation_note varchar 2147483647  √  null
resource_type_certification_ext revocation_note varchar 2147483647  √  null
group_ext role varchar 2147483647  √  null
section role varchar 2147483647  √  null
section_ext role varchar 2147483647  √  null
wco_group role varchar 2147483647  √  null
resource roles _varchar 2147483647 ARRAY[]::character varying[]
checkout_center room varchar 2147483647  √  null
sched_staffed_location room varchar 2147483647  √  null
resource room_number varchar 2147483647  √  null
resource_ext room_number varchar 2147483647  √  null
resource rtype_oid int8 19
resource_type.obj_oid resource_rtype_oid_fkey
rrt_bundle rtype_oid int8 19
turndown rtype_oid int8 19  √  null
allocation_group rule_oid int8 19  √  null
allocation_repeat_rule.obj_oid fkcalloc_group_rule_oid
scheduled_message_history rule_oid int8 19  √  null
migrations run_date timestamptz 35,6  √  null
bibliographic_record run_time int8 19  √  null
bibliographic_record_ext run_time varchar 2147483647  √  null
wco_task_log run_time interval 49,6  √  null
authentication salt varchar 2147483647  √  null
message_type sample_data json 2147483647 'null'::json
inventory_item scan_type varchar 2147483647  √  null
inventory_item scan_value varchar 2147483647  √  null
inventory_item scanning_agent_oid int8 19  √  null
person.obj_oid inventory_item_scanning_agent_oid_fkey
checkout_center_schedule schedule_end timestamptz 35,6  √  null
checkout_center_schedule schedule_length int4 10  √  null
checkout_center_schedule schedule_name varchar 2147483647  √  null
checkout_center_schedule schedule_start timestamptz 35,6  √  null
checkout_center_schedule schedule_type wcof_tag 2147483647
resource_schedule scheduled_by wcof_tag 2147483647
scheduled_message_rule scheduled_message_type_oid int8 19  √  null
resource_schedule scheduled_resource_oid int8 19  √  null
resource.obj_oid fkcresource_schedule_scheduled_resource_oid
sched_scheduling_group_member scheduling_group_oid int8 19
sched_scheduling_group.obj_oid sched_scheduling_group_member_scheduling_group_oid_fkey
sched_staff_assignment scheduling_group_oid int8 19  √  null
sched_scheduling_group.obj_oid staff_assignment_sched_group_oid
authset_entry scope wcof_tag 2147483647  √  null
find_config scope_object_class cl_class 2147483647  √  null
find_config scope_object_oid int8 19  √  null
ldap_profile search_attribute varchar 2147483647  √  null
section_member section_oid int8 19  √  null
section.obj_oid fkc_section_member_section_oid
section_member_ext section_unique_identifier varchar 2147483647  √  null
organization semester_end timestamptz 35,6  √  null
organization semester_start timestamptz 35,6  √  null
allocation_group seq_no int8 19  √  null
resource serial_number varchar 2147483647  √  null
resource_ext serial_number varchar 2147483647  √  null
bibliographic_record series_title wcof_collated_string 2147483647  √  null
bibliographic_record_ext series_title varchar 2147483647  √  null
bibliographic_record series_volume_number varchar 2147483647  √  null
bibliographic_record_ext series_volume_number varchar 2147483647  √  null
session_client_info sessionid varchar 2147483647  √  null
wco_request_log sessionid varchar 2147483647  √  null
checkout_center set_location_in_patron_portal wcof_tag 2147483647 'ALLOW'::wcof_tag
calendar_allocation_fields setup_for_will_call_people bool 1  √  null
ticket severity wcof_tag 2147483647  √  null
resource shelf_location varchar 2147483647  √  null
resource_ext shelf_location varchar 2147483647  √  null
sched_staff_assignment shift_oid int8 19  √  null
sched_shift.obj_oid staff_assignment_shift_oid
calendar_allocation_fields show_people bool 1  √  null
checkout_center show_resource_timelines bool 1 true
resource software_version varchar 2147483647  √  null
resource_ext software_version varchar 2147483647  √  null
custom_property sort_order int4 10  √  null
person sortable_name varchar 2147483647  √  null
auto_email sorted_position int8 19  √  null
scheduled_message_type sorted_position int8 19  √  null
bibliographic_record sound varchar 2147483647  √  null
bibliographic_record_ext sound varchar 2147483647  √  null
bibliographic_record source varchar 2147483647  √  null
bibliographic_record_ext source varchar 2147483647  √  null
allocation_group source_allocation_oid int8 19  √  null
allocation.obj_oid fkcalloc_group_src_alloc_oid
scheduled_message_rule span interval 49,6  √  null
wco_application sso_header varchar 2147483647  √  'REMOTE_USER'::character varying
wco_application staff_logout_url varchar 2147483647  √  null
sched_scheduling_group_member staff_oid int8 19
sched_staff.obj_oid sched_scheduling_group_member_staff_oid_fkey
sched_staff_assignment staff_oid int8 19  √  null
sched_staff.obj_oid staff_assignment_staff_oid
sched_staffing_limit staff_oid int8 19
sched_staff.obj_oid sched_staffing_limit_staff_oid_fkey
sched_scheduling_group staffed_location_oid int8 19
sched_staffed_location.obj_oid sched_scheduling_group_staffed_location_oid_fkey
sched_shift staffed_location_oid int8 19
sched_staffed_location.obj_oid sched_shift_staffed_location_oid_fkey
sched_staff staffed_location_oid int8 19
sched_staffed_location.obj_oid sched_staff_staffed_location_oid_fkey
authset start_date timestamptz 35,6  √  null
authset_ext start_date varchar 2147483647  √  null
group_ext start_date varchar 2147483647  √  null
inventory start_date timestamptz 35,6  √  null
section start_date timestamptz 35,6  √  null
section_ext start_date varchar 2147483647  √  null
section_member start_date timestamptz 35,6  √  null
section_member_ext start_date varchar 2147483647  √  null
wco_group start_date timestamptz 35,6  √  null
allocation start_time timestamptz 35,6  √  null
allocation_repeat_rule start_time timestamptz 35,6  √  null
import_session start_time timestamptz 35,6  √  null
integration_log start_time timestamptz 35,6  √  null
resource_schedule start_time timestamptz 35,6  √  null
sched_shift start_time timestamptz 35,6  √  null
sched_staff_availability start_time timestamptz 35,6  √  null
wco_task_log start_time timestamptz 35,6  √  null
checkout_center_schedule_node start_time_minutes int4 10  √  null
department state varchar 2147483647  √  null
department_ext state varchar 2147483647  √  null
organization state varchar 2147483647  √  null
person state varchar 2147483647  √  null
person_ext state varchar 2147483647  √  null
ticket state wcof_tag 2147483647  √  null
wco_request_log station varchar 2147483647  √  null
authset status wcof_tag 2147483647
authset_ext status varchar 2147483647  √  null
checkout_center_schedule_node status wcof_tag 2147483647
group_ext status varchar 2147483647  √  null
integration_log status varchar 2147483647  √  null
inventory_note status varchar 2147483647  √  null
person status wcof_tag 2147483647  √  null
person_ext status varchar 2147483647  √  null
resource_type_certification status wcof_tag 2147483647 'PENDING'::wcof_tag
section status wcof_tag 2147483647
section_ext status varchar 2147483647  √  null
section_member status wcof_tag 2147483647
section_member_ext status varchar 2147483647  √  null
wco_group status wcof_tag 2147483647
wco_request_log status int4 10  √  null
import_session step wcof_tag 2147483647  √  null
department street varchar 2147483647  √  null
department_ext street varchar 2147483647  √  null
organization street varchar 2147483647  √  null
person street varchar 2147483647  √  null
person_ext street varchar 2147483647  √  null
department street2 varchar 2147483647  √  null
department_ext street2 varchar 2147483647  √  null
organization street2 varchar 2147483647  √  null
person street2 varchar 2147483647  √  null
person_ext street2 varchar 2147483647  √  null
invoice_line struck bool 1  √  null
resource_container_tcm sub int8 19  √  null
resource_location_tcm sub int8 19  √  null
rtype_tree_tcm sub int8 19  √  null
inventory_selector sub_locations bool 1  √  null
rrt_bundle sub_rtype_oid int8 19
inventory_selector sub_types bool 1  √  null
bibliographic_record subject _varchar 2147483647 ARRAY[]::character varying[]
bibliographic_record_ext subject varchar 2147483647  √  null
subscription_contact subscription_oid int8 19
subscription.obj_oid fksubscription_notification_subscription
subscription_notification subscription_oid int8 19
subscription.obj_oid fksubscription_notification_subscription
custom_property substring_term varchar 2147483647  √  null
invoice_line subtype wcof_tag 2147483647  √  null
migrations success bool 1 false
ticket summary varchar 2147483647  √  null
resource_container_tcm super int8 19  √  null
resource_location_tcm super int8 19  √  null
rtype_tree_tcm super int8 19  √  null
bibliographic_record supporting_documentation bool 1  √  null
bibliographic_record_ext supporting_documentation varchar 2147483647  √  null
organization suppress_autopayment bool 1  √  null
person suppress_email bool 1  √  null
checkout_center suppress_set_strike_email_to_patron bool 1  √  true
bibliographic_record system wcof_tag 2147483647  √  null
bibliographic_record_ext system varchar 2147483647  √  null
person_role_capability system_capability_oid int4 10
system_capability.obj_oid fkcapability_authorization_authorization_oid
system_role_capability system_capability_oid int8 19
system_capability.obj_oid system_role_cap_auth
person_role system_role_oid int4 10
system_role.obj_oid fkcapability_role_oid
system_role_capability system_role_oid int8 19
system_role.obj_oid system_role_cap_role
authset_path tail_oid int8 19
authset.obj_oid fkauthset_path_tail_oid
bundle_path tail_oid int8 19  √  null
wco_task_log task_object varchar 2147483647  √  null
task_person task_oid int8 19
task.obj_oid task_person_task_oid_fkey
checkout_center_default_task_profile task_profile_oid int8 19
task_profile.obj_oid checkout_center_default_task_profile_task_profile_oid_fkey
task_profile_task_type task_profile_oid int8 19
task_profile.obj_oid task_profile_task_type_task_profile_oid_fkey
task task_time timestamptz 35,6  √  null
task task_type_oid int8 19
task_type.obj_oid task_task_type_oid_fkey
task_profile_task_type task_type_oid int8 19
task_type.obj_oid task_profile_task_type_task_type_oid_fkey
invoice_line tax odcl_money 2147483647  √  null
invoice_line_tax_rate tax_amount odcl_money 2147483647  √  null
department tax_exempt_number varchar 2147483647  √  null
department_ext tax_exempt_number varchar 2147483647  √  null
invoice_line_tax_rate tax_rate_oid int8 19  √  null
tax_rate.obj_oid invoice_line_tax_rate_tax_rate_oid_fkey
invoice_tax_rate tax_rate_oid int8 19  √  null
tax_rate.obj_oid invoice_tax_rate_tax_rate_oid_fkey
account_code taxable bool 1  √  null
account_code_ext taxable varchar 2147483647  √  null
invoice taxable bool 1  √  null
organization taxable_invoices wcof_tag 2147483647  √  null
checkout_center telephone varchar 2147483647  √  null
department telephone varchar 2147483647  √  null
department_ext telephone varchar 2147483647  √  null
group_ext telephone varchar 2147483647  √  null
person telephone varchar 2147483647  √  null
person_ext telephone varchar 2147483647  √  null
sched_staffed_location telephone varchar 2147483647  √  null
section telephone varchar 2147483647  √  null
section_ext telephone varchar 2147483647  √  null
wco_group telephone varchar 2147483647  √  null
person telephone_local varchar 2147483647  √  null
email_serialization template json 2147483647
email_template template varchar 2147483647
message_type template varchar 2147483647  √  null
allocation_log text varchar 2147483647  √  null
inventory_note text varchar 2147483647  √  null
ldap_profile text_encoding varchar 2147483647 'utf-8'::character varying
ticket_log ticket_oid int8 19  √  null
ticket.obj_oid fkcticket_log_ticket_oid
ticket ticket_type wcof_tag 2147483647  √  null
allocation_log time timestamptz 35,6  √  null
subscription_notification time timestamptz 35,6  √  null
sched_staffing_limit time_limit int8 19  √  null
session_client_info time_stamp timestamptz 35,6  √  null
wco_log time_stamp timestamptz 35,6  √  null
wco_request_log time_stamp timestamptz 35,6  √  null
wco_request_log time_used float8 17,17  √  null
checkout_center timeline_granularity int8 19  √  null
checkout_center timeline_zoom_factor int8 19  √  null
ldap_profile timeout int4 10 5
checkout_center timezone varchar 2147483647  √  null
organization timezone varchar 2147483647  √  null
wco_application timezone varchar 2147483647  √  null
bibliographic_record title wcof_collated_string 2147483647  √  null
bibliographic_record_ext title varchar 2147483647  √  null
person title varchar 2147483647  √  null
person_ext title varchar 2147483647  √  null
resource_type_certification title varchar 2147483647  √  null
resource_type_certification_ext title varchar 2147483647  √  null
calendar_authentication token varchar 2147483647  √  null
auto_email topic wcof_tag 2147483647  √  null
message_type topic wcof_tag 2147483647  √  null
allocation_log type wcof_tag 2147483647  √  null
allocation_repeat_rule type wcof_tag 2147483647  √  null
coalesced_deliver_to_v type text 2147483647  √  null
inventory_note type varchar 2147483647  √  null
invoice_line type wcof_tag 2147483647  √  null
resource_schedule type wcof_tag 2147483647
sched_staffing_limit type varchar 2147483647  √  null
ticket_log type wcof_tag 2147483647  √  null
invoice type_of_payment wcof_tag 2147483647  √  null
resource_type_fallback type_oid int8 19
resource_type.obj_oid resource_type_fallback_type_oid_fkey
wco_request_log ui_allocation_next_state wcof_tag 2147483647  √  null
wco_request_log ui_current_allocation_oid int8 19  √  null
authset unique_identifier varchar 2147483647  √  null
authset_ext unique_identifier varchar 2147483647  √  null
group_ext unique_identifier varchar 2147483647  √  null
resource unique_identifier varchar 2147483647  √  null
resource_type unique_identifier varchar 2147483647
resource_type_ext unique_identifier varchar 2147483647  √  null
section unique_identifier varchar 2147483647  √  null
section_ext unique_identifier varchar 2147483647  √  null
wco_group unique_identifier varchar 2147483647
sched_shift unpublished_edits bool 1  √  null
sched_staff_assignment unpublished_edits bool 1  √  null
sched_shift unpublished_end_time timestamptz 35,6  √  null
sched_shift unpublished_name varchar 2147483647  √  null
sched_shift unpublished_notes varchar 2147483647  √  null
sched_staff_assignment unpublished_scheduling_group_oid int8 19  √  null
sched_scheduling_group.obj_oid staff_assignment_unppublished_sched_group_oid
sched_staff_assignment unpublished_staff_oid int8 19  √  null
sched_staff.obj_oid staff_assignment_unpub_staff_oid
sched_shift unpublished_start_time timestamptz 35,6  √  null
resource unserialized bool 1  √  null
resource_ext unserialized varchar 2147483647  √  null
person unused_reservations int8 19  √  null
inventory update_resources bool 1  √  false
integration_log updated int8 19  √  null
file_attachment upload_person_oid int8 19
person.obj_oid fkfile_attachment_upload_person_oid
file_attachment upload_time timestamptz 35,6
group_ext url varchar 2147483647  √  null
resource url varchar 2147483647  √  null
resource_ext url varchar 2147483647  √  null
section url varchar 2147483647  √  null
section_ext url varchar 2147483647  √  null
wco_group url varchar 2147483647  √  null
checkout_center usage_exclude_closed bool 1  √  null
ldap_profile use_barcode bool 1 false
allocation use_charge_duration bool 1  √  null
ldap_rule use_ldap bool 1 true
ldap_profile use_ssl bool 1 true
person userid varchar 2147483647  √  null
person_ext userid varchar 2147483647  √  null
allocation_item_building_pass uuid uuid 2147483647
resource_schedule uuid uuid 2147483647
custom_property_booleans value bool 1  √  null
custom_property_integers value int8 19  √  null
custom_property_money value odcl_money 2147483647  √  null
custom_property_strings value varchar 2147483647  √  null
custom_property_timestamps value timestamptz 35,6  √  null
resource value odcl_money 2147483647  √  null
resource_ext value varchar 2147483647  √  null
resource_type value odcl_money 2147483647  √  null
resource_type_ext value varchar 2147483647  √  null
string_map value varchar 2147483647
wco_features value varchar 2147483647
resource vendor varchar 2147483647  √  null
resource_ext vendor varchar 2147483647  √  null
person vendor_name varchar 2147483647  √  null
ticket vendor_oid int8 19  √  1
person.obj_oid fkticket_vendor
wco_version version int8 19
wco_request_log view_allocation_oid int8 19  √  null
wco_application warning_timeout int4 10  √  2
resource warranty_labor varchar 2147483647  √  null
resource_ext warranty_labor varchar 2147483647  √  null
resource warranty_parts varchar 2147483647  √  null
resource_ext warranty_parts varchar 2147483647  √  null
authset_ext wco_checkout_centers varchar 2147483647  √  null
wco_request_log webmethod varchar 2147483647  √  null
person weekly_max_hours float4 8,8  √  null
import_session what wcof_tag 2147483647  √  null
wco_task_log work_object varchar 2147483647  √  null
wco_request_log xhrmethod varchar 2147483647  √  null
bibliographic_record zone int4 10  √  null
bibliographic_record_ext zone varchar 2147483647  √  null