SchemaSpy Analysis of webco_4.3.0.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Tue Jun 21 07:33 CDT 2016
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

webco_4.3.0.public contains 1032 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Children Parents Comments
account_code code varchar 2147483647
account_code deleted bool 1  √  false
account_code department_oid int8 19  √  null
department.obj_oid fkcdepartment_oid
account_code note varchar 2147483647  √  null
account_code obj_oid int8 19
account_code origin varchar 2147483647
account_code taxable bool 1  √  null
account_code_ext code varchar 2147483647  √  null
account_code_ext csv_line_number int4 10  √  null
account_code_ext deleted varchar 2147483647  √  null
account_code_ext department_name varchar 2147483647  √  null
account_code_ext note varchar 2147483647  √  null
account_code_ext obj_oid int8 19
account_code_ext origin varchar 2147483647  √  null
account_code_ext taxable 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
agreement_form_config description varchar 2147483647  √  null
agreement_form_config location_oid int8 19  √  null
location.obj_oid agreement_form_config_location_oid
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
agreement_form_config name varchar 2147483647 'Agreement Form'::character varying
agreement_form_config obj_oid int8 19
allocation account_code varchar 2147483647  √  null
allocation agent_oid int8 19  √  1
person.obj_oid fkcalloc_agent_oid
allocation approved bool 1  √  null
allocation auto_circulate bool 1  √  null
allocation billing_type wcof_tag 2147483647  √  null
allocation charge_duration interval 49,6  √  null
allocation contact_name_string varchar 2147483647  √  null
allocation contact_person int8 19  √  null
person.obj_oid fkcalloc_contact_person
allocation contact_phone_string varchar 2147483647  √  null
allocation creation_note varchar 2147483647  √  null
allocation creation_time timestamptz 35,6  √  null
allocation credit_card_type varchar 2147483647  √  null
allocation deliver_to_oid int8 19  √  null
resource.obj_oid fkcalloc_deliver_to_oid
allocation deliver_to_string varchar 2147483647  √  null
allocation delivery_type wcof_tag 2147483647  √  null
allocation effective_end_time timestamptz 35,6  √  null
allocation end_time timestamptz 35,6  √  null
allocation event_description varchar 2147483647  √  null
allocation expire_time timestamptz 35,6  √  null
allocation id varchar 2147483647  √  null
allocation is_show bool 1  √  null
allocation last_renewal timestamptz 35,6  √  null
allocation location_oid int8 19  √  null
location.obj_oid fkcalloc_location_oid
allocation nonexpiring bool 1  √  null
allocation note varchar 2147483647  √  null
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_item_building_pass.allocation_oid allocation_item_building_pass_allocation_oid_fkey
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
resource_schedule.allocation_oid fkcresource_schedule_alloc_oid
turndown.allocation_oid turndown_allocation_oid_fkey
allocation original_agent_oid int8 19  √  null
person.obj_oid fkallocation_original_agent_oid
allocation patron_class_oid int8 19  √  null
patron_class.obj_oid fkcpatron_class_oid
allocation patron_oid int8 19  √  null
person.obj_oid fkcalloc_patron_oid
allocation payee_oid int8 19  √  null
person.obj_oid fkcalloc_payee_oid
allocation paying_department_oid int8 19  √  null
department.obj_oid fkcalloc_paying_department_oid
allocation payment_type wcof_tag 2147483647  √  null
allocation pickup_instructions varchar 2147483647  √  null
allocation pickup_option wcof_tag 2147483647  √  null
allocation po_number varchar 2147483647  √  null
allocation project_code varchar 2147483647  √  null
allocation real_end_time timestamptz 35,6  √  null
allocation real_start_time timestamptz 35,6  √  null
allocation reference_id varchar 2147483647  √  null
allocation renewal_count int8 19  √  null
allocation return_option wcof_tag 2147483647  √  null
allocation start_time timestamptz 35,6  √  null
allocation use_charge_duration bool 1  √  null
allocation_freelancer allocation_oid int8 19
allocation.obj_oid fkcallocation_freelancer_allocation_oid
allocation_freelancer availability wcof_tag 2147483647
allocation_freelancer hash varchar 2147483647
allocation_freelancer last_sent_mail wcof_tag 2147483647  √  null
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_freelancer person_oid int8 19
person.obj_oid fkcallocation_freelancer_person_oid
allocation_freelancer_assigned allocation_freelancer_oid int8 19
allocation_freelancer.obj_oid fkallocation_freelancer_assigned_af_oid
allocation_freelancer_assigned obj_oid int8 19
allocation_freelancer_assigned role_oid int8 19
role.obj_oid fkcallocation_freelancer_role_oid
allocation_freelancer_role allocation_freelancer_oid int8 19
allocation_freelancer.obj_oid fkallocation_freelancer_role_af_oid
allocation_freelancer_role obj_oid int8 19
allocation_freelancer_role role_oid int8 19
role.obj_oid fkcallocation_freelancer_role_oid
allocation_group allocation_oid int8 19
allocation.obj_oid allocation_group_allocation_oid_fkey
allocation_group obj_oid int8 19
allocation_group rule_oid int8 19  √  null
allocation_repeat_rule.obj_oid fkcalloc_group_rule_oid
allocation_group seq_no int8 19  √  null
allocation_group source_allocation_oid int8 19  √  null
allocation.obj_oid fkcalloc_group_src_alloc_oid
allocation_item_building_pass allocation_oid int8 19
allocation.obj_oid allocation_item_building_pass_allocation_oid_fkey
allocation_item_building_pass explicit bool 1  √  null
allocation_item_building_pass granted bool 1  √  null
allocation_item_building_pass obj_oid int8 19
allocation_item_building_pass uuid uuid 2147483647
allocation_log agent int8 19  √  null
allocation_log allocation_oid int8 19  √  null
allocation.obj_oid fkcalloc_log_alloc_oid
allocation_log login_agent int8 19  √  null
allocation_log obj_oid int8 19
allocation_log text varchar 2147483647  √  null
allocation_log time timestamptz 35,6  √  null
allocation_log type wcof_tag 2147483647  √  null
allocation_person allocation_oid int8 19
allocation.obj_oid allocation_person_allocation_oid_fkey
allocation_person obj_oid int8 19
allocation_person person_oid int8 19  √  null
person.obj_oid fkcalloc_person_person_oid
allocation_person relation wcof_tag 2147483647  √  null
allocation_reminder_interval duration interval 49,6
allocation_reminder_interval location_oid int8 19
location.obj_oid fkcallocation_reminder_interval_location
allocation_reminder_interval obj_oid int8 19
mail_event.allocation_reminder_interval_oid fkmail_event_alloc_reminder_interval_oid
allocation_reminder_interval type wcof_tag 2147483647
allocation_repeat_rule allocation_oid int8 19
allocation.obj_oid allocation_repeat_rule_allocation_oid_fkey
allocation_repeat_rule end_time timestamptz 35,6  √  null
allocation_repeat_rule obj_oid int8 19
allocation_group.rule_oid fkcalloc_group_rule_oid
allocation_repeat_rule start_time timestamptz 35,6  √  null
allocation_repeat_rule type wcof_tag 2147483647  √  null
allocation_route allocation_oid int8 19
allocation.obj_oid allocation_route_allocation_oid_fkey
allocation_route is_automatic bool 1  √  null
allocation_route is_record bool 1  √  null
allocation_route obj_oid int8 19
allocation_route sink_oid int8 19
resource.obj_oid allocation_route_sink_oid_fkey
allocation_route source_oid int8 19
resource.obj_oid allocation_route_source_oid_fkey
allocation_route_message allocation_oid int8 19
allocation.obj_oid allocation_route_message_allocation_oid_fkey
allocation_route_message obj_oid int8 19
allocation_route_message text varchar 2147483647  √  null
allocation_staffing allocation_oid int8 19
allocation.obj_oid fkallocation_staffing_allocation_oid
allocation_staffing assigned_staff int4 10
allocation_staffing filled bool 1  √  null
allocation_staffing obj_oid int8 19
allocation_staffing required_staff int4 10
allocation_staffing role_oid int8 19
role.obj_oid fkallocation_staffing_role_oid
allocation_task allocation_oid int8 19
allocation.obj_oid allocation_task_allocation_oid_fkey
allocation_task obj_oid int8 19
allocation_task related_types varchar 2147483647  √  null
allocation_task task_time timestamptz 35,6  √  null
allocation_task task_type wcof_tag 2147483647  √  null
authentication hash varchar 2147483647  √  null
authentication obj_oid int8 19
person.obj_oid fkcauthentication_obj_oid
authentication pin_hash varchar 2147483647  √  null
authentication salt varchar 2147483647  √  null
authset obj_oid int4 10
authset_authorization.authset_oid fkauthset_authorization_authset_oid
authset_location.authset_oid fkauthset_location_authset_oid
authset operator_role_oid int4 10  √  null
operator_role.obj_oid fkauthset_role_oid
authset organization_oid int4 10
organization.obj_oid fkauthset_organization_oid
authset person_oid int4 10
person.obj_oid fkauthset_person_oid
authset_authorization authorization_oid int4 10
operator_authorization.obj_oid fkauthset_authorization_authorization_oid
authset_authorization authset_oid int4 10
authset.obj_oid fkauthset_authorization_authset_oid
authset_authorization obj_oid int4 10
authset_location authset_oid int4 10
authset.obj_oid fkauthset_location_authset_oid
authset_location location_oid int4 10
location.obj_oid fkauthset_location_location_oid
authset_location obj_oid int4 10
bibliographic_record alternative_title wcof_collated_string 2147483647  √  null
bibliographic_record archive_catalog_number varchar 2147483647  √  null
bibliographic_record archive_date timestamptz 35,6  √  null
bibliographic_record author wcof_collated_string_list 2147483647  √  null
bibliographic_record captions wcof_tag 2147483647  √  null
bibliographic_record color varchar 2147483647  √  null
bibliographic_record contributor wcof_collated_string_list 2147483647  √  null
bibliographic_record country varchar 2147483647  √  null
bibliographic_record course varchar 2147483647  √  null
bibliographic_record description varchar 2147483647  √  null
bibliographic_record digital_catalog_number varchar 2147483647  √  null
bibliographic_record digitized bool 1  √  null
bibliographic_record director wcof_collated_string 2147483647  √  null
bibliographic_record edition varchar 2147483647  √  null
bibliographic_record era varchar 2147483647 'AD'::character varying
bibliographic_record format varchar 2147483647  √  null
bibliographic_record genre varchar 2147483647  √  null
bibliographic_record identifier varchar 2147483647
bibliographic_record isbn wcof_isbn_number 2147483647  √  null
bibliographic_record language varchar 2147483647  √  null
bibliographic_record loc_control_number varchar 2147483647  √  null
bibliographic_record more_info varchar 2147483647  √  null
bibliographic_record obj_oid int8 19
bibliographic_record_helix.bibliographic_record_oid fkbiblio_record_oid
holding.bibliographic_record_oid fkholding_bibliographic_record
bibliographic_record origin varchar 2147483647
bibliographic_record performers wcof_collated_string_list 2147483647  √  null
bibliographic_record producer wcof_collated_string 2147483647  √  null
bibliographic_record program_type varchar 2147483647  √  null
bibliographic_record publication_year int8 19  √  null
bibliographic_record publisher varchar 2147483647  √  null
bibliographic_record run_time int8 19  √  null
bibliographic_record series_title wcof_collated_string 2147483647  √  null
bibliographic_record series_volume_number varchar 2147483647  √  null
bibliographic_record sound varchar 2147483647  √  null
bibliographic_record source varchar 2147483647  √  null
bibliographic_record subject _varchar 2147483647 ARRAY[]::character varying[]
bibliographic_record supporting_documentation bool 1  √  null
bibliographic_record system wcof_tag 2147483647  √  null
bibliographic_record title wcof_collated_string 2147483647  √  null
bibliographic_record zone int4 10  √  null
bibliographic_record_ext alternative_title varchar 2147483647  √  null
bibliographic_record_ext archive_catalog_number varchar 2147483647  √  null
bibliographic_record_ext archive_date varchar 2147483647  √  null
bibliographic_record_ext author varchar 2147483647  √  null
bibliographic_record_ext captions varchar 2147483647  √  null
bibliographic_record_ext color varchar 2147483647  √  null
bibliographic_record_ext contributor varchar 2147483647  √  null
bibliographic_record_ext country varchar 2147483647  √  null
bibliographic_record_ext course varchar 2147483647  √  null
bibliographic_record_ext csv_line_number int4 10  √  null
bibliographic_record_ext description varchar 2147483647  √  null
bibliographic_record_ext digital_catalog_number varchar 2147483647  √  null
bibliographic_record_ext digitized varchar 2147483647  √  null
bibliographic_record_ext director varchar 2147483647  √  null
bibliographic_record_ext edition varchar 2147483647  √  null
bibliographic_record_ext era varchar 2147483647  √  null
bibliographic_record_ext format varchar 2147483647  √  null
bibliographic_record_ext genre varchar 2147483647  √  null
bibliographic_record_ext identifier varchar 2147483647  √  null
bibliographic_record_ext isbn varchar 2147483647  √  null
bibliographic_record_ext language varchar 2147483647  √  null
bibliographic_record_ext loc_control_number varchar 2147483647  √  null
bibliographic_record_ext more_info varchar 2147483647  √  null
bibliographic_record_ext obj_oid int8 19
bibliographic_record_ext origin varchar 2147483647  √  null
bibliographic_record_ext performers varchar 2147483647  √  null
bibliographic_record_ext producer varchar 2147483647  √  null
bibliographic_record_ext program_type varchar 2147483647  √  null
bibliographic_record_ext publication_year varchar 2147483647  √  null
bibliographic_record_ext publisher varchar 2147483647  √  null
bibliographic_record_ext run_time varchar 2147483647  √  null
bibliographic_record_ext series_title varchar 2147483647  √  null
bibliographic_record_ext series_volume_number varchar 2147483647  √  null
bibliographic_record_ext sound varchar 2147483647  √  null
bibliographic_record_ext source varchar 2147483647  √  null
bibliographic_record_ext subject varchar 2147483647  √  null
bibliographic_record_ext supporting_documentation varchar 2147483647  √  null
bibliographic_record_ext system varchar 2147483647  √  null
bibliographic_record_ext title varchar 2147483647  √  null
bibliographic_record_ext zone varchar 2147483647  √  null
bibliographic_record_helix bibliographic_record_oid int8 19  √  null
bibliographic_record.obj_oid fkbiblio_record_oid
bibliographic_record_helix helix_content_key varchar 2147483647  √  null
bibliographic_record_helix helix_guid varchar 2147483647  √  null
bibliographic_record_helix obj_oid int8 19
bibliographic_record_helix_ext helix_content_key varchar 2147483647  √  null
bibliographic_record_helix_ext helix_guid varchar 2147483647  √  null
bibliographic_record_helix_ext helix_path varchar 2147483647  √  null
calendar_allocation_fields deliver_to bool 1  √  null
calendar_allocation_fields delivery_people bool 1  √  null
calendar_allocation_fields event_description bool 1  √  null
calendar_allocation_fields freelancers bool 1  √  null
calendar_allocation_fields id bool 1  √  null
calendar_allocation_fields is_show bool 1  √  null
calendar_allocation_fields location_oid int8 19  √  null
location.obj_oid calendar_allocation_fields_location_oid_fkey
calendar_allocation_fields note bool 1  √  null
calendar_allocation_fields obj_oid int8 19
calendar_allocation_fields patron_name bool 1  √  null
calendar_allocation_fields pickup_instructions bool 1  √  null
calendar_allocation_fields pickup_option bool 1  √  null
calendar_allocation_fields pickup_people bool 1  √  null
calendar_allocation_fields resource_types bool 1  √  null
calendar_allocation_fields resources bool 1  √  null
calendar_allocation_fields return_option bool 1  √  null
calendar_allocation_fields roles bool 1  √  null
calendar_authentication auth_type varchar 2147483647
calendar_authentication obj_oid int8 19
calendar_authentication person_oid int4 10
calendar_authentication token varchar 2147483647  √  null
circulation_policy obj_oid int8 19
circulation_policy patron_class_oid int8 19
patron_class.obj_oid fkpatron_class_oid
circulation_policy policy_class wcof_tag 2147483647  √  null
circulation_policy policy_object_class varchar 2147483647  √  null
circulation_policy policy_object_oid int8 19  √  null
circulation_policy policy_value varchar 2147483647  √  null
coalesced_deliver_to_v allocation_oid int8 19  √  null
coalesced_deliver_to_v deliver_to varchar 2147483647  √  null
coalesced_deliver_to_v type text 2147483647  √  null
department billing_contact_oid int8 19  √  null
person.obj_oid fkcdepartment_billing_contact_oid
department city varchar 2147483647  √  null
department country varchar 2147483647  √  null
department deleted bool 1  √  null
department email varchar 2147483647  √  null
department fax varchar 2147483647  √  null
department name varchar 2147483647
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
department origin varchar 2147483647
department postal_code varchar 2147483647  √  null
department state varchar 2147483647  √  null
department street varchar 2147483647  √  null
department street2 varchar 2147483647  √  null
department tax_exempt_number varchar 2147483647  √  null
department telephone varchar 2147483647  √  null
department_code code varchar 2147483647
department_code department_oid int8 19  √  null
department.obj_oid fkcdepartment_code_department_oid
department_code note varchar 2147483647  √  null
department_code obj_oid int8 19
department_ext billing_contact varchar 2147483647  √  null
department_ext city varchar 2147483647  √  null
department_ext country varchar 2147483647  √  null
department_ext csv_line_number int4 10  √  null
department_ext deleted varchar 2147483647  √  null
department_ext email varchar 2147483647  √  null
department_ext fax varchar 2147483647  √  null
department_ext name varchar 2147483647  √  null
department_ext obj_oid int8 19
department_ext origin varchar 2147483647  √  null
department_ext postal_code varchar 2147483647  √  null
department_ext state varchar 2147483647  √  null
department_ext street varchar 2147483647  √  null
department_ext street2 varchar 2147483647  √  null
department_ext tax_exempt_number varchar 2147483647  √  null
department_ext telephone varchar 2147483647  √  null
file_attachment attached_to_class varchar 2147483647
file_attachment attached_to_oid int8 19
file_attachment description varchar 2147483647  √  null
file_attachment file_name varchar 2147483647
file_attachment file_size int8 19
file_attachment obj_oid int8 19
file_attachment upload_person_oid int8 19
person.obj_oid fkfile_attachment_upload_person_oid
file_attachment upload_time timestamptz 35,6
freelancer_person_location location_oid int8 19  √  null
location.obj_oid fkcfreelancer_person_location_location_oid
freelancer_person_location obj_oid int8 19
freelancer_person_location person_oid int8 19  √  null
person.obj_oid fkcfreelancer_person_location_person_oid
group_authorization expire timestamptz 35,6  √  null
group_authorization group_oid int8 19
group_member.group_oid authorization_group_fkeys
wco_group.obj_oid group_authorization_group_oid_fkey
group_authorization obj_oid int8 19
group_authorization person_oid int8 19
person.obj_oid group_authorization_person_oid_fkey
group_member.person_oid authorization_group_fkeys
group_authorization rtype_oid int8 19
resource_type.obj_oid group_authorization_rtype_oid_fkey
group_authorization start_date timestamptz 35,6  √  null
group_ext catalog_number varchar 2147483647  √  null
group_ext class_number varchar 2147483647  √  null
group_ext csv_line_number int4 10  √  null
group_ext department varchar 2147483647  √  null
group_ext description varchar 2147483647  √  null
group_ext end_date varchar 2147483647  √  null
group_ext foreignid varchar 2147483647  √  null
group_ext instructor_foreignid varchar 2147483647  √  null
group_ext name varchar 2147483647  √  null
group_ext obj_oid serial 10  √  nextval('group_ext_obj_oid_seq'::regclass)
group_ext organization varchar 2147483647  √  null
group_ext origin varchar 2147483647  √  null
group_ext registration_code varchar 2147483647  √  null
group_ext start_date varchar 2147483647  √  null
group_ext term_foreignid varchar 2147483647  √  null
group_ext type varchar 2147483647  √  null
group_member expire timestamptz 35,6  √  null
group_member group_oid int8 19
group_authorization.group_oid authorization_group_fkeys
wco_group.obj_oid fkcgroup_member_group_oid
group_member modified timestamptz 35,6  √  null
group_member obj_oid int8 19
group_member origin varchar 2147483647
group_member person_oid int8 19
group_authorization.person_oid authorization_group_fkeys
person.obj_oid fkcgroup_member_person_oid
group_member_ext csv_line_number int4 10  √  null
group_member_ext expire varchar 2147483647  √  null
group_member_ext group_foreignid varchar 2147483647  √  null
group_member_ext obj_oid serial 10  √  nextval('group_member_ext_obj_oid_seq'::regclass)
group_member_ext origin varchar 2147483647  √  null
group_member_ext person_foreignid varchar 2147483647  √  null
group_resource_type group_oid int8 19
wco_group.obj_oid group_resource_type_group_oid_fkey
group_resource_type obj_oid int8 19
group_resource_type rtype_oid int8 19
resource_type.obj_oid group_resource_type_rtype_oid_fkey
group_set obj_oid int8 19
group_set_member.group_set_oid group_set_member_group_set_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
group_set_member obj_oid serial 10  √  nextval('group_set_member_obj_oid_seq'::regclass)
hold active bool 1  √  null
hold created timestamptz 35,6  √  null
hold description varchar 2147483647  √  null
hold expires timestamptz 35,6  √  null
hold hold_type varchar 2147483647  √  null
hold invoice_oid int8 19  √  null
invoice.obj_oid fkchold_invoice_oid
hold obj_oid int8 19
hold organization_oid int8 19  √  null
organization.obj_oid fkchold_organization_oid
hold person_oid int8 19  √  null
person.obj_oid fkchold_person_oid
holding bibliographic_record_oid int8 19
bibliographic_record.obj_oid fkholding_bibliographic_record
holding call_number varchar 2147483647  √  null
holding distributor varchar 2147483647  √  null
holding obj_oid int8 19
holding resource_oid int8 19
resource.obj_oid fkholding_resource
holding restrictions varchar 2147483647  √  null
holding shelf_location varchar 2147483647  √  null
import_session files _varchar 2147483647 ARRAY[]::character varying[]
import_session obj_oid int8 19
import_session origin varchar 2147483647  √  null
import_session result int8 19  √  null
import_session start_time timestamptz 35,6  √  null
import_session step wcof_tag 2147483647  √  null
import_session what wcof_tag 2147483647  √  null
integration_log class varchar 2147483647  √  null
integration_log created int8 19  √  null
integration_log deleted int8 19  √  null
integration_log end_time timestamptz 35,6  √  null
integration_log obj_oid int8 19
integration_log start_time timestamptz 35,6  √  null
integration_log status varchar 2147483647  √  null
integration_log updated int8 19  √  null
inventory_event agent_oid int8 19  √  null
person.obj_oid inventory_event_agent_oid_fkey
inventory_event barcode varchar 2147483647  √  null
inventory_event date timestamptz 35,6  √  null
inventory_event obj_oid int8 19
inventory_event resource_oid int8 19  √  null
resource.obj_oid inventory_event_resource_oid_fkey
invoice allocation_oid int8 19  √  null
allocation.obj_oid fkcinvoice_alloc_oid
invoice balance odcl_money 2147483647  √  null
invoice cc_oid int8 19  √  null
location.obj_oid fkcinvoice_cc_oid
invoice class wcof_tag 2147483647  √  null
invoice created_by int8 19  √  1
person.obj_oid fkcinvoice_created_by
invoice creation_date timestamptz 35,6  √  null
invoice credit_card_type varchar 2147483647  √  null
invoice date_paid timestamptz 35,6  √  null
invoice description varchar 2147483647  √  null
invoice due_date timestamptz 35,6  √  null
invoice event_description varchar 2147483647  √  null
invoice hold_date timestamptz 35,6  √  null
invoice invoice_id varchar 2147483647  √  null
invoice invoice_status wcof_tag 2147483647  √  null
invoice modified timestamptz 35,6  √  null
invoice modified_by int8 19  √  null
person.obj_oid fkcinvoice_modified_by
invoice obj_oid int8 19
hold.invoice_oid fkchold_invoice_oid
invoice_line.invoice_oid invoice_line_invoice_oid_fkey
invoice_tax_rate.invoice_oid invoice_tax_rate_invoice_oid_fkey
invoices_pending_export.invoice_oid invoices_pending_export_invoice_oid_fkey
invoice org_oid int8 19  √  null
organization.obj_oid fkcinvoice_org_oid
invoice paying_account varchar 2147483647  √  null
invoice paying_dept_oid int8 19  √  null
department.obj_oid fkcinvoice_paying_dept_oid
invoice payment_rule wcof_tag 2147483647  √  null
invoice person_oid int8 19  √  null
person.obj_oid fkcinvoice_person_oid
invoice po_number varchar 2147483647  √  null
invoice project_code varchar 2147483647  √  null
invoice ready_to_bill bool 1  √  null
invoice real_payee int8 19  √  null
person.obj_oid fkcinvoice_real_payee
invoice reference_id varchar 2147483647  √  null
invoice taxable bool 1  √  null
invoice type_of_payment wcof_tag 2147483647  √  null
invoice_charges balance numeric 131089  √  null
invoice_charges invoice_oid int8 19  √  null
invoice_line amount odcl_money 2147483647  √  null
invoice_line created_by int8 19  √  1
person.obj_oid fkinv_line_created_by
invoice_line creation_date timestamptz 35,6  √  null
invoice_line description varchar 2147483647  √  null
invoice_line invoice_oid int8 19  √  null
invoice.obj_oid invoice_line_invoice_oid_fkey
invoice_line modified timestamptz 35,6  √  null
invoice_line modified_by int8 19  √  1
person.obj_oid fkinv_line_modified_by
invoice_line obj_oid int8 19
invoice_line_tax_rate.invoice_line_oid invoice_line_tax_rate_invoice_line_oid_fkey
invoice_line quantity int8 19  √  null
invoice_line resource_oid int8 19  √  null
resource.obj_oid fkinv_line_res
invoice_line struck bool 1  √  null
invoice_line subtype wcof_tag 2147483647  √  null
invoice_line tax odcl_money 2147483647  √  null
invoice_line type wcof_tag 2147483647  √  null
invoice_line_tax_rate invoice_line_oid int8 19  √  null
invoice_line.obj_oid invoice_line_tax_rate_invoice_line_oid_fkey
invoice_line_tax_rate obj_oid int8 19
invoice_line_tax_rate tax_amount odcl_money 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_payments balance numeric 131089  √  null
invoice_payments invoice_oid int8 19  √  null
invoice_tax_rate invoice_oid int8 19  √  null
invoice.obj_oid invoice_tax_rate_invoice_oid_fkey
invoice_tax_rate obj_oid int8 19
invoice_tax_rate tax_rate_oid int8 19  √  null
tax_rate.obj_oid invoice_tax_rate_tax_rate_oid_fkey
invoices_pending_export invoice_oid int8 19  √  null
invoice.obj_oid invoices_pending_export_invoice_oid_fkey
invoices_pending_export obj_oid int8 19
late_returns late_returns int8 19  √  null
late_returns patron_oid int8 19  √  null
ldap_profile application_dn varchar 2147483647  √  null
ldap_profile application_password varchar 2147483647  √  null
ldap_profile base varchar 2147483647 ''::character varying
ldap_profile description varchar 2147483647  √  null
ldap_profile dn_attribute varchar 2147483647  √  null
ldap_profile dn_prefix varchar 2147483647  √  null
ldap_profile dn_suffix varchar 2147483647  √  null
ldap_profile dsa_host varchar 2147483647 '127.0.0.1'::character varying
ldap_profile dsa_port int4 10 636
ldap_profile lookup_dn bool 1 true
ldap_profile obj_oid int8 19
ldap_rule.ldap_profile_oid ldap_rule_ldap_profile_oid_fkey
ldap_profile search_attribute varchar 2147483647  √  null
ldap_profile text_encoding varchar 2147483647 'utf-8'::character varying
ldap_profile timeout int4 10 5
ldap_profile use_barcode bool 1 false
ldap_profile use_ssl bool 1 true
ldap_rule fail_to_db bool 1 false
ldap_rule ldap_profile_oid int8 19  √  null
ldap_profile.obj_oid ldap_rule_ldap_profile_oid_fkey
ldap_rule obj_oid int8 19
ldap_rule operator bool 1 false
ldap_rule origin varchar 2147483647  √  null
ldap_rule patron_class_oid int8 19  √  null
patron_class.obj_oid ldap_rule_patron_class_oid_fkey
ldap_rule priority int4 10
ldap_rule use_ldap bool 1 true
location address varchar 2147483647  √  null
location agreement_form_grouping wcof_tag 2147483647
location agreement_form_sorting wcof_tag 2147483647
location allocation_mode wcof_tag 2147483647  √  null
location billing_contact_email varchar 2147483647  √  null
location billing_contact_name varchar 2147483647  √  null
location billing_contact_phone varchar 2147483647  √  null
location building varchar 2147483647  √  null
location crestron_host varchar 2147483647  √  null
location crestron_port int8 19  √  null
location custom_agreement_form_oid int8 19  √  null
location day_rollover int4 10
location default_allocation_times wcof_default_allocation_times 2147483647  √  null
location default_delivery_type wcof_tag 2147483647
location default_resource_selector wcof_tag 2147483647  √  null
location description varchar 2147483647  √  null
location email_template_set varchar 2147483647  √  null
location form_date_time_format wcof_tag 2147483647
location locale varchar 2147483647  √  null
location name varchar 2147483647
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
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
resource.location_oid resource_location_oid_fkey
turndown.location_oid turndown_location_oid_fkey
wco_application.default_location_oid fkapp_default_loc_oid
wco_log.loc_oid fkcwco_log_loc_oid
wco_station.location_oid fkcwco_station_location_oid
location org_oid int8 19
organization.obj_oid location_org_oid_fkey
location pickup_default wcof_tag 2147483647
location pir_media_cc_query bool 1  √  null
location pir_mode wcof_tag 2147483647  √  null
location pir_motd varchar 2147483647  √  null
location pir_report_problems bool 1  √  true
location pir_requires_approval bool 1  √  null
location pir_restrict_delivery_locations bool 1  √  null
location pir_session_timeout int4 10 15
location print_queue varchar 2147483647  √  'wco_local'::character varying
location print_template_set varchar 2147483647  √  null
location repeats_in_pir bool 1  √  null
location require_signature_on_file bool 1  √  false
location return_default wcof_tag 2147483647
location room varchar 2147483647  √  null
location telephone varchar 2147483647  √  null
location timeline_granularity int8 19  √  null
location timeline_zoom_factor int8 19  √  null
location timezone varchar 2147483647  √  null
location usage_exclude_closed bool 1  √  null
location_auto_email cancelled_reservation_cc varchar 2147483647  √  null
location_auto_email cancelled_reservation_enabled bool 1  √  null
location_auto_email created_reservation_cc varchar 2147483647  √  null
location_auto_email created_reservation_enabled bool 1  √  null
location_auto_email edited_reservation_cc varchar 2147483647  √  null
location_auto_email edited_reservation_enabled bool 1  √  null
location_auto_email location_oid int8 19  √  null
location.obj_oid fkextlocation_oid
location_auto_email obj_oid int8 19
location_auto_email pickup_reservation_cc varchar 2147483647  √  null
location_auto_email pickup_reservation_enabled bool 1  √  null
location_auto_email return_checkout_cc varchar 2147483647  √  null
location_auto_email return_checkout_completed_only_cc varchar 2147483647  √  null
location_auto_email return_checkout_completed_only_enabled bool 1  √  null
location_auto_email return_checkout_enabled bool 1  √  null
location_auto_email ticket_cc varchar 2147483647  √  null
location_auto_email ticket_enabled bool 1  √  null
location_pir_pickup_option location_oid int8 19  √  null
location.obj_oid location_pir_pickup_option_location_oid_fkey
location_pir_pickup_option obj_oid int8 19
location_pir_pickup_option pickup_option wcof_tag 2147483647  √  null
location_schedule location_oid int4 10  √  null
location.obj_oid fkclocation_schedule_location
location_schedule obj_oid int4 10
location_schedule.parent_oid fkclocation_schedule_parent
location_schedule_node.location_schedule_oid fkclocation_schedule_node_location_schedule
location_schedule parent_oid int4 10  √  null
location_schedule.obj_oid fkclocation_schedule_parent
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
location_schedule_node day_number int4 10
location_schedule_node end_time_minutes int4 10  √  null
location_schedule_node location_schedule_oid int4 10
location_schedule.obj_oid fkclocation_schedule_node_location_schedule
location_schedule_node obj_oid int4 10
location_schedule_node start_time_minutes int4 10  √  null
location_schedule_node status wcof_tag 2147483647
mail_event allocation_oid int8 19  √  null
allocation.obj_oid fkmail_event_alloc_oid
mail_event allocation_reminder_interval_oid int8 19  √  null
allocation_reminder_interval.obj_oid fkmail_event_alloc_reminder_interval_oid
mail_event mail_type wcof_tag 2147483647  √  null
mail_event obj_oid int8 19
mail_event send_time timestamptz 35,6  √  null
operator_authorization name wcof_tag 2147483647
operator_authorization obj_oid serial 10  √  nextval('hibernate_sequence'::regclass)
authset_authorization.authorization_oid fkauthset_authorization_authorization_oid
operator_role name wcof_tag 2147483647
operator_role obj_oid serial 10  √  nextval('hibernate_sequence'::regclass)
authset.operator_role_oid fkauthset_role_oid
organization admin_id int8 19  √  null
person.obj_oid fkcorg_admin_id
organization city varchar 2147483647  √  null
organization constrain_account_codes bool 1  √  null
organization country varchar 2147483647  √  null
organization default_allocation_times wcof_default_allocation_times 2147483647  √  null
organization default_billing_type wcof_tag 2147483647  √  null
organization due_days interval 49,6  √  null
organization fine_account varchar 2147483647  √  null
organization hold_days interval 49,6  √  null
organization honor_external_fines _int4 10 ARRAY[]::integer[]
organization honor_external_holds _int4 10 ARRAY[]::integer[]
organization locale varchar 2147483647  √  null
organization messaging_from_address varchar 2147483647  √  null
organization name varchar 2147483647  √  null
organization obj_oid int8 19
authset.organization_oid fkauthset_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
sched_staffed_location.org_oid sched_staffed_location_org_oid_fkey
tax_rate.organization_oid fk_taxrates_organization_oid
wco_application.default_org_oid fkapp_default_org_oid
wco_group.organization_oid fkcwco_group_organization_oid
wco_log.org_oid fkcwco_log_org_oid
organization postal_code varchar 2147483647  √  null
organization restricted bool 1  √  null
organization semester_end timestamptz 35,6  √  null
organization semester_start timestamptz 35,6  √  null
organization state varchar 2147483647  √  null
organization street varchar 2147483647  √  null
organization street2 varchar 2147483647  √  null
organization suppress_autopayment bool 1  √  null
organization taxable_invoices wcof_tag 2147483647  √  null
organization timezone varchar 2147483647  √  null
organization_credit_card_type name varchar 2147483647  √  null
organization_credit_card_type obj_oid int8 19
patron_class key varchar 2147483647
patron_class name varchar 2147483647
patron_class obj_oid int8 19
allocation.patron_class_oid fkcpatron_class_oid
circulation_policy.patron_class_oid fkpatron_class_oid
ldap_rule.patron_class_oid ldap_rule_patron_class_oid_fkey
person.patron_class_oid fkcpatron_class_oid
patron_class rank int4 10
person academic_career varchar 2147483647  √  null
person academic_level varchar 2147483647  √  null
person barcode varchar 2147483647  √  null
person city varchar 2147483647  √  null
person client_name varchar 2147483647  √  null
person contact_note varchar 2147483647  √  null
person country varchar 2147483647  √  null
person department varchar 2147483647  √  null
person email varchar 2147483647  √  null
person email_local varchar 2147483647  √  null
person expires timestamptz 35,6  √  null
person fax varchar 2147483647  √  null
person first_name varchar 2147483647  √  null
person last_name varchar 2147483647  √  null
person late_returns int8 19  √  null
person modified timestamptz 35,6  √  null
person note varchar 2147483647  √  null
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
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
resource.assigned_person_oid fkcres_person
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
person organization_oid int8 19  √  null
person origin varchar 2147483647
person other_name varchar 2147483647  √  null
person patron_class_oid int8 19
patron_class.obj_oid fkcpatron_class_oid
person person_type varchar 2147483647  √  null
person postal_code varchar 2147483647  √  null
person sortable_name varchar 2147483647  √  null
person state varchar 2147483647  √  null
person status wcof_tag 2147483647  √  null
person street varchar 2147483647  √  null
person street2 varchar 2147483647  √  null
person suppress_email bool 1  √  null
person telephone varchar 2147483647  √  null
person telephone_local varchar 2147483647  √  null
person title varchar 2147483647  √  null
person unused_reservations int8 19  √  null
person userid varchar 2147483647  √  null
person vendor_name varchar 2147483647  √  null
person weekly_max_hours float4 8,8  √  null
person_ext academic_career varchar 2147483647  √  null
person_ext academic_level varchar 2147483647  √  null
person_ext barcode varchar 2147483647  √  null
person_ext city varchar 2147483647  √  null
person_ext contact_note varchar 2147483647  √  null
person_ext country varchar 2147483647  √  null
person_ext csv_line_number int4 10  √  null
person_ext department varchar 2147483647  √  null
person_ext email varchar 2147483647  √  null
person_ext expires varchar 2147483647  √  null
person_ext fax varchar 2147483647  √  null
person_ext first_name varchar 2147483647  √  null
person_ext last_name varchar 2147483647  √  null
person_ext note varchar 2147483647  √  null
person_ext obj_oid int8 19
person_ext origin varchar 2147483647  √  null
person_ext other_name varchar 2147483647  √  null
person_ext password varchar 2147483647  √  null
person_ext patron_class varchar 2147483647  √  null
person_ext postal_code varchar 2147483647  √  null
person_ext state varchar 2147483647  √  null
person_ext status varchar 2147483647  √  null
person_ext street varchar 2147483647  √  null
person_ext street2 varchar 2147483647  √  null
person_ext telephone varchar 2147483647  √  null
person_ext title varchar 2147483647  √  null
person_ext userid varchar 2147483647  √  null
person_location_signature date timestamptz 35,6  √  null
person_location_signature location_oid int8 19  √  null
location.obj_oid person_location_signature_location_oid_fkey
person_location_signature obj_oid int8 19
person_location_signature person_oid int8 19  √  null
person.obj_oid person_location_signature_person_oid_fkey
person_role obj_oid int8 19
person_role person_oid int8 19  √  null
person.obj_oid fkperson_role_person_oid
person_role role_oid int8 19  √  null
role.obj_oid fkperson_role_role_oid
pir_auth_ext academic_level varchar 2147483647  √  null
pir_auth_ext checkout_center varchar 2147483647  √  null
pir_auth_ext csv_line_number int4 10  √  null
pir_auth_ext department varchar 2147483647  √  null
pir_auth_ext group_foreignid varchar 2147483647  √  null
pir_auth_ext obj_oid int8 19
pir_auth_ext origin varchar 2147483647  √  null
pir_auth_ext patron_class varchar 2147483647  √  null
pir_auth_ext patron_foreignid varchar 2147483647  √  null
pir_person_location location_oid int8 19  √  null
location.obj_oid fkcpir_location_location_oid
pir_person_location obj_oid int8 19
pir_person_location person_oid int8 19  √  null
person.obj_oid fkcpir_location_person_oid
resource accessories _varchar 2147483647 ARRAY[]::character varying[]
resource aggregate_value odcl_money 2147483647  √  null
resource asset_tag varchar 2147483647  √  null
resource assigned_person_oid int8 19  √  null
person.obj_oid fkcres_person
resource barcode varchar 2147483647  √  null
resource budget_number varchar 2147483647  √  null
resource capacity int4 10  √  null
resource circulating bool 1  √  null
resource condition_note varchar 2147483647  √  null
resource containing_resource_oid int8 19  √  null
resource.obj_oid fkres_cont_res
resource current_allocation_oid int8 19  √  null
resource deleted bool 1 false
resource description varchar 2147483647  √  null
resource destination bool 1  √  null
resource foreignid varchar 2147483647  √  null
resource hardware_version varchar 2147483647  √  null
resource hostname varchar 2147483647  √  null
resource ip_address varchar 2147483647  √  null
resource label_id varchar 2147483647
resource last_inventoried_date timestamptz 35,6  √  null
resource location_note varchar 2147483647  √  null
resource location_oid int8 19
location.obj_oid resource_location_oid_fkey
resource location_resource_oid int8 19  √  null
resource.obj_oid fkcres_loc_res
resource mac_address varchar 2147483647  √  null
resource manufacturer varchar 2147483647  √  null
resource max_quantity int4 10  √  null
resource metaclass wcof_tag 2147483647
resource model varchar 2147483647  √  null
resource modified timestamptz 35,6  √  null
resource next_allocation_oid int8 19  √  null
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 fkcresource_schedule_scheduled_resource_oid
ticket.resource_oid fkticket_res
wco_group.facility_oid fkcwco_group_facility_oid
resource origin varchar 2147483647
resource previous_allocation_oid int8 19  √  null
resource purchase_date timestamptz 35,6  √  null
resource purchase_note varchar 2147483647  √  null
resource purchase_order varchar 2147483647  √  null
resource replacement_date timestamptz 35,6  √  null
resource roles _varchar 2147483647 ARRAY[]::character varying[]
resource room_number varchar 2147483647  √  null
resource rtype_oid int8 19
resource_type.obj_oid resource_rtype_oid_fkey
resource serial_number varchar 2147483647  √  null
resource software_version varchar 2147483647  √  null
resource unserialized bool 1  √  null
resource url varchar 2147483647  √  null
resource value odcl_money 2147483647  √  null
resource vendor varchar 2147483647  √  null
resource warranty_labor varchar 2147483647  √  null
resource warranty_parts varchar 2147483647  √  null
resource_container_tcm gen int8 19  √  null
resource_container_tcm sub int8 19  √  null
resource_container_tcm super int8 19  √  null
resource_controller can_record bool 1  √  null
resource_controller daily_sleep_time timestamptz 35,6  √  null
resource_controller daily_wake_time timestamptz 35,6  √  null
resource_controller device_id varchar 2147483647  √  null
resource_controller is_sink bool 1  √  null
resource_controller is_source bool 1  √  null
resource_controller last_sleep_time timestamptz 35,6  √  null
resource_controller last_wake_time timestamptz 35,6  √  null
resource_controller obj_oid int8 19
resource_ext accessories varchar 2147483647  √  null
resource_ext asset_tag varchar 2147483647  √  null
resource_ext barcode varchar 2147483647  √  null
resource_ext biblio_id varchar 2147483647  √  null
resource_ext budget_number varchar 2147483647  √  null
resource_ext call_number varchar 2147483647  √  null
resource_ext capacity varchar 2147483647  √  null
resource_ext circulating varchar 2147483647  √  null
resource_ext condition_note varchar 2147483647  √  null
resource_ext container_foreignid varchar 2147483647  √  null
resource_ext csv_line_number int4 10  √  null
resource_ext description varchar 2147483647  √  null
resource_ext destination varchar 2147483647  √  null
resource_ext distributor varchar 2147483647  √  null
resource_ext file_id varchar 2147483647  √  null
resource_ext hardware_version varchar 2147483647  √  null
resource_ext home_location_string varchar 2147483647  √  null
resource_ext hostname varchar 2147483647  √  null
resource_ext inventory_date varchar 2147483647  √  null
resource_ext ip_address varchar 2147483647  √  null
resource_ext label_id varchar 2147483647  √  null
resource_ext location varchar 2147483647  √  null
resource_ext mac_address varchar 2147483647  √  null
resource_ext manufacturer varchar 2147483647  √  null
resource_ext metaclass varchar 2147483647  √  null
resource_ext model varchar 2147483647  √  null
resource_ext obj_oid int8 19
resource_ext origin varchar 2147483647  √  null
resource_ext purchase_date varchar 2147483647  √  null
resource_ext purchase_order varchar 2147483647  √  null
resource_ext replacement_date varchar 2147483647  √  null
resource_ext restrictions varchar 2147483647  √  null
resource_ext room_number varchar 2147483647  √  null
resource_ext rtid varchar 2147483647  √  null
resource_ext serial_number varchar 2147483647  √  null
resource_ext shelf_location varchar 2147483647  √  null
resource_ext software_version varchar 2147483647  √  null
resource_ext unserialized varchar 2147483647  √  null
resource_ext url varchar 2147483647  √  null
resource_ext value varchar 2147483647  √  null
resource_ext vendor varchar 2147483647  √  null
resource_ext warranty_labor varchar 2147483647  √  null
resource_ext warranty_parts varchar 2147483647  √  null
resource_location_tcm gen int8 19  √  null
resource_location_tcm sub int8 19  √  null
resource_location_tcm super int8 19  √  null
resource_parent parent_resource_oid int8 19  √  null
resource_parent resource_oid int8 19  √  null
resource_schedule allocation_oid int8 19  √  null
allocation.obj_oid fkcresource_schedule_alloc_oid
resource_schedule end_time timestamptz 35,6  √  null
resource_schedule event_group uuid 2147483647
resource_schedule obj_oid int8 19
resource_schedule real_end_time timestamptz 35,6  √  null
resource_schedule real_start_time timestamptz 35,6  √  null
resource_schedule requested_rtype_oid int8 19
resource_schedule return_agent_oid int8 19  √  1
person.obj_oid fkcresource_schedule_return_agent_oid
resource_schedule scheduled_by wcof_tag 2147483647
resource_schedule scheduled_resource_oid int8 19  √  null
resource.obj_oid fkcresource_schedule_scheduled_resource_oid
resource_schedule start_time timestamptz 35,6  √  null
resource_schedule type wcof_tag 2147483647
resource_schedule uuid uuid 2147483647
resource_sleep_queue obj_oid int8 19  √  null
resource_type authorized bool 1  √  null
resource_type caption varchar 2147483647  √  null
resource_type deleted bool 1  √  null
resource_type description varchar 2147483647  √  null
resource_type image_url varchar 2147483647  √  null
resource_type modified timestamptz 35,6  √  null
resource_type name varchar 2147483647  √  null
resource_type obj_oid int8 19
group_authorization.rtype_oid group_authorization_rtype_oid_fkey
group_resource_type.rtype_oid group_resource_type_rtype_oid_fkey
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
resource_type open_group_oid int8 19  √  null
wco_group.obj_oid fkcresource_type_open_group_oid
resource_type org_oid int8 19  √  null
organization.obj_oid fkcresource_type_org_oid
resource_type origin varchar 2147483647
resource_type parent_oid int8 19  √  null
resource_type path varchar 2147483647  √  null
resource_type pir_p bool 1  √  true
resource_type rtid varchar 2147483647
resource_type value odcl_money 2147483647  √  null
resource_type_ext authorization_required varchar 2147483647  √  null
resource_type_ext caption varchar 2147483647  √  null
resource_type_ext csv_line_number int4 10  √  null
resource_type_ext description varchar 2147483647  √  null
resource_type_ext image_url varchar 2147483647  √  null
resource_type_ext name varchar 2147483647  √  null
resource_type_ext obj_oid int8 19
resource_type_ext organization varchar 2147483647  √  null
resource_type_ext origin varchar 2147483647  √  null
resource_type_ext parent varchar 2147483647  √  null
resource_type_ext pir_p varchar 2147483647  √  null
resource_type_ext rtid varchar 2147483647  √  null
resource_type_fallback fallback_oid int8 19
resource_type.obj_oid resource_type_fallback_fallback_oid_fkey
resource_type_fallback obj_oid int8 19
resource_type_fallback type_oid int8 19
resource_type.obj_oid resource_type_fallback_type_oid_fkey
resource_wake_queue obj_oid int8 19  √  null
role deleted bool 1  √  false
role location_oid int8 19 1
role name varchar 2147483647  √  null
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
rrt_bundle obj_oid int8 19
rrt_bundle rtype_oid int8 19
rrt_bundle sub_rtype_oid int8 19
rtype_tree_tcm gen int8 19  √  null
rtype_tree_tcm sub int8 19  √  null
rtype_tree_tcm super int8 19  √  null
sched_scheduling_group description varchar 2147483647  √  null
sched_scheduling_group name varchar 2147483647
sched_scheduling_group obj_oid int8 19
sched_scheduling_group_member.scheduling_group_oid sched_scheduling_group_member_scheduling_group_oid_fkey
sched_staff_assignment.scheduling_group_oid staff_assignment_sched_group_oid
sched_staff_assignment.unpublished_scheduling_group_oid staff_assignment_unppublished_sched_group_oid
sched_scheduling_group staffed_location_oid int8 19
sched_staffed_location.obj_oid sched_scheduling_group_staffed_location_oid_fkey
sched_scheduling_group_member obj_oid int8 19
sched_scheduling_group_member scheduling_group_oid int8 19
sched_scheduling_group.obj_oid sched_scheduling_group_member_scheduling_group_oid_fkey
sched_scheduling_group_member staff_oid int8 19
sched_staff.obj_oid sched_scheduling_group_member_staff_oid_fkey
sched_shift deleted bool 1  √  null
sched_shift end_time timestamptz 35,6  √  null
sched_shift name varchar 2147483647  √  null
sched_shift notes varchar 2147483647  √  null
sched_shift obj_oid int8 19
sched_staff_assignment.shift_oid staff_assignment_shift_oid
sched_shift published bool 1  √  null
sched_shift staffed_location_oid int8 19
sched_staffed_location.obj_oid sched_shift_staffed_location_oid_fkey
sched_shift start_time timestamptz 35,6  √  null
sched_shift unpublished_edits bool 1  √  null
sched_shift unpublished_end_time timestamptz 35,6  √  null
sched_shift unpublished_name varchar 2147483647  √  null
sched_shift unpublished_notes varchar 2147483647  √  null
sched_shift unpublished_start_time timestamptz 35,6  √  null
sched_staff manager bool 1  √  null
sched_staff obj_oid int8 19
sched_scheduling_group_member.staff_oid sched_scheduling_group_member_staff_oid_fkey
sched_staff_assignment.staff_oid staff_assignment_staff_oid
sched_staff_assignment.unpublished_staff_oid staff_assignment_unpub_staff_oid
sched_staffing_limit.staff_oid sched_staffing_limit_staff_oid_fkey
sched_staff person_oid int8 19
person.obj_oid sched_staff_person_oid_fkey
sched_staff staffed_location_oid int8 19
sched_staffed_location.obj_oid sched_staff_staffed_location_oid_fkey
sched_staff_assignment deleted bool 1  √  null
sched_staff_assignment obj_oid int8 19
sched_staff_assignment published bool 1  √  null
sched_staff_assignment scheduling_group_oid int8 19  √  null
sched_scheduling_group.obj_oid staff_assignment_sched_group_oid
sched_staff_assignment shift_oid int8 19  √  null
sched_shift.obj_oid staff_assignment_shift_oid
sched_staff_assignment staff_oid int8 19  √  null
sched_staff.obj_oid staff_assignment_staff_oid
sched_staff_assignment unpublished_edits bool 1  √  null
sched_staff_assignment unpublished_scheduling_group_oid int8 19  √  null
sched_scheduling_group.obj_oid staff_assignment_unppublished_sched_group_oid
sched_staff_assignment unpublished_staff_oid int8 19  √  null
sched_staff.obj_oid staff_assignment_unpub_staff_oid
sched_staff_availability end_time timestamptz 35,6  √  null
sched_staff_availability name varchar 2147483647  √  null
sched_staff_availability obj_oid int8 19
sched_staff_availability person_oid int8 19
person.obj_oid sched_staff_availability_person_oid_fkey
sched_staff_availability start_time timestamptz 35,6  √  null
sched_staffed_location address varchar 2147483647  √  null
sched_staffed_location building varchar 2147483647  √  null
sched_staffed_location description varchar 2147483647  √  null
sched_staffed_location name varchar 2147483647
sched_staffed_location obj_oid int8 19
sched_scheduling_group.staffed_location_oid sched_scheduling_group_staffed_location_oid_fkey
sched_shift.staffed_location_oid sched_shift_staffed_location_oid_fkey
sched_staff.staffed_location_oid sched_staff_staffed_location_oid_fkey
sched_staffed_location org_oid int8 19
organization.obj_oid sched_staffed_location_org_oid_fkey
sched_staffed_location room varchar 2147483647  √  null
sched_staffed_location telephone varchar 2147483647  √  null
sched_staffing_limit obj_oid int8 19
sched_staffing_limit staff_oid int8 19
sched_staff.obj_oid sched_staffing_limit_staff_oid_fkey
sched_staffing_limit time_limit int8 19  √  null
sched_staffing_limit type varchar 2147483647  √  null
string_map key varchar 2147483647
string_map value varchar 2147483647
subscription entity_oid int8 19  √  null
subscription entity_type varchar 2147483647  √  null
subscription obj_oid int8 19
subscription_contact.subscription_oid fksubscription_notification_subscription
subscription_notification.subscription_oid fksubscription_notification_subscription
subscription person_oid int8 19
person.obj_oid fksubscription_person_oid
subscription_contact contact_data varchar 2147483647
subscription_contact contact_type wcof_tag 2147483647
subscription_contact obj_oid int8 19
subscription_contact subscription_oid int8 19
subscription.obj_oid fksubscription_notification_subscription
subscription_notification message varchar 2147483647  √  null
subscription_notification obj_oid int8 19
subscription_notification subscription_oid int8 19
subscription.obj_oid fksubscription_notification_subscription
subscription_notification time timestamptz 35,6  √  null
tax_rate active bool 1 true
tax_rate compound bool 1 false
tax_rate name varchar 10
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
tax_rate organization_oid int8 19  √  null
organization.obj_oid fk_taxrates_organization_oid
tax_rate rate numeric 131089
term active bool 1  √  null
term description varchar 2147483647  √  null
term name varchar 2147483647  √  null
term obj_oid int8 19
ticket agent_oid int8 19  √  1
person.obj_oid fkticket_agent
ticket close_date timestamptz 35,6  √  null
ticket date_returned timestamptz 35,6  √  null
ticket date_sent_out timestamptz 35,6  √  null
ticket est_close_date timestamptz 35,6  √  null
ticket obj_oid int8 19
ticket_log.ticket_oid fkcticket_log_ticket_oid
ticket open_date timestamptz 35,6  √  null
ticket patron_oid int8 19  √  null
person.obj_oid fkticket_patron
ticket priority int8 19  √  null
ticket problem_type varchar 2147483647  √  null
ticket purchase_order varchar 2147483647  √  null
ticket remedy_type varchar 2147483647  √  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
ticket resolution wcof_tag 2147483647  √  null
ticket resource_oid int8 19  √  null
resource.obj_oid fkticket_res
ticket responsible_op_oid int8 19  √  1
person.obj_oid fkticket_responsible_op
ticket severity wcof_tag 2147483647  √  null
ticket state wcof_tag 2147483647  √  null
ticket summary varchar 2147483647  √  null
ticket ticket_type wcof_tag 2147483647  √  null
ticket vendor_oid int8 19  √  1
person.obj_oid fkticket_vendor
ticket_log agent_oid int8 19  √  1
person.obj_oid fkcticket_log_agent_oid
ticket_log date timestamptz 35,6  √  null
ticket_log description varchar 2147483647  √  null
ticket_log obj_oid int8 19
ticket_log ticket_oid int8 19  √  null
ticket.obj_oid fkcticket_log_ticket_oid
ticket_log type wcof_tag 2147483647  √  null
ticket_problem_type name varchar 2147483647  √  null
ticket_problem_type obj_oid int8 19
ticket_remedy_type name varchar 2147483647  √  null
ticket_remedy_type obj_oid int8 19
turndown agent_oid int8 19  √  null
turndown allocation_oid int8 19  √  null
allocation.obj_oid turndown_allocation_oid_fkey
turndown date timestamptz 35,6  √  null
turndown location_oid int8 19  √  null
location.obj_oid turndown_location_oid_fkey
turndown obj_oid int8 19
turndown organization_oid int8 19  √  null
turndown patron_oid int8 19  √  null
person.obj_oid turndown_patron_oid_fkey
turndown rtype_oid int8 19  √  null
wco_application default_location_oid int8 19 1
location.obj_oid fkapp_default_loc_oid
wco_application default_org_oid int8 19 1
organization.obj_oid fkapp_default_org_oid
wco_application locale varchar 2147483647  √  null
wco_application motd_text varchar 2147483647  √  null
wco_application multiple_ip bool 1  √  null
wco_application obj_oid int8 19
wco_application pir_motd varchar 2147483647  √  null
wco_application ps_accepted_terms varchar 2147483647  √  null
wco_application schema_version int8 19  √  null
wco_application timezone varchar 2147483647  √  null
wco_features key varchar 2147483647
wco_features value varchar 2147483647
wco_group account_number varchar 2147483647  √  null
wco_group address_1 varchar 2147483647  √  null
wco_group address_2 varchar 2147483647  √  null
wco_group agency_number varchar 2147483647  √  null
wco_group auto_authorize bool 1  √  null
wco_group city varchar 2147483647  √  null
wco_group class_number varchar 2147483647  √  null
wco_group country varchar 2147483647  √  null
wco_group deleted bool 1  √  null
wco_group description varchar 2147483647  √  null
wco_group email varchar 2147483647  √  null
wco_group end_date timestamptz 35,6  √  null
wco_group facility_oid int8 19  √  null
resource.obj_oid fkcwco_group_facility_oid
wco_group fax varchar 2147483647  √  null
wco_group foreignid varchar 2147483647  √  null
wco_group instructor_oid int8 19  √  null
person.obj_oid fkcwco_group_instructor_oid
wco_group job_numbers varchar 2147483647  √  null
wco_group maintenance_contract_notes varchar 2147483647  √  null
wco_group maintenance_contract_number varchar 2147483647  √  null
wco_group modified timestamptz 35,6  √  null
wco_group name varchar 2147483647  √  null
wco_group note varchar 2147483647  √  null
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
wco_group organization_oid int8 19  √  null
organization.obj_oid fkcwco_group_organization_oid
wco_group origin varchar 2147483647
wco_group period varchar 2147483647  √  null
wco_group phone varchar 2147483647  √  null
wco_group postal_code varchar 2147483647  √  null
wco_group start_date timestamptz 35,6  √  null
wco_group state varchar 2147483647  √  null
wco_group teaching_assistant_oid int8 19  √  null
person.obj_oid fkcwco_group_teaching_assistant_oid
wco_group type wcof_tag 2147483647  √  null
wco_group url varchar 2147483647  √  null
wco_log action wcof_tag 2147483647  √  null
wco_log agent_oid int8 19  √  1
person.obj_oid fkcwco_log_agent_oid
wco_log class varchar 2147483647  √  null
wco_log instance int8 19  √  null
wco_log ip_addr int8 19  √  null
wco_log loc_oid int8 19  √  null
location.obj_oid fkcwco_log_loc_oid
wco_log log_text varchar 2147483647  √  null
wco_log obj_oid int8 19
wco_log org_oid int8 19  √  null
organization.obj_oid fkcwco_log_org_oid
wco_log responsible_agent_oid int8 19  √  1
person.obj_oid fkcwco_log_reps_agent_oid
wco_log time_stamp timestamptz 35,6  √  null
wco_request_log bytes_used int8 19  √  null
wco_request_log edit_allocation_oid int8 19  √  null
wco_request_log effective_operator_oid int8 19  √  null
wco_request_log end_locked_allocations _int8 19  √  null
wco_request_log get_parameters _varchar 2147483647  √  null
wco_request_log imho_element varchar 2147483647  √  null
wco_request_log location_oid int8 19  √  null
wco_request_log locked_allocations _int8 19  √  null
wco_request_log login_operator_oid int8 19  √  null
wco_request_log obj_oid int8 19
wco_request_log origin varchar 2147483647  √  null
wco_request_log post_parameters _varchar 2147483647  √  null
wco_request_log query_path varchar 2147483647  √  null
wco_request_log response_time_stamp timestamptz 35,6  √  null
wco_request_log sessionid varchar 2147483647  √  null
wco_request_log station varchar 2147483647  √  null
wco_request_log status int4 10  √  null
wco_request_log time_stamp timestamptz 35,6  √  null
wco_request_log time_used float8 17,17  √  null
wco_request_log ui_allocation_next_state wcof_tag 2147483647  √  null
wco_request_log ui_current_allocation_oid int8 19  √  null
wco_request_log view_allocation_oid int8 19  √  null
wco_request_log webmethod varchar 2147483647  √  null
wco_request_log xhrmethod varchar 2147483647  √  null
wco_station location_oid int8 19  √  null
location.obj_oid fkcwco_station_location_oid
wco_station name varchar 2147483647  √  null
wco_station obj_oid int8 19
wco_station print_queue varchar 2147483647  √  null
wco_task_log end_time timestamptz 35,6  √  null
wco_task_log obj_oid int8 19
wco_task_log run_time interval 49,6  √  null
wco_task_log start_time timestamptz 35,6  √  null
wco_task_log task_object varchar 2147483647  √  null
wco_task_log work_object varchar 2147483647  √  null
wco_version version int8 19