webco_3.9.1.public contains 988 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Children	Parents	Comments
hold	active	bool	1	√		null
tax_rate	active	bool	1			true
term	active	bool	1	√		null
default_allocation_times	apply_when_open	bool	1	√		null
allocation	approved	bool	1	√		null
resource_type	authorized	bool	1	√		null
wco_group	auto_authorize	bool	1	√		null
allocation	auto_circulate	bool	1	√		null
resource_controller	can_record	bool	1	√		null
location_auto_email	cancelled_reservation_enabled	bool	1	√		null
holding_ext	circulating	bool	1	√		null
resource	circulating	bool	1	√		null
bibliographic_record_configuration	color	bool	1	√		null
tax_rate	compound	bool	1			false
bibliographic_record_configuration	contributor	bool	1	√		null
bibliographic_record_configuration	course	bool	1	√		null
location_auto_email	created_reservation_enabled	bool	1	√		null
bibliographic_record_configuration	data	bool	1	√		null
resource_type	default_p	bool	1	√		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
calendar_allocation_fields	delivery_people	bool	1	√		null
bibliographic_record_configuration	description	bool	1	√		null
resource	destination	bool	1	√		null
bibliographic_record_configuration	director	bool	1	√		null
location_auto_email	edited_reservation_enabled	bool	1	√		null
pir_request_log	editing	bool	1	√		null
bibliographic_record_configuration	edition	bool	1	√		null
task	estimate_p	bool	1	√		null
calendar_allocation_fields	event_description	bool	1	√		null
allocation_staffing	filled	bool	1	√		null
calendar_allocation_fields	freelancers	bool	1	√		null
calendar_allocation_fields	id	bool	1	√		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_configuration	isbn	bool	1	√		null
pq_invoice	journaled_p	bool	1	√		null
bibliographic_record_configuration	language	bool	1	√		null
bibliographic_record_configuration	loc_control_number	bool	1	√		null
wco_application	multiple_ip	bool	1	√		null
allocation	nonexpiring	bool	1	√		null
calendar_allocation_fields	note	bool	1	√		null
calendar_allocation_fields	patron_name	bool	1	√		null
bibliographic_record_configuration	performers	bool	1	√		null
calendar_allocation_fields	pickup_instructions	bool	1	√		null
calendar_allocation_fields	pickup_option	bool	1	√		null
location_auto_email	pickup_reservation_enabled	bool	1	√		null
location	pir_media_cc_query	bool	1	√		null
resource_type	pir_p	bool	1	√		true
location	pir_requires_approval	bool	1	√		null
location	pir_restrict_delivery_locations	bool	1	√		null
bibliographic_record_configuration	producer	bool	1	√		null
bibliographic_record_configuration	program_type	bool	1	√		null
bibliographic_record_configuration	publication_year	bool	1	√		null
bibliographic_record_configuration	publisher	bool	1	√		null
invoice	ready_to_bill	bool	1	√		null
bibliographic_record_configuration	relations	bool	1	√		null
location	repeats_in_pir	bool	1	√		null
location	require_signature_on_file	bool	1	√		false
calendar_allocation_fields	resource_types	bool	1	√		null
calendar_allocation_fields	resources	bool	1	√		null
organization	restricted	bool	1	√		null
location_auto_email	return_checkout_enabled	bool	1	√		null
bibliographic_record_configuration	run_time	bool	1	√		null
bibliographic_record_configuration	series_title	bool	1	√		null
bibliographic_record_configuration	series_volume_number	bool	1	√		null
bibliographic_record_configuration	sound	bool	1	√		null
bibliographic_record_configuration	source	bool	1	√		null
task	started_p	bool	1	√		null
bibliographic_record_configuration	stored	bool	1	√		null
invoice_line	struck	bool	1	√		null
bibliographic_record_configuration	subject	bool	1	√		null
organization	suppress_autopayment	bool	1	√		null
person	suppress_email	bool	1	√		null
account_code	taxable	bool	1	√		null
invoice	taxable	bool	1	√		null
location_auto_email	ticket_enabled	bool	1	√		null
resource	unserialized	bool	1	√		null
location	usage_exclude_closed	bool	1	√		null
allocation	use_charge_duration	bool	1	√		null
bibliographic_record_configuration	view_database	bool	1	√		null
wco_response_log	seconds_used	float8	17,17	√		null
allocation_staffing	assigned_staff	int4	10
resource	capacity	int4	10	√		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
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
location_schedule_node	day_number	int4	10
location	day_rollover	int4	10	√		null
location_schedule_node	end_time_minutes	int4	10	√		null
default_allocation_times	end_tod_minutes	int4	10	√		null
location_schedule	location_oid	int4	10	√		null		location.obj_oid fkclocation_schedule_location
location_schedule_node	location_schedule_oid	int4	10					location_schedule.obj_oid fkclocation_schedule_node_location_schedule
resource	max_quantity	int4	10	√		null
default_allocation_times	obj_oid	int4	10				dat_location.dat_oid fkcdat_oid dat_organization.dat_oid fkcdat_oid
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_node	obj_oid	int4	10
location_schedule	parent_oid	int4	10	√		null		location_schedule.obj_oid fkclocation_schedule_parent
location	pir_session_timeout	int4	10			15
allocation_staffing	required_staff	int4	10
location_schedule	schedule_length	int4	10	√		null
location_schedule_node	start_time_minutes	int4	10	√		null
default_allocation_times	start_tod_minutes	int4	10	√		null
wco_response_log	status	int4	10	√		null
organization	admin_id	int8	19	√		null		person.obj_oid fkcorg_admin_id
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
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
invoice_line	amount	int8	19	√		null
pq_invoice_line	association	int8	19	√		null
file_attachment	attached_to_oid	int8	19
invoice	balance	int8	19	√		null
bibliographic_record_helix	bibliographic_record_oid	int8	19	√		null		bibliographic_record.obj_oid fkbiblio_record_oid
holding	bibliographic_record_oid	int8	19					bibliographic_record.obj_oid fkholding_bibliographic_record
department	billing_contact_oid	int8	19	√		null		person.obj_oid fkcdepartment_billing_contact_oid
wco_response_log	bytes_used	int8	19	√		null
invoice	cc_oid	int8	19	√		null		location.obj_oid fkcinvoice_cc_oid
resource_child	child_resource_oid	int8	19	√		null
task	client_oid	int8	19	√		null
allocation	contact_person	int8	19	√		null		person.obj_oid fkcalloc_contact_person
resource	containing_resource_oid	int8	19	√		null		resource.obj_oid fkres_cont_res
integration_log	created	int8	19	√		null
invoice	created_by	int8	19	√		1		person.obj_oid fkcinvoice_created_by
invoice_line	created_by	int8	19	√		1		person.obj_oid fkinv_line_created_by
location	crestron_port	int8	19	√		null
integration_log	deleted	int8	19	√		null
allocation	deliver_to_oid	int8	19	√		null		resource.obj_oid fkcalloc_deliver_to_oid
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
wco_http_event_log	edit_allocation_oid	int8	19	√		null
wco_request_log	edit_allocation_oid	int8	19	√		null
wco_request_log	effective_operator_oid	int8	19	√		null
index_entry	entity_oid	int8	19
subscription	entity_oid	int8	19	√		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
file_attachment	file_size	int8	19
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
group_authorization	group_oid	int8	19					wco_group.obj_oid group_authorization_group_oid_fkey group_member.group_oid authorization_group_fkeys
group_member	group_oid	int8	19				group_authorization.group_oid authorization_group_fkeys	wco_group.obj_oid fkcgroup_member_group_oid
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
wco_log	instance	int8	19	√		null
wco_group	instructor_oid	int8	19	√		null		person.obj_oid fkcwco_group_instructor_oid
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
wco_log	ip_addr	int8	19	√		null
late_returns	late_returns	int8	19	√		null
person	late_returns	int8	19	√		null
wco_log	loc_oid	int8	19	√		null		location.obj_oid fkcwco_log_loc_oid
allocation	location_oid	int8	19	√		null		location.obj_oid fkcalloc_location_oid
allocation_reminder_interval	location_oid	int8	19					location.obj_oid fkcallocation_reminder_interval_location
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
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
wco_request_log	login_operator_oid	int8	19	√		null
task	main_contact_oid	int8	19	√		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
account_code	obj_oid	int8	19
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
allocation_building_pass	obj_oid	int8	19
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_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_reminder_interval	obj_oid	int8	19				mail_event.allocation_reminder_interval_oid fkmail_event_alloc_reminder_interval_oid
allocation_repeat_rule	obj_oid	int8	19				allocation_group.rule_oid fkcalloc_group_rule_oid
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	obj_oid	int8	19				bibliographic_record_helix.bibliographic_record_oid fkbiblio_record_oid holding.bibliographic_record_oid fkholding_bibliographic_record
bibliographic_record_configuration	obj_oid	int8	19
bibliographic_record_helix	obj_oid	int8	19
calendar_allocation_fields	obj_oid	int8	19
calendar_authentication	obj_oid	int8	19					person.obj_oid fkccalauthentication_obj_oid
circulation_policy	obj_oid	int8	19
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_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_member	obj_oid	int8	19
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	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
invoice_line	obj_oid	int8	19				invoice_line_tax_rate.invoice_line_oid invoice_line_tax_rate_invoice_line_oid_fkey
invoice_line_tax_rate	obj_oid	int8	19
invoice_tax_rate	obj_oid	int8	19
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
location_auto_email	obj_oid	int8	19
location_pir_pickup_option	obj_oid	int8	19
mail_event	obj_oid	int8	19
notification_channel	obj_oid	int8	19	√		null
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
organization_credit_card_type	obj_oid	int8	19
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
person_location_signature	obj_oid	int8	19
person_role	obj_oid	int8	19
pir_allocation	obj_oid	int8	19				pir_item.pir_allocation_oid fkcpir_item_pir_alloc_oid
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	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
resource_controller	obj_oid	int8	19
resource_schedule	obj_oid	int8	19
resource_sleep_queue	obj_oid	int8	19	√		null
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
resource_type_fallback	obj_oid	int8	19
resource_wake_queue	obj_oid	int8	19	√		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
service	obj_oid	int8	19
subscription	obj_oid	int8	19				subscription_contact.subscription_oid fksubscription_notification_subscription subscription_notification.subscription_oid fksubscription_notification_subscription
subscription_contact	obj_oid	int8	19
subscription_notification	obj_oid	int8	19
task	obj_oid	int8	19				task.depends_on fktask_depends_on_oid task.parent_oid fktask_parent_oid
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
tax_rate	obj_oid	int8	19				invoice_line_tax_rate.tax_rate_oid invoice_line_tax_rate_tax_rate_oid_fkey invoice_tax_rate.tax_rate_oid invoice_tax_rate_tax_rate_oid_fkey
term	obj_oid	int8	19
ticket	obj_oid	int8	19				ticket_log.ticket_oid fkcticket_log_ticket_oid
ticket_log	obj_oid	int8	19
ticket_problem_type	obj_oid	int8	19
ticket_remedy_type	obj_oid	int8	19
turndown	obj_oid	int8	19
wco_application	obj_oid	int8	19
wco_authorization	obj_oid	int8	19
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
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
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
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
allocation	original_agent_oid	int8	19	√		null		person.obj_oid fkallocation_original_agent_oid
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
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
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
wco_authorization	person	int8	19	√		null		person.obj_oid fkauth_person
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
group_member	person_oid	int8	19				group_authorization.person_oid authorization_group_fkeys	person.obj_oid fkcgroup_member_person_oid
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
pir_item	pir_allocation_oid	int8	19	√		null		pir_allocation.obj_oid fkcpir_item_pir_alloc_oid
ticket	priority	int8	19	√		null
pq_invoice	project	int8	19	√		null
bibliographic_record	publication_year	int8	19	√		null
invoice_line	quantity	int8	19	√		null
pq_invoice_line	quantity	int8	19	√		null
invoice	real_payee	int8	19	√		null		person.obj_oid fkcinvoice_real_payee
index_entry	referenced_oid	int8	19
allocation	renewal_count	int8	19	√		null
ticket	repair_cost	int8	19	√		null
ticket	repair_cost_labor	int8	19	√		null
ticket	repair_cost_parts	int8	19	√		null
ticket	repair_price	int8	19	√		null
wco_http_event_log	request_oid	int8	19	√		null
resource_schedule	requested_rtype_oid	int8	19	√		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
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
import_session	result	int8	19	√		null
resource_schedule	return_agent_oid	int8	19	√		1		person.obj_oid fkcresource_schedule_return_agent_oid
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
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
bibliographic_record	run_time	int8	19	√		null
resource_schedule	scheduled_resource_oid	int8	19					resource.obj_oid resource_schedule_scheduled_resource_oid_fkey
wco_application	schema_version	int8	19	√		null
allocation_group	seq_no	int8	19	√		null
allocation_route	sink_oid	int8	19					resource.obj_oid allocation_route_sink_oid_fkey
pq_invoice_line	sort_position	int8	19	√		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
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
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
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
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
invoice_line	tax	int8	19	√		null
invoice_line_tax_rate	tax_amount	int8	19	√		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
wco_group	teaching_assistant_oid	int8	19	√		null		person.obj_oid fkcwco_group_teaching_assistant_oid
ticket_log	ticket_oid	int8	19	√		null		ticket.obj_oid fkcticket_log_ticket_oid
task	time_log	int8	19	√		null
location	timeline_granularity	int8	19	√		null
location	timeline_zoom_factor	int8	19	√		null
resource_type_fallback	type_oid	int8	19					resource_type.obj_oid resource_type_fallback_type_oid_fkey
wco_request_log	ui_current_allocation_oid	int8	19	√		null
pir_request_log	unsaved_allocation_oid	int8	19	√		null		allocation.obj_oid fkpir_request_log_unsaved_allocation_oid
person	unused_reservations	int8	19	√		null
integration_log	updated	int8	19	√		null
file_attachment	upload_person_oid	int8	19					person.obj_oid fkfile_attachment_upload_person_oid
pq_account_preference	user_oid	int8	19	√		null
resource	value	int8	19	√		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
service	unit	interval	49,6	√		null
invoice_charges	balance	numeric	131089	√		null
invoice_payments	balance	numeric	131089	√		null
service	cost_per_unit	numeric	131089	√		null
tax_rate	rate	numeric	131089
task	index	serial	10		√	nextval('task_index_seq'::regclass)
bibliographic_record_ext	obj_oid	serial	10		√	nextval('bibliographic_record_ext_obj_oid_seq'::regclass)
group_ext	obj_oid	serial	10		√	nextval('group_ext_obj_oid_seq'::regclass)
group_member_ext	obj_oid	serial	10		√	nextval('group_member_ext_obj_oid_seq'::regclass)
person_ext	obj_oid	serial	10		√	nextval('person_ext_obj_oid_seq'::regclass)
resource_ext	obj_oid	serial	10		√	nextval('resource_ext_obj_oid_seq'::regclass)
resource_type_ext	obj_oid	serial	10		√	nextval('resource_type_ext_obj_oid_seq'::regclass)
coalesced_deliver_to_v	type	text	2147483647	√		null
task	actual_end_time	timestamp	29,6	√		null
task	actual_start_time	timestamp	29,6	√		null
ticket	close_date	timestamp	29,6	√		null
hold	created	timestamp	29,6	√		null
task	created_at	timestamp	29,6	√		null
invoice	creation_date	timestamp	29,6	√		null
invoice_line	creation_date	timestamp	29,6	√		null
allocation	creation_time	timestamp	29,6	√		null
resource_controller	daily_sleep_time	timestamp	29,6	√		null
resource_controller	daily_wake_time	timestamp	29,6	√		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
invoice	due_date	timestamp	29,6	√		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
ticket	est_close_date	timestamp	29,6	√		null
group_authorization	expire	timestamp	29,6	√		null
group_member	expire	timestamp	29,6	√		null
allocation	expire_time	timestamp	29,6	√		null
person	expires	timestamp	29,6	√		null
invoice	hold_date	timestamp	29,6	√		null
resource	last_inventoried_date	timestamp	29,6	√		null
allocation	last_renewal	timestamp	29,6	√		null
resource_controller	last_sleep_time	timestamp	29,6	√		null
resource_controller	last_wake_time	timestamp	29,6	√		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
ticket	open_date	timestamp	29,6	√		null
resource	purchase_date	timestamp	29,6	√		null
allocation	real_end_time	timestamp	29,6	√		null
resource_schedule	real_end_time	timestamp	29,6	√		null
resource	replacement_date	timestamp	29,6	√		null
wco_http_event_log	request_time_stamp	timestamp	29,6	√		null
location_schedule	schedule_end	timestamp	29,6	√		null
location_schedule	schedule_start	timestamp	29,6	√		null
task	scheduled_end_time	timestamp	29,6	√		null
task	scheduled_start_time	timestamp	29,6	√		null
organization	semester_end	timestamp	29,6	√		null
organization	semester_start	timestamp	29,6	√		null
mail_event	send_time	timestamp	29,6	√		null
group_authorization	start_date	timestamp	29,6	√		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
allocation_task	task_time	timestamp	29,6	√		null
allocation_log	time	timestamp	29,6	√		null
subscription_notification	time	timestamp	29,6	√		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
task	updated_at	timestamp	29,6	√		null
file_attachment	upload_time	timestamp	29,6
tax_rate	name	varchar	10
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
location	address	varchar	2147483647	√		null
wco_group	address_1	varchar	2147483647	√		null
wco_group	address_2	varchar	2147483647	√		null
task	agency_job_number	varchar	2147483647	√		null
wco_group	agency_number	varchar	2147483647	√		null
location	allocation_mode	varchar	2147483647	√		null
bibliographic_record	alternative_title	varchar	2147483647	√		null
bibliographic_record_ext	alternative_title	varchar	2147483647	√		null
resource	asset_tag	varchar	2147483647	√		null
resource_ext	asset_tag	varchar	2147483647	√		null
file_attachment	attached_to_class	varchar	2147483647
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
allocation_freelancer	availability	varchar	2147483647
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
location	billing_contact_email	varchar	2147483647	√		null
location	billing_contact_name	varchar	2147483647	√		null
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
holding	call_number	varchar	2147483647	√		null
holding_ext	call_number	varchar	2147483647	√		null
resource_ext	call_number	varchar	2147483647	√		null
location_auto_email	cancelled_reservation_cc	varchar	2147483647	√		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
allocation	charge_duration	varchar	2147483647	√		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
account_code	code	varchar	2147483647
department_code	code	varchar	2147483647
bibliographic_record	color	varchar	2147483647	√		null
bibliographic_record_ext	color	varchar	2147483647	√		null
pq_account_preference	component_states	varchar	2147483647	√		null
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_phone_string	varchar	2147483647	√		null
subscription_contact	contact_type	varchar	2147483647
resource_ext	container_foreignid	varchar	2147483647	√		null
bibliographic_record	contributor	varchar	2147483647	√		null
bibliographic_record_ext	contributor	varchar	2147483647	√		null
bibliographic_record	country	varchar	2147483647	√		null
bibliographic_record_ext	country	varchar	2147483647	√		null
department	country	varchar	2147483647	√		null
organization	country	varchar	2147483647	√		null
person	country	varchar	2147483647	√		null
person_ext	country	varchar	2147483647	√		null
wco_group	country	varchar	2147483647	√		null
bibliographic_record	course	varchar	2147483647	√		null
bibliographic_record_ext	course	varchar	2147483647	√		null
location_auto_email	created_reservation_cc	varchar	2147483647	√		null
allocation	credit_card_type	varchar	2147483647	√		null
invoice	credit_card_type	varchar	2147483647	√		null
location	crestron_host	varchar	2147483647	√		null
location	default_delivery_type	varchar	2147483647			'NORMAL'::character varying
location	default_resource_selector	varchar	2147483647	√		null
coalesced_deliver_to_v	deliver_to	varchar	2147483647	√		null
allocation	deliver_to_string	varchar	2147483647	√		null
pir_allocation	deliver_to_string	varchar	2147483647	√		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
bibliographic_record	description	varchar	2147483647	√		null
bibliographic_record_ext	description	varchar	2147483647	√		null
file_attachment	description	varchar	2147483647	√		null
group_ext	description	varchar	2147483647	√		null
invoice	description	varchar	2147483647	√		null
invoice_line	description	varchar	2147483647	√		null
location	description	varchar	2147483647	√		null
resource	description	varchar	2147483647	√		null
resource_ext	description	varchar	2147483647	√		null
resource_type	description	varchar	2147483647	√		null
resource_type_ext	description	varchar	2147483647	√		null
term	description	varchar	2147483647	√		null
ticket_log	description	varchar	2147483647	√		null
wco_group	description	varchar	2147483647	√		null
resource_ext	destination	varchar	2147483647	√		null
resource_controller	device_id	varchar	2147483647	√		null
bibliographic_record	director	varchar	2147483647	√		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
organization	due_days	varchar	2147483647	√		null
allocation_reminder_interval	duration	varchar	2147483647
location_auto_email	edited_reservation_cc	varchar	2147483647	√		null
bibliographic_record	edition	varchar	2147483647	√		null
bibliographic_record_ext	edition	varchar	2147483647	√		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
index_entry	entity_class	varchar	2147483647
subscription	entity_type	varchar	2147483647	√		null
bibliographic_record	era	varchar	2147483647			'AD'::character varying
bibliographic_record_ext	era	varchar	2147483647	√		null
ticket	estimated_cost	varchar	2147483647	√		null
allocation	event_description	varchar	2147483647	√		null
invoice	event_description	varchar	2147483647	√		null
group_member_ext	expire	varchar	2147483647	√		null
person_ext	expires	varchar	2147483647	√		null
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
import_session	files	varchar	2147483647	√		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
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
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
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
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
index_entry	index_name	varchar	2147483647
group_ext	instructor_foreignid	varchar	2147483647	√		null
resource_ext	inventory_date	varchar	2147483647	√		null
invoice	invoice_id	varchar	2147483647	√		null
invoice	invoice_status	varchar	2147483647	√		null
bibliographic_record	isbn	varchar	2147483647	√		null
bibliographic_record_ext	isbn	varchar	2147483647	√		null
wco_group	job_numbers	varchar	2147483647	√		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_ext	language	varchar	2147483647	√		null
person	last_name	varchar	2147483647	√		null
person_ext	last_name	varchar	2147483647	√		null
allocation_freelancer	last_sent_mail	varchar	2147483647	√		null
bibliographic_record	loc_control_number	varchar	2147483647	√		null
bibliographic_record_ext	loc_control_number	varchar	2147483647	√		null
holding_ext	location	varchar	2147483647
resource_ext	location	varchar	2147483647	√		null
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
resource	mac_address	varchar	2147483647	√		null
resource_ext	mac_address	varchar	2147483647	√		null
mail_event	mail_type	varchar	2147483647	√		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
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
wco_application	motd_text	varchar	2147483647	√		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
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
account_code	note	varchar	2147483647	√		null
allocation	note	varchar	2147483647	√		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
group_ext	organization	varchar	2147483647	√		null
resource_type_ext	organization	varchar	2147483647	√		null
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
person	other_name	varchar	2147483647	√		null
person_ext	other_name	varchar	2147483647	√		null
resource_type_ext	parent	varchar	2147483647	√		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
invoice	paying_account	varchar	2147483647	√		null
invoice	payment_rule	varchar	2147483647	√		null
allocation	payment_type	varchar	2147483647	√		null
bibliographic_record	performers	varchar	2147483647	√		null
bibliographic_record_ext	performers	varchar	2147483647	√		null
wco_group	period	varchar	2147483647	√		null
group_member_ext	person_foreignid	varchar	2147483647	√		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
allocation	pickup_option	varchar	2147483647	√		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
authentication	pin	varchar	2147483647	√		null
location	pir_mode	varchar	2147483647	√		'BOTH'::character varying
location	pir_motd	varchar	2147483647	√		null
wco_application	pir_motd	varchar	2147483647	√		null
resource_type_ext	pir_p	varchar	2147483647	√		null
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	problem_type	varchar	2147483647	√		null
bibliographic_record	producer	varchar	2147483647	√		null
bibliographic_record_ext	producer	varchar	2147483647	√		null
bibliographic_record	program_type	varchar	2147483647	√		null
bibliographic_record_ext	program_type	varchar	2147483647	√		null
project_layout	project_data	varchar	2147483647	√		null
wco_application	ps_accepted_terms	varchar	2147483647	√		null
bibliographic_record_ext	publication_year	varchar	2147483647	√		null
bibliographic_record	publisher	varchar	2147483647	√		null
bibliographic_record_ext	publisher	varchar	2147483647	√		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
wco_http_event_log	query_path	varchar	2147483647	√		null
wco_request_log	query_path	varchar	2147483647	√		null
index_entry	referenced_class	varchar	2147483647
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
ticket	remedy_type	varchar	2147483647	√		null
ticket	repair_cost_note	varchar	2147483647	√		null
ticket	repair_warranty_labor	varchar	2147483647	√		null
ticket	repair_warranty_parts	varchar	2147483647	√		null
resource_ext	replacement_date	varchar	2147483647	√		null
wco_request_log	request_token	varchar	2147483647	√		null
wco_response_log	request_token	varchar	2147483647	√		null
ticket	resolution	varchar	2147483647	√		null
holding	restrictions	varchar	2147483647	√		null
holding_ext	restrictions	varchar	2147483647	√		null
resource_ext	restrictions	varchar	2147483647	√		null
location_auto_email	return_checkout_cc	varchar	2147483647	√		null
location	return_default	varchar	2147483647			'WILL-RETURN'::character varying
allocation	return_option	varchar	2147483647	√		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
integration_proc	run_function	varchar	2147483647	√		null
integration_proc	run_interval	varchar	2147483647	√		null
bibliographic_record_ext	run_time	varchar	2147483647	√		null
integration_proc	run_time	varchar	2147483647	√		null
location_schedule	schedule_name	varchar	2147483647	√		null
location_schedule	schedule_type	varchar	2147483647
task	scheduled_length	varchar	2147483647	√		null
location	scheduler_type	varchar	2147483647	√		null
resource	serial_number	varchar	2147483647	√		null
resource_ext	serial_number	varchar	2147483647	√		null
bibliographic_record	series_title	varchar	2147483647	√		null
bibliographic_record_ext	series_title	varchar	2147483647	√		null
bibliographic_record	series_volume_number	varchar	2147483647	√		null
bibliographic_record_ext	series_volume_number	varchar	2147483647	√		null
pir_request_log	sessionid	varchar	2147483647	√		null
wco_http_event_log	sessionid	varchar	2147483647	√		null
wco_request_log	sessionid	varchar	2147483647	√		null
wco_response_log	sessionid	varchar	2147483647	√		null
ticket	severity	varchar	2147483647	√		null
holding	shelf_location	varchar	2147483647	√		null
holding_ext	shelf_location	varchar	2147483647	√		null
resource_ext	shelf_location	varchar	2147483647	√		null
bibliographic_record	sound	varchar	2147483647	√		null
bibliographic_record_ext	sound	varchar	2147483647	√		null
bibliographic_record	source	varchar	2147483647	√		null
bibliographic_record_ext	source	varchar	2147483647	√		null
default_allocation_times	start_application	varchar	2147483647	√		null
group_ext	start_date	varchar	2147483647	√		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
import_session	step	varchar	2147483647	√		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
bibliographic_record	subject	varchar	2147483647	√		null
bibliographic_record_ext	subject	varchar	2147483647	√		null
invoice_line	subtype	varchar	2147483647	√		null
ticket	summary	varchar	2147483647	√		null
wco_task_log	task_object	varchar	2147483647	√		null
task	task_status	varchar	2147483647
allocation_task	task_type	varchar	2147483647	√		null
department	tax_exempt_number	varchar	2147483647	√		null
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
ticket	ticket_type	varchar	2147483647	√		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
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
wco_response_log	ui_allocation_next_state	varchar	2147483647	√		null
pq_invoice_line	units	varchar	2147483647	√		null
resource_ext	unserialized	varchar	2147483647	√		null
holding_ext	url	varchar	2147483647	√		null
resource	url	varchar	2147483647	√		null
resource_ext	url	varchar	2147483647	√		null
wco_group	url	varchar	2147483647	√		null
person	userid	varchar	2147483647	√		null
person_ext	userid	varchar	2147483647	√		null
resource_schedule	uuid	varchar	2147483647
index_entry	value	varchar	2147483647	√		null
resource_ext	value	varchar	2147483647	√		null
string_map	value	varchar	2147483647
resource	vendor	varchar	2147483647	√		null
resource_ext	vendor	varchar	2147483647	√		null
person	vendor_name	varchar	2147483647	√		null
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