SchemaSpy Analysis of webco_4.0.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Fri Aug 01 13:08 EDT 2014
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

webco_4.0.public contains 967 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
resource accessories _varchar 2147483647 ARRAY[]::character varying[]
resource_ext accessories varchar 2147483647  √  null
allocation account_code varchar 2147483647  √  null
wco_group account_number varchar 2147483647  √  null
wco_log action wcof_tag 2147483647  √  null
hold active bool 1  √  null
tax_rate active bool 1 true
term active bool 1  √  null
location address varchar 2147483647  √  null
sched_staffed_location address varchar 2147483647  √  null
wco_group address_1 varchar 2147483647  √  null
wco_group address_2 varchar 2147483647  √  null
organization admin_id int8 19  √  null
person.obj_oid fkcorg_admin_id
wco_group agency_number varchar 2147483647  √  null
allocation_log agent int8 19  √  null
allocation agent_oid int8 19  √  1
person.obj_oid fkcalloc_agent_oid
inventory_event agent_oid int8 19  √  null
person.obj_oid inventory_event_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
location agreement_form_grouping wcof_tag 2147483647
location agreement_form_sorting wcof_tag 2147483647
allocation_freelancer_assigned allocation_freelancer_oid int8 19
allocation_freelancer.obj_oid fkallocation_freelancer_assigned_af_oid
allocation_freelancer_role allocation_freelancer_oid int8 19
allocation_freelancer.obj_oid fkallocation_freelancer_role_af_oid
location allocation_mode wcof_tag 2147483647  √  null
allocation_freelancer allocation_oid int8 19
allocation.obj_oid fkcallocation_freelancer_allocation_oid
allocation_group allocation_oid int8 19
allocation.obj_oid allocation_group_allocation_oid_fkey
allocation_log allocation_oid int8 19  √  null
allocation.obj_oid fkcalloc_log_alloc_oid
allocation_person allocation_oid int8 19
allocation.obj_oid allocation_person_allocation_oid_fkey
allocation_repeat_rule allocation_oid int8 19
allocation.obj_oid allocation_repeat_rule_allocation_oid_fkey
allocation_route allocation_oid int8 19
allocation.obj_oid allocation_route_allocation_oid_fkey
allocation_route_message allocation_oid int8 19
allocation.obj_oid allocation_route_message_allocation_oid_fkey
allocation_staffing allocation_oid int8 19
allocation.obj_oid fkallocation_staffing_allocation_oid
allocation_task allocation_oid int8 19
allocation.obj_oid allocation_task_allocation_oid_fkey
coalesced_deliver_to_v allocation_oid int8 19  √  null
invoice allocation_oid int8 19  √  null
allocation.obj_oid fkcinvoice_alloc_oid
mail_event allocation_oid int8 19  √  null
allocation.obj_oid fkmail_event_alloc_oid
pir_request_log allocation_oid int8 19  √  null
allocation.obj_oid fkpir_request_log_allocation_oid
resource_schedule allocation_oid int8 19  √  null
allocation.obj_oid fkcresource_schedule_alloc_oid
turndown allocation_oid int8 19  √  null
allocation.obj_oid turndown_allocation_oid_fkey
mail_event allocation_reminder_interval_oid int8 19  √  null
allocation_reminder_interval.obj_oid fkmail_event_alloc_reminder_interval_oid
bibliographic_record alternative_title wcof_collated_string 2147483647  √  null
bibliographic_record_ext alternative_title varchar 2147483647  √  null
invoice_line amount odcl_money 2147483647  √  null
default_allocation_times apply_when_open bool 1  √  null
allocation approved bool 1  √  null
resource asset_tag varchar 2147483647  √  null
resource_ext asset_tag varchar 2147483647  √  null
allocation_staffing assigned_staff int4 10
file_attachment attached_to_class varchar 2147483647
file_attachment attached_to_oid int8 19
bibliographic_record author wcof_collated_string_list 2147483647  √  null
bibliographic_record_ext author varchar 2147483647  √  null
authset_authorization authorization_oid int4 10
operator_authorization.obj_oid fkauthset_authorization_authorization_oid
resource_type_ext authorization_required varchar 2147483647  √  null
resource_type authorized bool 1  √  null
authset_authorization authset_oid int4 10
authset.obj_oid fkauthset_authorization_authset_oid
authset_location authset_oid int4 10
authset.obj_oid fkauthset_location_authset_oid
wco_group auto_authorize bool 1  √  null
allocation auto_circulate bool 1  √  null
allocation_freelancer availability wcof_tag 2147483647
invoice balance odcl_money 2147483647  √  null
invoice_charges balance numeric 131089  √  null
invoice_payments balance numeric 131089  √  null
inventory_event barcode varchar 2147483647  √  null
person barcode varchar 2147483647  √  null
person_ext barcode varchar 2147483647  √  null
resource barcode varchar 2147483647  √  null
resource_ext barcode varchar 2147483647  √  null
resource_ext biblio_id varchar 2147483647  √  null
bibliographic_record_helix bibliographic_record_oid int8 19  √  null
bibliographic_record.obj_oid fkbiblio_record_oid
holding bibliographic_record_oid int8 19
bibliographic_record.obj_oid fkholding_bibliographic_record
department_ext billing_contact varchar 2147483647  √  null
location billing_contact_email varchar 2147483647  √  null
location billing_contact_name varchar 2147483647  √  null
department billing_contact_oid int8 19  √  null
person.obj_oid fkcdepartment_billing_contact_oid
location 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
location building varchar 2147483647  √  null
sched_staffed_location building varchar 2147483647  √  null
wco_response_log bytes_used int8 19  √  null
holding call_number varchar 2147483647  √  null
resource_ext call_number varchar 2147483647  √  null
resource_controller can_record bool 1  √  null
location_auto_email cancelled_reservation_cc varchar 2147483647  √  null
location_auto_email cancelled_reservation_enabled bool 1  √  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
group_ext catalog_number varchar 2147483647  √  null
invoice cc_oid int8 19  √  null
location.obj_oid fkcinvoice_cc_oid
allocation charge_duration interval 49,6  √  null
resource circulating bool 1  √  null
resource_ext circulating 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
wco_group city varchar 2147483647  √  null
integration_log class varchar 2147483647  √  null
invoice class wcof_tag 2147483647  √  null
wco_log class varchar 2147483647  √  null
group_ext class_number varchar 2147483647  √  null
wco_group class_number varchar 2147483647  √  null
person client_name varchar 2147483647  √  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 varchar 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}}'::character varying
organization constrain_account_codes bool 1  √  null
subscription_contact contact_data varchar 2147483647
allocation contact_name_string varchar 2147483647  √  null
person contact_note varchar 2147483647  √  null
person_ext contact_note varchar 2147483647  √  null
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
resource_ext container_foreignid 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
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
wco_group 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
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
location_auto_email created_reservation_cc varchar 2147483647  √  null
location_auto_email created_reservation_enabled bool 1  √  null
invoice creation_date timestamptz 35,6  √  null
invoice_line creation_date timestamptz 35,6  √  null
allocation creation_time timestamptz 35,6  √  null
allocation credit_card_type varchar 2147483647  √  null
invoice credit_card_type varchar 2147483647  √  null
location crestron_host varchar 2147483647  √  null
location crestron_port int8 19  √  null
account_code_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
group_member_ext csv_line_number int4 10  √  null
person_ext csv_line_number int4 10  √  null
resource_ext csv_line_number int4 10  √  null
resource_type_ext csv_line_number int4 10  √  null
location custom_agreement_form_oid int8 19  √  null
resource_controller daily_sleep_time timestamptz 35,6  √  null
resource_controller daily_wake_time timestamptz 35,6  √  null
dat_location dat_oid int4 10
default_allocation_times.obj_oid dat_location_dat_oid_fkey
dat_organization dat_oid int4 10
default_allocation_times.obj_oid dat_organization_dat_oid_fkey
inventory_event date timestamptz 35,6  √  null
person_location_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
location_schedule_node day_number int4 10
location day_rollover int4 10  √  null
organization default_billing_type wcof_tag 2147483647  √  null
location default_delivery_type wcof_tag 2147483647
resource_type default_p bool 1  √  null
location default_resource_selector wcof_tag 2147483647  √  null
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
person deleted bool 1  √  null
resource deleted bool 1 false
resource_type deleted bool 1  √  null
role deleted bool 1  √  false
sched_unpublished_shift deleted bool 1  √  null
wco_group 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
group_ext department varchar 2147483647  √  null
person department varchar 2147483647  √  null
person_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
bibliographic_record description varchar 2147483647  √  null
bibliographic_record_ext description varchar 2147483647  √  null
file_attachment description varchar 2147483647  √  null
group_ext description varchar 2147483647  √  null
invoice description varchar 2147483647  √  null
invoice_line description varchar 2147483647  √  null
location description varchar 2147483647  √  null
resource description varchar 2147483647  √  null
resource_ext description varchar 2147483647  √  null
resource_type 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
term description varchar 2147483647  √  null
ticket_log description varchar 2147483647  √  null
wco_group description varchar 2147483647  √  null
resource destination bool 1  √  null
resource_ext destination varchar 2147483647  √  null
resource_controller device_id 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
invoice due_date timestamptz 35,6  √  null
organization due_days interval 49,6  √  null
allocation_reminder_interval duration interval 49,6
wco_http_event_log edit_allocation_oid int8 19  √  null
wco_request_log edit_allocation_oid int8 19  √  null
location_auto_email edited_reservation_cc varchar 2147483647  √  null
location_auto_email edited_reservation_enabled bool 1  √  null
pir_request_log editing bool 1  √  null
bibliographic_record edition varchar 2147483647  √  null
bibliographic_record_ext edition varchar 2147483647  √  null
wco_request_log effective_operator_oid int8 19  √  null
wco_http_event_log elapsed interval 49,6  √  null
department email varchar 2147483647  √  null
department_ext email varchar 2147483647  √  null
person email varchar 2147483647  √  null
person_ext email varchar 2147483647  √  null
wco_group email varchar 2147483647  √  null
person email_local varchar 2147483647  √  null
location email_template_set varchar 2147483647  √  null
default_allocation_times end_application wcof_tag 2147483647  √  null
group_ext end_date varchar 2147483647  √  null
wco_group end_date timestamptz 35,6  √  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_published_shift end_time timestamptz 35,6  √  null
sched_staff_availability end_time timestamptz 35,6  √  null
sched_unpublished_shift end_time timestamptz 35,6  √  null
wco_task_log end_time timestamptz 35,6  √  null
location_schedule_node end_time_minutes int4 10  √  null
default_allocation_times end_tod_minutes int4 10  √  null
subscription entity_oid int8 19  √  null
subscription entity_type varchar 2147483647  √  null
bibliographic_record era varchar 2147483647 'AD'::character varying
bibliographic_record_ext era varchar 2147483647  √  null
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
group_authorization expire timestamptz 35,6  √  null
group_member expire timestamptz 35,6  √  null
group_member_ext expire varchar 2147483647  √  null
allocation expire_time timestamptz 35,6  √  null
person expires timestamptz 35,6  √  null
person_ext expires varchar 2147483647  √  null
wco_group facility_oid int8 19  √  null
resource.obj_oid fkcwco_group_facility_oid
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
wco_group 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[]
allocation_staffing filled bool 1  √  null
organization fine_account varchar 2147483647  √  null
person first_name varchar 2147483647  √  null
person_ext first_name varchar 2147483647  √  null
group_ext foreignid varchar 2147483647  √  null
resource foreignid varchar 2147483647  √  null
wco_group foreignid varchar 2147483647  √  null
resource_ext foreignrtypeid varchar 2147483647  √  null
location form_date_time_format wcof_tag 2147483647
bibliographic_record format varchar 2147483647  √  null
bibliographic_record_ext format varchar 2147483647  √  null
calendar_allocation_fields freelancers bool 1  √  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
pir_request_log get_parameters _varchar 2147483647  √  null
wco_http_event_log get_parameters _varchar 2147483647  √  null
wco_request_log get_parameters _varchar 2147483647  √  null
group_member_ext group_foreignid varchar 2147483647  √  null
group_authorization group_oid int8 19
group_member.group_oid authorization_group_fkeys
wco_group.obj_oid group_authorization_group_oid_fkey
group_resource_type group_oid int8 19
wco_group.obj_oid group_resource_type_group_oid_fkey
group_set_member group_oid int8 19
wco_group.obj_oid group_set_member_group_oid_fkey
group_set_member group_set_oid int8 19
group_set.obj_oid group_set_member_group_set_oid_fkey
allocation_freelancer hash varchar 2147483647
authentication hash varchar 2147483647  √  null
bibliographic_record_helix helix_content_key varchar 2147483647  √  null
bibliographic_record_helix_ext helix_content_key varchar 2147483647  √  null
bibliographic_record_helix helix_guid varchar 2147483647  √  null
bibliographic_record_helix_ext helix_guid varchar 2147483647  √  null
bibliographic_record_helix_ext helix_path varchar 2147483647  √  null
invoice hold_date timestamptz 35,6  √  null
organization hold_days interval 49,6  √  null
hold hold_type varchar 2147483647  √  null
resource home_location_path varchar 2147483647  √  null
resource_ext home_location_string varchar 2147483647  √  null
organization honor_external_fines _int4 10 ARRAY[]::integer[]
organization honor_external_holds _int4 10 ARRAY[]::integer[]
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_http_event_log imho_element varchar 2147483647  √  null
wco_response_log imho_element varchar 2147483647  √  null
wco_log instance int8 19  √  null
group_ext instructor_foreignid varchar 2147483647  √  null
wco_group instructor_oid int8 19  √  null
person.obj_oid fkcwco_group_instructor_oid
resource_ext inventory_date varchar 2147483647  √  null
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
allocation_route is_automatic bool 1  √  null
allocation_route is_record bool 1  √  null
allocation is_show bool 1  √  null
calendar_allocation_fields is_show bool 1  √  null
resource_controller is_sink bool 1  √  null
resource_controller is_source bool 1  √  null
bibliographic_record isbn wcof_isbn_number 2147483647  √  null
bibliographic_record_ext isbn varchar 2147483647  √  null
wco_group job_numbers varchar 2147483647  √  null
string_map key varchar 2147483647
resource label_id varchar 2147483647  √  null
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
allocation_freelancer last_sent_mail wcof_tag 2147483647  √  null
resource_controller last_sleep_time timestamptz 35,6  √  null
resource_controller last_wake_time timestamptz 35,6  √  null
late_returns late_returns int8 19  √  null
person late_returns int8 19  √  null
bibliographic_record loc_control_number varchar 2147483647  √  null
bibliographic_record_ext loc_control_number varchar 2147483647  √  null
wco_log loc_oid int8 19  √  null
location.obj_oid fkcwco_log_loc_oid
resource_ext location varchar 2147483647  √  null
agreement_form_config location_oid int8 19  √  null
location.obj_oid agreement_form_config_location_oid
allocation location_oid int8 19  √  null
location.obj_oid fkcalloc_location_oid
allocation_reminder_interval location_oid int8 19
location.obj_oid fkcallocation_reminder_interval_location
authset_location location_oid int4 10
location.obj_oid fkauthset_location_location_oid
calendar_allocation_fields location_oid int8 19  √  null
location.obj_oid calendar_allocation_fields_location_oid_fkey
dat_location location_oid int8 19
location.obj_oid dat_location_location_oid_fkey
freelancer_person_location location_oid int8 19  √  null
location.obj_oid fkcfreelancer_person_location_location_oid
location_auto_email location_oid int8 19  √  null
location.obj_oid fkextlocation_oid
location_pir_pickup_option location_oid int8 19  √  null
location.obj_oid location_pir_pickup_option_location_oid_fkey
location_schedule location_oid int4 10  √  null
location.obj_oid fkclocation_schedule_location
person_location_signature location_oid int8 19  √  null
location.obj_oid person_location_signature_location_oid_fkey
pir_person_location location_oid int8 19  √  null
location.obj_oid fkcpir_location_location_oid
pir_request_log location_oid int8 19  √  null
location.obj_oid fkcpir_request_log_location_oid
resource location_oid int8 19
location.obj_oid resource_location_oid_fkey
role location_oid int8 19 1
wco_request_log location_oid int8 19  √  null
wco_station location_oid int8 19  √  null
location.obj_oid fkcwco_station_location_oid
resource location_resource_oid int8 19  √  null
resource.obj_oid fkcres_loc_res
location_schedule_node location_schedule_oid int4 10
location_schedule.obj_oid fkclocation_schedule_node_location_schedule
wco_http_event_log locked_allocations _varchar 2147483647  √  null
wco_request_log locked_allocations _varchar 2147483647  √  null
wco_response_log locked_allocations _varchar 2147483647  √  null
wco_log log_text varchar 2147483647  √  null
wco_request_log login_operator_oid int8 19  √  null
resource mac_address varchar 2147483647  √  null
resource_ext mac_address varchar 2147483647  √  null
mail_event mail_type wcof_tag 2147483647  √  null
wco_group maintenance_contract_notes varchar 2147483647  √  null
wco_group maintenance_contract_number 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
subscription_notification message varchar 2147483647  √  null
organization messaging_from_address varchar 2147483647  √  null
resource metaclass wcof_tag 2147483647
resource_ext metaclass varchar 2147483647  √  null
resource model varchar 2147483647  √  null
resource_ext model varchar 2147483647  √  null
group_member modified timestamptz 35,6  √  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
wco_application motd_text varchar 2147483647  √  null
wco_application multiple_ip bool 1  √  null
agreement_form_config name varchar 2147483647 'Agreement Form'::character varying
department name varchar 2147483647
department_ext name varchar 2147483647  √  null
group_ext name varchar 2147483647  √  null
location name varchar 2147483647
operator_authorization name wcof_tag 2147483647
operator_role name wcof_tag 2147483647
organization name varchar 2147483647  √  null
organization_credit_card_type name varchar 2147483647  √  null
resource_type name varchar 2147483647  √  null
resource_type_ext name varchar 2147483647  √  null
role name varchar 2147483647  √  null
sched_published_shift name varchar 2147483647  √  null
sched_scheduling_group name varchar 2147483647
sched_staff_availability name varchar 2147483647  √  null
sched_staffed_location name varchar 2147483647
sched_unpublished_shift name varchar 2147483647  √  null
tax_rate name varchar 10
term name varchar 2147483647  √  null
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
allocation nonexpiring bool 1  √  null
account_code note varchar 2147483647  √  null
account_code_ext note varchar 2147483647  √  null
allocation note varchar 2147483647  √  null
calendar_allocation_fields note bool 1  √  null
department_code note varchar 2147483647  √  null
person note varchar 2147483647  √  null
person_ext note varchar 2147483647  √  null
wco_group note varchar 2147483647  √  null
sched_published_shift notes varchar 2147483647  √  null
sched_unpublished_shift notes varchar 2147483647  √  null
account_code obj_oid int8 19
account_code_ext obj_oid int8 19
agreement_form_config obj_oid int8 19
allocation_freelancer_assigned obj_oid int8 19
allocation_freelancer_role obj_oid int8 19
allocation_group obj_oid int8 19
allocation_log obj_oid int8 19
allocation_person obj_oid int8 19
allocation_route obj_oid int8 19
allocation_route_message obj_oid int8 19
allocation_staffing obj_oid int8 19
allocation_task obj_oid int8 19
authentication obj_oid int8 19
person.obj_oid fkcauthentication_obj_oid
authset_authorization obj_oid int4 10
authset_location obj_oid int4 10
bibliographic_record_ext obj_oid int8 19
bibliographic_record_helix obj_oid int8 19
calendar_allocation_fields obj_oid int8 19
calendar_authentication obj_oid int8 19
person.obj_oid fkccalauthentication_obj_oid
circulation_policy obj_oid int8 19
dat_location obj_oid int4 10
dat_organization obj_oid int4 10
department_code obj_oid int8 19
department_ext obj_oid int8 19
file_attachment obj_oid int8 19
freelancer_person_location obj_oid int8 19
group_authorization obj_oid int8 19
group_ext obj_oid serial 10  √  nextval('group_ext_obj_oid_seq'::regclass)
group_member obj_oid int8 19
group_member_ext obj_oid serial 10  √  nextval('group_member_ext_obj_oid_seq'::regclass)
group_resource_type obj_oid int8 19
group_set_member obj_oid serial 10  √  nextval('group_set_member_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_event obj_oid int8 19
invoice_line_tax_rate obj_oid int8 19
invoice_tax_rate obj_oid int8 19
invoices_pending_export obj_oid int8 19
location_auto_email obj_oid int8 19
location_pir_pickup_option obj_oid int8 19
location_schedule_node obj_oid int4 10
mail_event obj_oid int8 19
organization_credit_card_type obj_oid int8 19
person_ext obj_oid int8 19
person_location_signature obj_oid int8 19
person_role obj_oid int8 19
pir_person_location obj_oid int8 19
pir_request_log obj_oid int8 19
resource_controller obj_oid int8 19
resource_ext obj_oid int8 19
resource_schedule obj_oid int8 19
resource_sleep_queue obj_oid int8 19  √  null
resource_type_ext obj_oid int8 19
resource_type_fallback obj_oid int8 19
resource_wake_queue obj_oid int8 19  √  null
rrt_bundle obj_oid int8 19
sched_scheduling_group_member obj_oid int8 19
sched_staff_availability obj_oid int8 19
sched_staffing_limit obj_oid int8 19
sched_unpublished_shift obj_oid int8 19
subscription_contact obj_oid int8 19
subscription_notification obj_oid int8 19
term obj_oid int8 19
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_log obj_oid int8 19
wco_request_log obj_oid int8 19
wco_response_log obj_oid int8 19
wco_station obj_oid int8 19
wco_task_log obj_oid int8 19
ticket open_date timestamptz 35,6  √  null
resource_type open_group_oid int8 19  √  null
wco_group.obj_oid fkcresource_type_open_group_oid
authset operator_role_oid int4 10  √  null
operator_role.obj_oid fkauthset_role_oid
dat_organization org_oid int8 19
organization.obj_oid dat_organization_org_oid_fkey
invoice org_oid int8 19  √  null
organization.obj_oid fkcinvoice_org_oid
location org_oid int8 19
organization.obj_oid location_org_oid_fkey
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
group_ext organization varchar 2147483647  √  null
resource_type_ext organization varchar 2147483647  √  null
authset organization_oid int4 10
organization.obj_oid fkauthset_organization_oid
hold organization_oid int8 19  √  null
organization.obj_oid fkchold_organization_oid
person organization_oid int8 19  √  null
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  √  null
organization.obj_oid fkcwco_group_organization_oid
account_code origin varchar 2147483647  √  null
account_code_ext origin varchar 2147483647  √  null
bibliographic_record origin varchar 2147483647  √  null
bibliographic_record_ext origin varchar 2147483647  √  null
department origin varchar 2147483647  √  null
department_ext origin varchar 2147483647  √  null
group_ext origin varchar 2147483647  √  null
group_member origin varchar 2147483647  √  null
group_member_ext origin varchar 2147483647  √  null
import_session origin varchar 2147483647  √  null
person origin varchar 2147483647  √  null
person_ext origin varchar 2147483647  √  null
resource origin varchar 2147483647  √  null
resource_ext origin varchar 2147483647  √  null
resource_type origin varchar 2147483647  √  null
resource_type_ext origin varchar 2147483647  √  null
wco_group origin varchar 2147483647  √  null
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
resource_type_ext parent varchar 2147483647  √  null
location_schedule parent_oid int4 10  √  null
location_schedule.obj_oid fkclocation_schedule_parent
resource_type parent_oid int8 19  √  null
resource_parent parent_resource_oid int8 19  √  null
authentication password varchar 2147483647  √  null
person_ext password varchar 2147483647  √  null
resource_type path varchar 2147483647  √  null
allocation patron_class wcof_tag 2147483647  √  null
circulation_policy patron_class wcof_tag 2147483647  √  null
person patron_class wcof_tag 2147483647  √  null
person_ext patron_class 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
pir_request_log patron_oid int8 19  √  null
person.obj_oid fkpir_request_log_patron_oid
ticket patron_oid int8 19  √  null
person.obj_oid fkticket_patron
turndown patron_oid int8 19  √  null
person.obj_oid turndown_patron_oid_fkey
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
wco_group period varchar 2147483647  √  null
group_member_ext person_foreignid varchar 2147483647  √  null
allocation_freelancer person_oid int8 19
person.obj_oid fkcallocation_freelancer_person_oid
allocation_person person_oid int8 19  √  null
person.obj_oid fkcalloc_person_person_oid
authset person_oid int4 10
person.obj_oid fkauthset_person_oid
freelancer_person_location person_oid int8 19  √  null
person.obj_oid fkcfreelancer_person_location_person_oid
group_authorization person_oid int8 19
person.obj_oid group_authorization_person_oid_fkey
group_member.person_oid authorization_group_fkeys
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_location_signature person_oid int8 19  √  null
person.obj_oid person_location_signature_person_oid_fkey
person_role person_oid int8 19  √  null
person.obj_oid fkperson_role_person_oid
pir_person_location person_oid int8 19  √  null
person.obj_oid fkcpir_location_person_oid
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
person person_type varchar 2147483647  √  null
wco_group phone varchar 2147483647  √  null
location pickup_default wcof_tag 2147483647
allocation pickup_instructions varchar 2147483647  √  null
calendar_allocation_fields pickup_instructions bool 1  √  null
allocation pickup_option wcof_tag 2147483647  √  null
calendar_allocation_fields pickup_option bool 1  √  null
location_pir_pickup_option pickup_option wcof_tag 2147483647  √  null
location_auto_email pickup_reservation_cc varchar 2147483647  √  null
location_auto_email pickup_reservation_enabled bool 1  √  null
authentication pin varchar 2147483647  √  null
authentication pin_hash varchar 2147483647  √  null
location pir_media_cc_query bool 1  √  null
location pir_mode wcof_tag 2147483647  √  null
location 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
location pir_requires_approval bool 1  √  null
location pir_restrict_delivery_locations bool 1  √  null
location 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_value varchar 2147483647  √  null
pir_request_log post_parameters _varchar 2147483647  √  null
wco_http_event_log post_parameters _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
wco_group postal_code varchar 2147483647  √  null
location print_queue varchar 2147483647  √  'wco_local'::character varying
wco_station print_queue varchar 2147483647  √  null
location print_template_set varchar 2147483647  √  null
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
wco_application ps_accepted_terms varchar 2147483647  √  null
bibliographic_record publication_year int8 19  √  null
bibliographic_record_ext publication_year varchar 2147483647  √  null
sched_unpublished_shift published_shift_oid int8 19  √  null
sched_published_shift.obj_oid unpub_shift_staffed_loc_oid
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_order varchar 2147483647  √  null
resource_ext purchase_order varchar 2147483647  √  null
ticket purchase_order varchar 2147483647  √  null
invoice_line quantity int8 19  √  null
wco_http_event_log query_path varchar 2147483647  √  null
wco_request_log query_path varchar 2147483647  √  null
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 reference_id varchar 2147483647  √  null
invoice reference_id varchar 2147483647  √  null
group_ext registration_code varchar 2147483647  √  null
allocation_task related_types varchar 2147483647  √  null
allocation_person relation wcof_tag 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
location repeats_in_pir bool 1  √  null
resource replacement_date timestamptz 35,6  √  null
resource_ext replacement_date varchar 2147483647  √  null
wco_http_event_log request_oid int8 19  √  null
wco_http_event_log request_time_stamp timestamptz 35,6  √  null
wco_request_log request_token varchar 2147483647  √  null
wco_response_log request_token varchar 2147483647  √  null
resource_schedule requested_rtype_oid int8 19  √  null
location require_signature_on_file bool 1  √  false
allocation_staffing required_staff int4 10
resource_schedule requires_building_pass bool 1  √  false
ticket resolution wcof_tag 2147483647  √  null
holding resource_oid int8 19
resource.obj_oid fkholding_resource
inventory_event resource_oid int8 19  √  null
resource.obj_oid inventory_event_resource_oid_fkey
invoice_line resource_oid int8 19  √  null
resource.obj_oid fkinv_line_res
resource_parent resource_oid int8 19  √  null
ticket resource_oid int8 19  √  null
resource.obj_oid fkticket_res
calendar_allocation_fields resource_types bool 1  √  null
calendar_allocation_fields resources bool 1  √  null
wco_http_event_log response_oid int8 19  √  null
wco_http_event_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
resource_schedule return_agent_oid int8 19  √  1
person.obj_oid fkcresource_schedule_return_agent_oid
location_auto_email return_checkout_cc varchar 2147483647  √  null
location_auto_email return_checkout_enabled bool 1  √  null
location return_default wcof_tag 2147483647
allocation return_option wcof_tag 2147483647  √  null
allocation_freelancer_assigned role_oid int8 19
role.obj_oid fkcallocation_freelancer_role_oid
allocation_freelancer_role role_oid int8 19
role.obj_oid fkcallocation_freelancer_role_oid
allocation_staffing role_oid int8 19
role.obj_oid fkallocation_staffing_role_oid
person_role role_oid int8 19  √  null
role.obj_oid fkperson_role_role_oid
resource roles _varchar 2147483647 ARRAY[]::character varying[]
location room varchar 2147483647  √  null
sched_staffed_location room varchar 2147483647  √  null
resource room_number varchar 2147483647  √  null
resource_ext room_number varchar 2147483647  √  null
circulation_policy rtype_oid int8 19  √  null
resource_type.obj_oid fkccirculation_policy_rtype_oid
group_authorization rtype_oid int8 19
resource_type.obj_oid group_authorization_rtype_oid_fkey
group_resource_type rtype_oid int8 19
resource_type.obj_oid group_resource_type_rtype_oid_fkey
location rtype_oid int8 19  √  null
resource_type.obj_oid fkloc_rtype
organization rtype_oid int8 19  √  null
resource_type.obj_oid fkorg_rtype
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
bibliographic_record run_time int8 19  √  null
bibliographic_record_ext run_time varchar 2147483647  √  null
authentication salt varchar 2147483647  √  null
location_schedule schedule_end timestamptz 35,6  √  null
location_schedule schedule_length int4 10  √  null
location_schedule schedule_name varchar 2147483647  √  null
location_schedule schedule_start timestamptz 35,6  √  null
location_schedule schedule_type wcof_tag 2147483647
resource_schedule scheduled_resource_oid int8 19
resource.obj_oid resource_schedule_scheduled_resource_oid_fkey
sched_published_shift scheduling_group_oid int8 19  √  null
sched_scheduling_group.obj_oid published_sched_sched_group_oid
sched_scheduling_group_member scheduling_group_oid int8 19
sched_scheduling_group.obj_oid sched_scheduling_group_member_scheduling_group_oid_fkey
sched_unpublished_shift scheduling_group_oid int8 19  √  null
sched_scheduling_group.obj_oid unpub_sched_sched_group_oid
wco_application schema_version int8 19  √  null
wco_response_log seconds_used float8 17,17  √  null
organization semester_end timestamptz 35,6  √  null
organization semester_start timestamptz 35,6  √  null
mail_event send_time 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
pir_request_log sessionid varchar 2147483647  √  null
wco_http_event_log sessionid varchar 2147483647  √  null
wco_request_log sessionid varchar 2147483647  √  null
wco_response_log sessionid varchar 2147483647  √  null
ticket severity wcof_tag 2147483647  √  null
holding shelf_location varchar 2147483647  √  null
resource_ext shelf_location varchar 2147483647  √  null
allocation_route sink_oid int8 19
resource.obj_oid allocation_route_sink_oid_fkey
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
allocation_route source_oid int8 19
resource.obj_oid allocation_route_source_oid_fkey
sched_published_shift staff_oid int8 19  √  null
sched_staff.obj_oid shift_staff_oid
sched_scheduling_group_member staff_oid int8 19
sched_staff.obj_oid sched_scheduling_group_member_staff_oid_fkey
sched_staffing_limit staff_oid int8 19
sched_staff.obj_oid sched_staffing_limit_staff_oid_fkey
sched_unpublished_shift staff_oid int8 19  √  null
sched_staff.obj_oid unpub_shift_staff_oid
sched_published_shift staffed_location_oid int8 19
sched_staffed_location.obj_oid sched_published_shift_staffed_location_oid_fkey
sched_scheduling_group staffed_location_oid int8 19
sched_staffed_location.obj_oid sched_scheduling_group_staffed_location_oid_fkey
sched_staff staffed_location_oid int8 19
sched_staffed_location.obj_oid sched_staff_staffed_location_oid_fkey
sched_unpublished_shift staffed_location_oid int8 19
sched_staffed_location.obj_oid sched_unpublished_shift_staffed_location_oid_fkey
default_allocation_times start_application wcof_tag 2147483647  √  null
group_authorization start_date timestamptz 35,6  √  null
group_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_published_shift start_time timestamptz 35,6  √  null
sched_staff_availability start_time timestamptz 35,6  √  null
sched_unpublished_shift start_time timestamptz 35,6  √  null
wco_task_log start_time timestamptz 35,6  √  null
location_schedule_node start_time_minutes int4 10  √  null
default_allocation_times start_tod_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_group state varchar 2147483647  √  null
wco_request_log station varchar 2147483647  √  null
integration_log status varchar 2147483647  √  null
location_schedule_node status wcof_tag 2147483647
person status wcof_tag 2147483647  √  null
person_ext status varchar 2147483647  √  null
wco_http_event_log status int4 10  √  null
wco_response_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
rrt_bundle sub_rtype_oid int8 19
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
invoice_line subtype wcof_tag 2147483647  √  null
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
organization suppress_autopayment bool 1  √  null
person suppress_email bool 1  √  null
wco_task_log task_object varchar 2147483647  √  null
allocation_task task_time timestamptz 35,6  √  null
allocation_task task_type wcof_tag 2147483647  √  null
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
wco_group teaching_assistant_oid int8 19  √  null
person.obj_oid fkcwco_group_teaching_assistant_oid
department telephone varchar 2147483647  √  null
department_ext telephone varchar 2147483647  √  null
location telephone varchar 2147483647  √  null
person telephone varchar 2147483647  √  null
person_ext telephone varchar 2147483647  √  null
sched_staffed_location telephone varchar 2147483647  √  null
person telephone_local varchar 2147483647  √  null
group_ext term_foreignid varchar 2147483647  √  null
allocation_log text varchar 2147483647  √  null
allocation_route_message text varchar 2147483647  √  null
location_auto_email ticket_cc varchar 2147483647  √  null
location_auto_email ticket_enabled bool 1  √  null
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
pir_request_log time_stamp timestamptz 35,6  √  null
wco_log time_stamp timestamptz 35,6  √  null
wco_request_log time_stamp timestamptz 35,6  √  null
wco_response_log time_stamp timestamptz 35,6  √  null
location timeline_granularity int8 19  √  null
location timeline_zoom_factor int8 19  √  null
bibliographic_record title wcof_collated_string 2147483647  √  null
bibliographic_record_ext title varchar 2147483647  √  null
person title varchar 2147483647  √  null
calendar_authentication token varchar 2147483647  √  null
allocation_log type wcof_tag 2147483647  √  null
allocation_reminder_interval type wcof_tag 2147483647
allocation_repeat_rule type wcof_tag 2147483647  √  null
coalesced_deliver_to_v type text 2147483647  √  null
group_ext 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
wco_group 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_response_log ui_allocation_next_state wcof_tag 2147483647  √  null
wco_request_log ui_current_allocation_oid int8 19  √  null
pir_request_log unsaved_allocation_oid int8 19  √  null
allocation.obj_oid fkpir_request_log_unsaved_allocation_oid
resource unserialized bool 1  √  null
resource_ext unserialized varchar 2147483647  √  null
person unused_reservations int8 19  √  null
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
resource url varchar 2147483647  √  null
resource_ext url varchar 2147483647  √  null
wco_group url varchar 2147483647  √  null
location usage_exclude_closed bool 1  √  null
allocation use_charge_duration bool 1  √  null
person userid varchar 2147483647  √  null
person_ext userid varchar 2147483647  √  null
resource_schedule uuid varchar 2147483647
resource value odcl_money 2147483647  √  null
resource_ext value varchar 2147483647  √  null
string_map 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_http_event_log view_allocation_oid int8 19  √  null
wco_request_log view_allocation_oid int8 19  √  null
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
pir_request_log webmethod varchar 2147483647  √  null
wco_request_log webmethod varchar 2147483647  √  null
person weekly_max_hours int8 19  √  null
import_session what wcof_tag 2147483647  √  null
wco_task_log work_object varchar 2147483647  √  null
wco_request_log xhrmethod varchar 2147483647  √  null
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
invoice.paying_dept_oid fkcinvoice_paying_dept_oid
location obj_oid int8 19
agreement_form_config.location_oid agreement_form_config_location_oid
allocation.location_oid fkcalloc_location_oid
allocation_reminder_interval.location_oid fkcallocation_reminder_interval_location
authset_location.location_oid fkauthset_location_location_oid
calendar_allocation_fields.location_oid calendar_allocation_fields_location_oid_fkey
dat_location.location_oid dat_location_location_oid_fkey
freelancer_person_location.location_oid fkcfreelancer_person_location_location_oid
invoice.cc_oid fkcinvoice_cc_oid
location_auto_email.location_oid fkextlocation_oid
location_pir_pickup_option.location_oid location_pir_pickup_option_location_oid_fkey
location_schedule.location_oid fkclocation_schedule_location
person_location_signature.location_oid person_location_signature_location_oid_fkey
pir_person_location.location_oid fkcpir_location_location_oid
pir_request_log.location_oid fkcpir_request_log_location_oid
resource.location_oid resource_location_oid_fkey
wco_log.loc_oid fkcwco_log_loc_oid
wco_station.location_oid fkcwco_station_location_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_freelancer.person_oid fkcallocation_freelancer_person_oid
allocation_person.person_oid fkcalloc_person_person_oid
authentication.obj_oid fkcauthentication_obj_oid
authset.person_oid fkauthset_person_oid
calendar_authentication.obj_oid fkccalauthentication_obj_oid
department.billing_contact_oid fkcdepartment_billing_contact_oid
file_attachment.upload_person_oid fkfile_attachment_upload_person_oid
freelancer_person_location.person_oid fkcfreelancer_person_location_person_oid
group_authorization.person_oid group_authorization_person_oid_fkey
group_member.person_oid fkcgroup_member_person_oid
hold.person_oid fkchold_person_oid
inventory_event.agent_oid inventory_event_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_location_signature.person_oid person_location_signature_person_oid_fkey
person_role.person_oid fkperson_role_person_oid
pir_person_location.person_oid fkcpir_location_person_oid
pir_request_log.patron_oid fkpir_request_log_patron_oid
resource_schedule.return_agent_oid fkcresource_schedule_return_agent_oid
sched_staff.person_oid sched_staff_person_oid_fkey
sched_staff_availability.person_oid sched_staff_availability_person_oid_fkey
subscription.person_oid fksubscription_person_oid
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.instructor_oid fkcwco_group_instructor_oid
wco_group.teaching_assistant_oid fkcwco_group_teaching_assistant_oid
wco_log.agent_oid fkcwco_log_agent_oid
wco_log.responsible_agent_oid fkcwco_log_reps_agent_oid
resource obj_oid int8 19
allocation.deliver_to_oid fkcalloc_deliver_to_oid
allocation_route.sink_oid allocation_route_sink_oid_fkey
allocation_route.source_oid allocation_route_source_oid_fkey
holding.resource_oid fkholding_resource
inventory_event.resource_oid inventory_event_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.scheduled_resource_oid resource_schedule_scheduled_resource_oid_fkey
ticket.resource_oid fkticket_res
wco_group.facility_oid fkcwco_group_facility_oid
allocation obj_oid int8 19
allocation_freelancer.allocation_oid fkcallocation_freelancer_allocation_oid
allocation_group.allocation_oid allocation_group_allocation_oid_fkey
allocation_group.source_allocation_oid fkcalloc_group_src_alloc_oid
allocation_log.allocation_oid fkcalloc_log_alloc_oid
allocation_person.allocation_oid allocation_person_allocation_oid_fkey
allocation_repeat_rule.allocation_oid allocation_repeat_rule_allocation_oid_fkey
allocation_route.allocation_oid allocation_route_allocation_oid_fkey
allocation_route_message.allocation_oid allocation_route_message_allocation_oid_fkey
allocation_staffing.allocation_oid fkallocation_staffing_allocation_oid
allocation_task.allocation_oid allocation_task_allocation_oid_fkey
invoice.allocation_oid fkcinvoice_alloc_oid
mail_event.allocation_oid fkmail_event_alloc_oid
pir_request_log.allocation_oid fkpir_request_log_allocation_oid
pir_request_log.unsaved_allocation_oid fkpir_request_log_unsaved_allocation_oid
resource_schedule.allocation_oid fkcresource_schedule_alloc_oid
turndown.allocation_oid turndown_allocation_oid_fkey
role obj_oid int8 19
allocation_freelancer_assigned.role_oid fkcallocation_freelancer_role_oid
allocation_freelancer_role.role_oid fkcallocation_freelancer_role_oid
allocation_staffing.role_oid fkallocation_staffing_role_oid
person_role.role_oid fkperson_role_role_oid
allocation_freelancer obj_oid int8 19
allocation_freelancer_assigned.allocation_freelancer_oid fkallocation_freelancer_assigned_af_oid
allocation_freelancer_role.allocation_freelancer_oid fkallocation_freelancer_role_af_oid
allocation_repeat_rule obj_oid int8 19
allocation_group.rule_oid fkcalloc_group_rule_oid
organization obj_oid int8 19
authset.organization_oid fkauthset_organization_oid
dat_organization.org_oid dat_organization_org_oid_fkey
hold.organization_oid fkchold_organization_oid
invoice.org_oid fkcinvoice_org_oid
location.org_oid location_org_oid_fkey
resource_type.org_oid fkcresource_type_org_oid
sched_staffed_location.org_oid sched_staffed_location_org_oid_fkey
tax_rate.organization_oid fk_taxrates_organization_oid
wco_group.organization_oid fkcwco_group_organization_oid
wco_log.org_oid fkcwco_log_org_oid
operator_role obj_oid serial 10  √  nextval('hibernate_sequence'::regclass)
authset.operator_role_oid fkauthset_role_oid
authset obj_oid int4 10
authset_authorization.authset_oid fkauthset_authorization_authset_oid
authset_location.authset_oid fkauthset_location_authset_oid
operator_authorization obj_oid serial 10  √  nextval('hibernate_sequence'::regclass)
authset_authorization.authorization_oid fkauthset_authorization_authorization_oid
bibliographic_record obj_oid int8 19
bibliographic_record_helix.bibliographic_record_oid fkbiblio_record_oid
holding.bibliographic_record_oid fkholding_bibliographic_record
resource_type obj_oid int8 19
circulation_policy.rtype_oid fkccirculation_policy_rtype_oid
group_authorization.rtype_oid group_authorization_rtype_oid_fkey
group_resource_type.rtype_oid group_resource_type_rtype_oid_fkey
location.rtype_oid fkloc_rtype
organization.rtype_oid fkorg_rtype
resource.rtype_oid resource_rtype_oid_fkey
resource_type_fallback.fallback_oid resource_type_fallback_fallback_oid_fkey
resource_type_fallback.type_oid resource_type_fallback_type_oid_fkey
default_allocation_times obj_oid int4 10
dat_location.dat_oid dat_location_dat_oid_fkey
dat_organization.dat_oid dat_organization_dat_oid_fkey
wco_group obj_oid int8 19
group_authorization.group_oid group_authorization_group_oid_fkey
group_member.group_oid fkcgroup_member_group_oid
group_resource_type.group_oid group_resource_type_group_oid_fkey
group_set_member.group_oid group_set_member_group_oid_fkey
resource_type.open_group_oid fkcresource_type_open_group_oid
group_member group_oid int8 19
group_authorization.group_oid authorization_group_fkeys
wco_group.obj_oid fkcgroup_member_group_oid
group_member person_oid int8 19
group_authorization.person_oid authorization_group_fkeys
person.obj_oid fkcgroup_member_person_oid
group_set obj_oid int8 19
group_set_member.group_set_oid group_set_member_group_set_oid_fkey
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
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
invoice_line obj_oid int8 19
invoice_line_tax_rate.invoice_line_oid invoice_line_tax_rate_invoice_line_oid_fkey
location_schedule obj_oid int4 10
location_schedule.parent_oid fkclocation_schedule_parent
location_schedule_node.location_schedule_oid fkclocation_schedule_node_location_schedule
allocation_reminder_interval obj_oid int8 19
mail_event.allocation_reminder_interval_oid fkmail_event_alloc_reminder_interval_oid
sched_staffed_location obj_oid int8 19
sched_published_shift.staffed_location_oid sched_published_shift_staffed_location_oid_fkey
sched_scheduling_group.staffed_location_oid sched_scheduling_group_staffed_location_oid_fkey
sched_staff.staffed_location_oid sched_staff_staffed_location_oid_fkey
sched_unpublished_shift.staffed_location_oid sched_unpublished_shift_staffed_location_oid_fkey
sched_staff obj_oid int8 19
sched_published_shift.staff_oid shift_staff_oid
sched_scheduling_group_member.staff_oid sched_scheduling_group_member_staff_oid_fkey
sched_staffing_limit.staff_oid sched_staffing_limit_staff_oid_fkey
sched_unpublished_shift.staff_oid unpub_shift_staff_oid
sched_scheduling_group obj_oid int8 19
sched_published_shift.scheduling_group_oid published_sched_sched_group_oid
sched_scheduling_group_member.scheduling_group_oid sched_scheduling_group_member_scheduling_group_oid_fkey
sched_unpublished_shift.scheduling_group_oid unpub_sched_sched_group_oid
sched_published_shift obj_oid int8 19
sched_unpublished_shift.published_shift_oid unpub_shift_staffed_loc_oid
subscription obj_oid int8 19
subscription_contact.subscription_oid fksubscription_notification_subscription
subscription_notification.subscription_oid fksubscription_notification_subscription
ticket obj_oid int8 19
ticket_log.ticket_oid fkcticket_log_ticket_oid