webco_5.0.public contains 1291 columns - click on heading to sort:

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