SchemaSpy Analysis of webco_3.9.1.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Tue Feb 04 14:58 EST 2014
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

webco_3.9.1.public contains 988 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  √  null
resource_ext accessories varchar 2147483647  √  null
allocation account_code varchar 2147483647  √  null
wco_group account_number varchar 2147483647  √  null
wco_log action varchar 2147483647  √  null
hold active bool 1  √  null
tax_rate active bool 1 true
term active bool 1  √  null
task actual_end_time timestamp 29,6  √  null
task actual_start_time timestamp 29,6  √  null
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
task agency_job_number varchar 2147483647  √  null
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 int8 19  √  null
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
wco_application allocation_id int8 19  √  null
location allocation_mode varchar 2147483647  √  null
allocation_building_pass allocation_oid int8 19
allocation.obj_oid allocation_building_pass_allocation_oid_fkey
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_allocation allocation_oid int8 19  √  null
allocation.obj_oid fkcpir_allocation_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 varchar 2147483647  √  null
bibliographic_record_ext alternative_title varchar 2147483647  √  null
invoice_line amount int8 19  √  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
pq_invoice_line association int8 19  √  null
file_attachment attached_to_class varchar 2147483647
file_attachment attached_to_oid int8 19
bibliographic_record author varchar 2147483647  √  null
bibliographic_record_ext author varchar 2147483647  √  null
resource_type_ext authorization_required varchar 2147483647  √  null
wco_authorization authorizations varchar 2147483647  √  null
resource_type authorized bool 1  √  null
wco_group auto_authorize bool 1  √  null
allocation auto_circulate bool 1  √  null
allocation_freelancer availability varchar 2147483647
invoice balance int8 19  √  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
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 varchar 2147483647  √  null
resource budget_number varchar 2147483647  √  null
resource_ext budget_number varchar 2147483647  √  null
location building varchar 2147483647  √  null
wco_response_log bytes_used int8 19  √  null
holding call_number varchar 2147483647  √  null
holding_ext 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 varchar 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 varchar 2147483647  √  null
resource_child child_resource_oid int8 19  √  null
holding_ext circulating bool 1  √  null
resource circulating bool 1  √  null
resource_ext circulating varchar 2147483647  √  null
department 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
integration_proc class varchar 2147483647  √  null
invoice class varchar 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
task client_oid int8 19  √  null
ticket close_date timestamp 29,6  √  null
account_code code varchar 2147483647
department_code code varchar 2147483647
bibliographic_record color varchar 2147483647  √  null
bibliographic_record_configuration color bool 1  √  null
bibliographic_record_ext color varchar 2147483647  √  null
pq_account_preference component_states varchar 2147483647  √  null
tax_rate compound bool 1 false
resource condition_note varchar 2147483647  √  null
resource_ext condition_note varchar 2147483647  √  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 varchar 2147483647
resource_ext container_foreignid varchar 2147483647  √  null
resource containing_resource_oid int8 19  √  null
resource.obj_oid fkres_cont_res
bibliographic_record contributor varchar 2147483647  √  null
bibliographic_record_configuration contributor bool 1  √  null
bibliographic_record_ext contributor varchar 2147483647  √  null
service cost_per_unit numeric 131089  √  null
bibliographic_record country varchar 2147483647  √  null
bibliographic_record_ext country varchar 2147483647  √  null
department 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_configuration course bool 1  √  null
bibliographic_record_ext course varchar 2147483647  √  null
hold created timestamp 29,6  √  null
integration_log created int8 19  √  null
task created_at timestamp 29,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
location_auto_email created_reservation_cc varchar 2147483647  √  null
location_auto_email created_reservation_enabled bool 1  √  null
invoice creation_date timestamp 29,6  √  null
invoice_line creation_date timestamp 29,6  √  null
allocation creation_time timestamp 29,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
bibliographic_record_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
resource_controller daily_sleep_time timestamp 29,6  √  null
resource_controller daily_wake_time timestamp 29,6  √  null
dat_location dat_oid int4 10
default_allocation_times.obj_oid fkcdat_oid
dat_organization dat_oid int4 10
default_allocation_times.obj_oid fkcdat_oid
bibliographic_record_configuration data bool 1  √  null
inventory_event date timestamp 29,6  √  null
person_location_signature date timestamp 29,6  √  null
ticket_log date timestamp 29,6  √  null
turndown date timestamp 29,6  √  null
invoice date_paid timestamp 29,6  √  null
ticket date_returned timestamp 29,6  √  null
ticket date_sent_out timestamp 29,6  √  null
location_schedule_node day_number int4 10
location day_rollover int4 10  √  null
location default_delivery_type varchar 2147483647 'NORMAL'::character varying
resource_type default_p bool 1  √  null
location default_resource_selector 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
task 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
pir_allocation deliver_to_string varchar 2147483647  √  null
calendar_allocation_fields delivery_people bool 1  √  null
allocation delivery_type varchar 2147483647  √  null
group_ext department varchar 2147483647  √  null
person department varchar 2147483647  √  null
person_ext department varchar 2147483647  √  null
task department_job_number 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
task depends_on int8 19  √  null
task.obj_oid fktask_depends_on_oid
bibliographic_record description varchar 2147483647  √  null
bibliographic_record_configuration description bool 1  √  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
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 varchar 2147483647  √  null
bibliographic_record_configuration director bool 1  √  null
bibliographic_record_ext director varchar 2147483647  √  null
holding distributor varchar 2147483647  √  null
holding_ext distributor varchar 2147483647  √  null
resource_ext distributor varchar 2147483647  √  null
invoice due_date timestamp 29,6  √  null
organization due_days varchar 2147483647  √  null
allocation_reminder_interval duration varchar 2147483647
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_configuration edition bool 1  √  null
bibliographic_record_ext edition varchar 2147483647  √  null
wco_request_log effective_operator_oid int8 19  √  null
department 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 varchar 2147483647  √  null
group_ext end_date varchar 2147483647  √  null
wco_group end_date timestamp 29,6  √  null
allocation end_time timestamp 29,6  √  null
allocation_repeat_rule end_time timestamp 29,6  √  null
integration_log end_time timestamp 29,6  √  null
pir_allocation end_time timestamp 29,6  √  null
resource_schedule end_time timestamp 29,6  √  null
wco_task_log end_time timestamp 29,6  √  null
location_schedule_node end_time_minutes int4 10  √  null
default_allocation_times end_tod_minutes int4 10  √  null
index_entry entity_class varchar 2147483647
index_entry entity_oid int8 19
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 timestamp 29,6  √  null
task estimate_p bool 1  √  null
ticket estimated_cost varchar 2147483647  √  null
allocation event_description varchar 2147483647  √  null
calendar_allocation_fields event_description bool 1  √  null
invoice event_description varchar 2147483647  √  null
group_authorization expire timestamp 29,6  √  null
group_member expire timestamp 29,6  √  null
group_member_ext expire varchar 2147483647  √  null
allocation expire_time timestamp 29,6  √  null
person expires timestamp 29,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
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  √  null
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
holding_ext foreignbiblio varchar 2147483647
group_ext foreignid varchar 2147483647  √  null
resource foreignid varchar 2147483647  √  null
wco_group foreignid varchar 2147483647  √  null
holding_ext foreignrsrc varchar 2147483647
holding_ext foreignrtypeid varchar 2147483647  √  null
resource_ext foreignrtypeid varchar 2147483647  √  null
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
task_parent_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
wco_group.obj_oid group_authorization_group_oid_fkey
group_member.group_oid authorization_group_fkeys
group_resource_type group_oid int8 19
wco_group.obj_oid group_resource_type_group_oid_fkey
group_set group_oid int8 19
task_group group_oid int8 19  √  null
allocation_freelancer hash varchar 2147483647
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 timestamp 29,6  √  null
organization hold_days varchar 2147483647  √  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 varchar 2147483647  √  null
organization honor_external_holds 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_http_event_log imho_element varchar 2147483647  √  null
wco_response_log imho_element varchar 2147483647  √  null
task index serial 10  √  nextval('task_index_seq'::regclass)
index_entry index_name varchar 2147483647
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
pq_invoice_line invoice_oid int8 19  √  null
invoice invoice_status varchar 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 varchar 2147483647  √  null
bibliographic_record_configuration isbn bool 1  √  null
bibliographic_record_ext isbn varchar 2147483647  √  null
wco_group job_numbers varchar 2147483647  √  null
pq_invoice journaled_p bool 1  √  null
string_map key varchar 2147483647
pq_invoice label varchar 2147483647  √  null
task label varchar 2147483647  √  null
resource label_id varchar 2147483647  √  null
resource_ext label_id varchar 2147483647  √  null
bibliographic_record language varchar 2147483647  √  null
bibliographic_record_configuration language bool 1  √  null
bibliographic_record_ext language varchar 2147483647  √  null
resource last_inventoried_date timestamp 29,6  √  null
person last_name varchar 2147483647  √  null
person_ext last_name varchar 2147483647  √  null
allocation last_renewal timestamp 29,6  √  null
allocation_freelancer last_sent_mail varchar 2147483647  √  null
resource_controller last_sleep_time timestamp 29,6  √  null
resource_controller last_wake_time timestamp 29,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_configuration loc_control_number bool 1  √  null
bibliographic_record_ext loc_control_number varchar 2147483647  √  null
wco_log loc_oid int8 19  √  null
location.obj_oid fkcwco_log_loc_oid
holding_ext location varchar 2147483647
resource_ext location varchar 2147483647  √  null
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
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 fkcdat_location_oid
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_allocation location_oid int8 19  √  null
location.obj_oid fkcpir_allocation_location_oid
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_authorization locations varchar 2147483647  √  null
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 varchar 2147483647  √  null
task main_contact_oid int8 19  √  null
wco_group maintenance_contract_notes varchar 2147483647  √  null
wco_group maintenance_contract_number varchar 2147483647  √  null
resource manufacturer varchar 2147483647  √  null
resource_ext manufacturer varchar 2147483647  √  null
resource max_quantity int4 10  √  null
subscription_notification message varchar 2147483647  √  null
organization messaging_from_address varchar 2147483647  √  null
resource metaclass varchar 2147483647
resource_ext metaclass varchar 2147483647  √  null
resource model varchar 2147483647  √  null
resource_ext model varchar 2147483647  √  null
group_member modified timestamp 29,6  √  null
invoice modified timestamp 29,6  √  null
invoice_line modified timestamp 29,6  √  null
person modified timestamp 29,6  √  null
resource modified timestamp 29,6  √  null
resource_type modified timestamp 29,6  √  null
wco_group modified timestamp 29,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
department name varchar 2147483647
group_ext name varchar 2147483647  √  null
location name varchar 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
service 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
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
notification_channel notif_address varchar 2147483647  √  null
notification_channel notif_method varchar 2147483647  √  null
account_code obj_oid int8 19
allocation_building_pass 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
bibliographic_record_configuration obj_oid int8 19
bibliographic_record_ext obj_oid serial 10  √  nextval('bibliographic_record_ext_obj_oid_seq'::regclass)
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
department_code 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 obj_oid int8 19
hold obj_oid int8 19
holding obj_oid int8 19
import_session obj_oid int8 19
integration_log obj_oid int8 19
integration_proc 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
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
notification_channel obj_oid int8 19  √  null
organization_credit_card_type obj_oid int8 19
person_ext obj_oid serial 10  √  nextval('person_ext_obj_oid_seq'::regclass)
person_location_signature obj_oid int8 19
person_role obj_oid int8 19
pir_item obj_oid int8 19
pir_person_location obj_oid int8 19
pir_request_log obj_oid int8 19
pq_account_preference obj_oid int8 19
pq_invoice obj_oid int8 19
pq_invoice_line obj_oid int8 19
pq_organization_additional_contact obj_oid int8 19
project_layout obj_oid int8 19
resource_controller obj_oid int8 19
resource_ext obj_oid serial 10  √  nextval('resource_ext_obj_oid_seq'::regclass)
resource_schedule obj_oid int8 19
resource_sleep_queue obj_oid int8 19  √  null
resource_type_ext obj_oid serial 10  √  nextval('resource_type_ext_obj_oid_seq'::regclass)
resource_type_fallback obj_oid int8 19
resource_wake_queue obj_oid int8 19  √  null
rrt_bundle obj_oid int8 19
service obj_oid int8 19
subscription_contact obj_oid int8 19
subscription_notification obj_oid int8 19
task_group obj_oid int8 19
task_person obj_oid int8 19
task_resource obj_oid int8 19
task_resource_type 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_authorization 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 timestamp 29,6  √  null
resource_type open_group_oid int8 19  √  null
wco_group.obj_oid fkcresource_type_open_group_oid
dat_organization org_oid int8 19
organization.obj_oid fkcdat_organization_oid
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
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
wco_authorization organization int8 19  √  null
organization.obj_oid fkauth_org
hold organization_oid int8 19  √  null
organization.obj_oid fkchold_organization_oid
person organization_oid int8 19  √  null
pq_organization_additional_contact 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
bibliographic_record origin varchar 2147483647  √  null
bibliographic_record_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
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
task parent_oid int8 19  √  null
task.obj_oid fktask_parent_oid
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 varchar 2147483647  √  null
circulation_policy patron_class varchar 2147483647  √  null
person patron_class varchar 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_allocation patron_oid int8 19  √  null
person.obj_oid fkcpir_allocation_patron_oid
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 varchar 2147483647  √  null
allocation payment_type varchar 2147483647  √  null
bibliographic_record performers varchar 2147483647  √  null
bibliographic_record_configuration performers bool 1  √  null
bibliographic_record_ext performers varchar 2147483647  √  null
wco_group period varchar 2147483647  √  null
wco_authorization person int8 19  √  null
person.obj_oid fkauth_person
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
freelancer_person_location person_oid int8 19  √  null
person.obj_oid fkcfreelancer_person_location_person_oid
group_authorization person_oid int8 19
group_member.person_oid authorization_group_fkeys
person.obj_oid group_authorization_person_oid_fkey
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
pq_organization_additional_contact person_oid int8 19  √  null
subscription person_oid int8 19
person.obj_oid fksubscription_person_oid
task_person person_oid int8 19  √  null
person person_type varchar 2147483647  √  null
wco_group phone varchar 2147483647  √  null
location pickup_default varchar 2147483647 'WILL-CALL'::character varying
allocation pickup_instructions varchar 2147483647  √  null
calendar_allocation_fields pickup_instructions bool 1  √  null
allocation pickup_option varchar 2147483647  √  null
calendar_allocation_fields pickup_option bool 1  √  null
location_pir_pickup_option pickup_option varchar 2147483647  √  null
pir_allocation pickup_option varchar 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
pir_item pir_allocation_oid int8 19  √  null
pir_allocation.obj_oid fkcpir_item_pir_alloc_oid
location pir_media_cc_query bool 1  √  null
location pir_mode varchar 2147483647  √  'BOTH'::character varying
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 varchar 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
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 varchar 2147483647  √  null
bibliographic_record_configuration producer bool 1  √  null
bibliographic_record_ext producer varchar 2147483647  √  null
bibliographic_record program_type varchar 2147483647  √  null
bibliographic_record_configuration program_type bool 1  √  null
bibliographic_record_ext program_type varchar 2147483647  √  null
pq_invoice project int8 19  √  null
project_layout project_data varchar 2147483647  √  null
wco_application ps_accepted_terms varchar 2147483647  √  null
bibliographic_record publication_year int8 19  √  null
bibliographic_record_configuration publication_year bool 1  √  null
bibliographic_record_ext publication_year varchar 2147483647  √  null
bibliographic_record publisher varchar 2147483647  √  null
bibliographic_record_configuration publisher bool 1  √  null
bibliographic_record_ext publisher varchar 2147483647  √  null
resource purchase_date timestamp 29,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
pq_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 timestamp 29,6  √  null
resource_schedule real_end_time timestamp 29,6  √  null
invoice real_payee int8 19  √  null
person.obj_oid fkcinvoice_real_payee
index_entry referenced_class varchar 2147483647
index_entry referenced_oid int8 19
index_entry referenced_slot varchar 2147483647
group_ext registration_code varchar 2147483647  √  null
allocation_task related_types varchar 2147483647  √  null
allocation_person relation varchar 2147483647  √  null
bibliographic_record_configuration relations bool 1  √  null
ticket remedy_type varchar 2147483647  √  null
allocation renewal_count int8 19  √  null
ticket repair_cost int8 19  √  null
ticket repair_cost_labor int8 19  √  null
ticket repair_cost_note varchar 2147483647  √  null
ticket repair_cost_parts int8 19  √  null
ticket repair_price int8 19  √  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 timestamp 29,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 timestamp 29,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
ticket resolution varchar 2147483647  √  null
allocation_building_pass resource_oid int8 19  √  null
resource.obj_oid fkcalloc_building_pass_resource_oid
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
pir_item resource_oid int8 19  √  null
resource.obj_oid fkcpir_item_resource_oid
resource_child resource_oid int8 19  √  null
resource_parent resource_oid int8 19  √  null
task_resource 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_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
holding_ext 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 varchar 2147483647 'WILL-RETURN'::character varying
allocation return_option varchar 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
task_group role_oid int8 19  √  null
task_person role_oid int8 19  √  null
resource roles varchar 2147483647  √  null
wco_authorization roles varchar 2147483647  √  null
location room varchar 2147483647  √  null
resource room_number varchar 2147483647  √  null
resource_ext room_number varchar 2147483647  √  null
allocation_building_pass rtype_oid int8 19  √  null
resource_type.obj_oid fkcalloc_building_pass_rtype_oid
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
task_resource_type rtype_oid int8 19  √  null
turndown rtype_oid int8 19  √  null
allocation_group rule_oid int8 19  √  null
allocation_repeat_rule.obj_oid fkcalloc_group_rule_oid
integration_proc run_function varchar 2147483647  √  null
integration_proc run_interval varchar 2147483647  √  null
bibliographic_record run_time int8 19  √  null
bibliographic_record_configuration run_time bool 1  √  null
bibliographic_record_ext run_time varchar 2147483647  √  null
integration_proc run_time varchar 2147483647  √  null
location_schedule schedule_end timestamp 29,6  √  null
location_schedule schedule_length int4 10  √  null
location_schedule schedule_name varchar 2147483647  √  null
location_schedule schedule_start timestamp 29,6  √  null
location_schedule schedule_type varchar 2147483647
task scheduled_end_time timestamp 29,6  √  null
task scheduled_length varchar 2147483647  √  null
resource_schedule scheduled_resource_oid int8 19
resource.obj_oid resource_schedule_scheduled_resource_oid_fkey
task scheduled_start_time timestamp 29,6  √  null
location scheduler_type varchar 2147483647  √  null
wco_application schema_version int8 19  √  null
wco_response_log seconds_used float8 17,17  √  null
organization semester_end timestamp 29,6  √  null
organization semester_start timestamp 29,6  √  null
mail_event send_time timestamp 29,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 varchar 2147483647  √  null
bibliographic_record_configuration series_title bool 1  √  null
bibliographic_record_ext series_title varchar 2147483647  √  null
bibliographic_record series_volume_number varchar 2147483647  √  null
bibliographic_record_configuration series_volume_number bool 1  √  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 varchar 2147483647  √  null
holding shelf_location varchar 2147483647  √  null
holding_ext 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
pq_invoice_line sort_position int8 19  √  null
bibliographic_record sound varchar 2147483647  √  null
bibliographic_record_configuration sound bool 1  √  null
bibliographic_record_ext sound varchar 2147483647  √  null
bibliographic_record source varchar 2147483647  √  null
bibliographic_record_configuration source bool 1  √  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
default_allocation_times start_application varchar 2147483647  √  null
group_authorization start_date timestamp 29,6  √  null
group_ext start_date varchar 2147483647  √  null
wco_group start_date timestamp 29,6  √  null
allocation start_time timestamp 29,6  √  null
allocation_repeat_rule start_time timestamp 29,6  √  null
import_session start_time timestamp 29,6  √  null
integration_log start_time timestamp 29,6  √  null
pir_allocation start_time timestamp 29,6  √  null
resource_schedule start_time timestamp 29,6  √  null
wco_task_log start_time timestamp 29,6  √  null
location_schedule_node start_time_minutes int4 10  √  null
default_allocation_times start_tod_minutes int4 10  √  null
task started_p bool 1  √  null
department state varchar 2147483647  √  null
organization state varchar 2147483647  √  null
person state varchar 2147483647  √  null
person_ext state varchar 2147483647  √  null
ticket state varchar 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 varchar 2147483647
person status varchar 2147483647  √  null
person_ext status varchar 2147483647  √  null
wco_response_log status int4 10  √  null
import_session step varchar 2147483647  √  null
bibliographic_record_configuration stored bool 1  √  null
department 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
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
task_parent_tcm sub int8 19  √  null
rrt_bundle sub_rtype_oid int8 19
bibliographic_record subject varchar 2147483647  √  null
bibliographic_record_configuration subject bool 1  √  null
bibliographic_record_ext subject varchar 2147483647  √  null
notification_channel subscription_oid int8 19  √  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 varchar 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
task_parent_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
project_layout task_oid int8 19  √  null
task_group task_oid int8 19  √  null
task_person task_oid int8 19  √  null
task_resource task_oid int8 19  √  null
task_resource_type task_oid int8 19  √  null
task task_status varchar 2147483647
allocation_task task_time timestamp 29,6  √  null
allocation_task task_type varchar 2147483647  √  null
invoice_line tax int8 19  √  null
invoice_line_tax_rate tax_amount int8 19  √  null
department 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
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
location telephone varchar 2147483647  √  null
person telephone varchar 2147483647  √  null
person_ext 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 varchar 2147483647  √  null
allocation_log time timestamp 29,6  √  null
subscription_notification time timestamp 29,6  √  null
task time_log int8 19  √  null
pir_request_log time_stamp timestamp 29,6  √  null
wco_log time_stamp timestamp 29,6  √  null
wco_request_log time_stamp timestamp 29,6  √  null
wco_response_log time_stamp timestamp 29,6  √  null
location timeline_granularity int8 19  √  null
location timeline_zoom_factor int8 19  √  null
bibliographic_record title varchar 2147483647  √  null
bibliographic_record_ext title varchar 2147483647  √  null
person title varchar 2147483647  √  null
calendar_authentication token varchar 2147483647  √  null
allocation_log type varchar 2147483647  √  null
allocation_reminder_interval type varchar 2147483647
allocation_repeat_rule type varchar 2147483647  √  null
coalesced_deliver_to_v type text 2147483647  √  null
group_ext type varchar 2147483647  √  null
invoice_line type varchar 2147483647  √  null
resource_schedule type varchar 2147483647
ticket_log type varchar 2147483647  √  null
wco_group type varchar 2147483647  √  null
invoice type_of_payment varchar 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 varchar 2147483647  √  null
wco_request_log ui_current_allocation_oid int8 19  √  null
service unit interval 49,6  √  null
pq_invoice_line units varchar 2147483647  √  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
task updated_at timestamp 29,6  √  null
file_attachment upload_person_oid int8 19
person.obj_oid fkfile_attachment_upload_person_oid
file_attachment upload_time timestamp 29,6
holding_ext url varchar 2147483647  √  null
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
pq_account_preference user_oid int8 19  √  null
person userid varchar 2147483647  √  null
person_ext userid varchar 2147483647  √  null
resource_schedule uuid varchar 2147483647
index_entry value varchar 2147483647  √  null
resource value int8 19  √  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
pir_allocation version int8 19  √  null
planq_version version int8 19
wco_version version int8 19
wco_http_event_log view_allocation_oid int8 19  √  null
wco_request_log view_allocation_oid int8 19  √  null
bibliographic_record_configuration view_database bool 1  √  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
import_session what varchar 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
resource obj_oid int8 19
allocation.deliver_to_oid fkcalloc_deliver_to_oid
allocation_building_pass.resource_oid fkcalloc_building_pass_resource_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
pir_item.resource_oid fkcpir_item_resource_oid
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
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
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_allocation.patron_oid fkcpir_allocation_patron_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
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_authorization.person fkauth_person
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
location obj_oid int8 19
allocation.location_oid fkcalloc_location_oid
allocation_reminder_interval.location_oid fkcallocation_reminder_interval_location
calendar_allocation_fields.location_oid calendar_allocation_fields_location_oid_fkey
dat_location.location_oid fkcdat_location_oid
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_allocation.location_oid fkcpir_allocation_location_oid
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
allocation obj_oid int8 19
allocation_building_pass.allocation_oid allocation_building_pass_allocation_oid_fkey
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_allocation.allocation_oid fkcpir_allocation_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
resource_type obj_oid int8 19
allocation_building_pass.rtype_oid fkcalloc_building_pass_rtype_oid
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
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
bibliographic_record obj_oid int8 19
bibliographic_record_helix.bibliographic_record_oid fkbiblio_record_oid
holding.bibliographic_record_oid fkholding_bibliographic_record
default_allocation_times obj_oid int4 10
dat_location.dat_oid fkcdat_oid
dat_organization.dat_oid fkcdat_oid
organization obj_oid int8 19
dat_organization.org_oid fkcdat_organization_oid
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
tax_rate.organization_oid fk_taxrates_organization_oid
wco_authorization.organization fkauth_org
wco_group.organization_oid fkcwco_group_organization_oid
wco_log.org_oid fkcwco_log_org_oid
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
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
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
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
pir_allocation obj_oid int8 19
pir_item.pir_allocation_oid fkcpir_item_pir_alloc_oid
subscription obj_oid int8 19
subscription_contact.subscription_oid fksubscription_notification_subscription
subscription_notification.subscription_oid fksubscription_notification_subscription
task obj_oid int8 19
task.depends_on fktask_depends_on_oid
task.parent_oid fktask_parent_oid
ticket obj_oid int8 19
ticket_log.ticket_oid fkcticket_log_ticket_oid