webco_4.1.0.public contains 982 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Children	Parents	Comments
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)
group_set_member	obj_oid	serial	10		√	nextval('group_set_member_obj_oid_seq'::regclass)
operator_authorization	obj_oid	serial	10		√	nextval('hibernate_sequence'::regclass)	authset_authorization.authorization_oid fkauthset_authorization_authorization_oid
operator_role	obj_oid	serial	10		√	nextval('hibernate_sequence'::regclass)	authset.operator_role_oid fkauthset_role_oid
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	accessories	_varchar	2147483647			ARRAY[]::character varying[]
resource_ext	accessories	varchar	2147483647	√		null
allocation	account_code	varchar	2147483647	√		null
wco_group	account_number	varchar	2147483647	√		null
wco_log	action	wcof_tag	2147483647	√		null
hold	active	bool	1	√		null
tax_rate	active	bool	1			true
term	active	bool	1	√		null
location	address	varchar	2147483647	√		null
sched_staffed_location	address	varchar	2147483647	√		null
wco_group	address_1	varchar	2147483647	√		null
wco_group	address_2	varchar	2147483647	√		null
organization	admin_id	int8	19	√		null		person.obj_oid fkcorg_admin_id
wco_group	agency_number	varchar	2147483647	√		null
allocation_log	agent	int8	19	√		null
allocation	agent_oid	int8	19	√		1		person.obj_oid fkcalloc_agent_oid
inventory_event	agent_oid	int8	19	√		null		person.obj_oid inventory_event_agent_oid_fkey
ticket	agent_oid	int8	19	√		1		person.obj_oid fkticket_agent
ticket_log	agent_oid	int8	19	√		1		person.obj_oid fkcticket_log_agent_oid
turndown	agent_oid	int8	19	√		null
wco_log	agent_oid	int8	19	√		1		person.obj_oid fkcwco_log_agent_oid
resource	aggregate_value	odcl_money	2147483647	√		null
location	agreement_form_grouping	wcof_tag	2147483647
location	agreement_form_sorting	wcof_tag	2147483647
allocation_freelancer_assigned	allocation_freelancer_oid	int8	19					allocation_freelancer.obj_oid fkallocation_freelancer_assigned_af_oid
allocation_freelancer_role	allocation_freelancer_oid	int8	19					allocation_freelancer.obj_oid fkallocation_freelancer_role_af_oid
location	allocation_mode	wcof_tag	2147483647	√		null
allocation_freelancer	allocation_oid	int8	19					allocation.obj_oid fkcallocation_freelancer_allocation_oid
allocation_group	allocation_oid	int8	19					allocation.obj_oid allocation_group_allocation_oid_fkey
allocation_log	allocation_oid	int8	19	√		null		allocation.obj_oid fkcalloc_log_alloc_oid
allocation_person	allocation_oid	int8	19					allocation.obj_oid allocation_person_allocation_oid_fkey
allocation_repeat_rule	allocation_oid	int8	19					allocation.obj_oid allocation_repeat_rule_allocation_oid_fkey
allocation_route	allocation_oid	int8	19					allocation.obj_oid allocation_route_allocation_oid_fkey
allocation_route_message	allocation_oid	int8	19					allocation.obj_oid allocation_route_message_allocation_oid_fkey
allocation_staffing	allocation_oid	int8	19					allocation.obj_oid fkallocation_staffing_allocation_oid
allocation_task	allocation_oid	int8	19					allocation.obj_oid allocation_task_allocation_oid_fkey
coalesced_deliver_to_v	allocation_oid	int8	19	√		null
invoice	allocation_oid	int8	19	√		null		allocation.obj_oid fkcinvoice_alloc_oid
mail_event	allocation_oid	int8	19	√		null		allocation.obj_oid fkmail_event_alloc_oid
pir_request_log	allocation_oid	int8	19	√		null		allocation.obj_oid fkpir_request_log_allocation_oid
resource_schedule	allocation_oid	int8	19	√		null		allocation.obj_oid fkcresource_schedule_alloc_oid
turndown	allocation_oid	int8	19	√		null		allocation.obj_oid turndown_allocation_oid_fkey
mail_event	allocation_reminder_interval_oid	int8	19	√		null		allocation_reminder_interval.obj_oid fkmail_event_alloc_reminder_interval_oid
bibliographic_record	alternative_title	wcof_collated_string	2147483647	√		null
bibliographic_record_ext	alternative_title	varchar	2147483647	√		null
invoice_line	amount	odcl_money	2147483647	√		null
default_allocation_times	apply_when_open	bool	1	√		null
allocation	approved	bool	1	√		null
resource	asset_tag	varchar	2147483647	√		null
resource_ext	asset_tag	varchar	2147483647	√		null
allocation_staffing	assigned_staff	int4	10
file_attachment	attached_to_class	varchar	2147483647
file_attachment	attached_to_oid	int8	19
calendar_authentication	auth_type	varchar	2147483647
bibliographic_record	author	wcof_collated_string_list	2147483647	√		null
bibliographic_record_ext	author	varchar	2147483647	√		null
authset_authorization	authorization_oid	int4	10					operator_authorization.obj_oid fkauthset_authorization_authorization_oid
resource_type_ext	authorization_required	varchar	2147483647	√		null
resource_type	authorized	bool	1	√		null
authset_authorization	authset_oid	int4	10					authset.obj_oid fkauthset_authorization_authset_oid
authset_location	authset_oid	int4	10					authset.obj_oid fkauthset_location_authset_oid
wco_group	auto_authorize	bool	1	√		null
allocation	auto_circulate	bool	1	√		null
allocation_freelancer	availability	wcof_tag	2147483647
invoice	balance	odcl_money	2147483647	√		null
invoice_charges	balance	numeric	131089	√		null
invoice_payments	balance	numeric	131089	√		null
inventory_event	barcode	varchar	2147483647	√		null
person	barcode	varchar	2147483647	√		null
person_ext	barcode	varchar	2147483647	√		null
resource	barcode	varchar	2147483647	√		null
resource_ext	barcode	varchar	2147483647	√		null
resource_ext	biblio_id	varchar	2147483647	√		null
bibliographic_record_helix	bibliographic_record_oid	int8	19	√		null		bibliographic_record.obj_oid fkbiblio_record_oid
holding	bibliographic_record_oid	int8	19					bibliographic_record.obj_oid fkholding_bibliographic_record
department_ext	billing_contact	varchar	2147483647	√		null
location	billing_contact_email	varchar	2147483647	√		null
location	billing_contact_name	varchar	2147483647	√		null
department	billing_contact_oid	int8	19	√		null		person.obj_oid fkcdepartment_billing_contact_oid
location	billing_contact_phone	varchar	2147483647	√		null
allocation	billing_type	wcof_tag	2147483647	√		null
resource	budget_number	varchar	2147483647	√		null
resource_ext	budget_number	varchar	2147483647	√		null
location	building	varchar	2147483647	√		null
sched_staffed_location	building	varchar	2147483647	√		null
wco_response_log	bytes_used	int8	19	√		null
holding	call_number	varchar	2147483647	√		null
resource_ext	call_number	varchar	2147483647	√		null
resource_controller	can_record	bool	1	√		null
location_auto_email	cancelled_reservation_cc	varchar	2147483647	√		null
location_auto_email	cancelled_reservation_enabled	bool	1	√		null
resource	capacity	int4	10	√		null
resource_ext	capacity	varchar	2147483647	√		null
resource_type	caption	varchar	2147483647	√		null
resource_type_ext	caption	varchar	2147483647	√		null
bibliographic_record	captions	wcof_tag	2147483647	√		null
bibliographic_record_ext	captions	varchar	2147483647	√		null
group_ext	catalog_number	varchar	2147483647	√		null
invoice	cc_oid	int8	19	√		null		location.obj_oid fkcinvoice_cc_oid
allocation	charge_duration	interval	49,6	√		null
pir_auth_ext	checkout_center	varchar	2147483647	√		null
resource	circulating	bool	1	√		null
resource_ext	circulating	varchar	2147483647	√		null
department	city	varchar	2147483647	√		null
department_ext	city	varchar	2147483647	√		null
organization	city	varchar	2147483647	√		null
person	city	varchar	2147483647	√		null
person_ext	city	varchar	2147483647	√		null
wco_group	city	varchar	2147483647	√		null
integration_log	class	varchar	2147483647	√		null
invoice	class	wcof_tag	2147483647	√		null
wco_log	class	varchar	2147483647	√		null
group_ext	class_number	varchar	2147483647	√		null
wco_group	class_number	varchar	2147483647	√		null
person	client_name	varchar	2147483647	√		null
ticket	close_date	timestamptz	35,6	√		null
account_code	code	varchar	2147483647
account_code_ext	code	varchar	2147483647	√		null
department_code	code	varchar	2147483647
bibliographic_record	color	varchar	2147483647	√		null
bibliographic_record_ext	color	varchar	2147483647	√		null
tax_rate	compound	bool	1			false
resource	condition_note	varchar	2147483647	√		null
resource_ext	condition_note	varchar	2147483647	√		null
agreement_form_config	config	varchar	2147483647			'{"version":"1.0","general":{"pageSize":"letter","units":"in","margin":".5"},"title":{"text":"WebCheckout Agreement","align":"right","logo":"","logoAlign":"left"},"header":{"patron":{"name":true,"ID":false,"telephone":true,"email":true,"address":false,"address2":false,"cityStateZip":false,"contactPerson":true,"barcode":false,"department":false},"operator":"operator ID","eventTitle":false,"renewal":false},"contents":{"active":[{"key":"item","header":"Item","width":"1.5","specifier":"id"},{"key":"desc","header":"Description","width":"2.5","rType":true,"topLevelRType":false,"homeLocation":true,"accessories":false,"components":true,"mediaTitle":false},{"key":"qty","header":"Qty","width":".875"},{"key":"return","header":"Return Time","width":".875"},{"key":"fee","header":"Est''d fee","width":".875"},{"key":"feeSubtotal","header":"Est''d subtotal","width":".875"}],"inactive":[{"key":"aggValue","header":"Aggregate Value","width":".5"},{"key":"condition","header":"Condition Note","width":".5"}]},"footer":{"notes":true,"setup":false,"feeTotal":false},"signatory":{"accompany":false}}'::character varying
organization	constrain_account_codes	bool	1	√		null
subscription_contact	contact_data	varchar	2147483647
allocation	contact_name_string	varchar	2147483647	√		null
person	contact_note	varchar	2147483647	√		null
person_ext	contact_note	varchar	2147483647	√		null
allocation	contact_person	int8	19	√		null		person.obj_oid fkcalloc_contact_person
allocation	contact_phone_string	varchar	2147483647	√		null
subscription_contact	contact_type	wcof_tag	2147483647
resource_ext	container_foreignid	varchar	2147483647	√		null
resource	containing_resource_oid	int8	19	√		null		resource.obj_oid fkres_cont_res
bibliographic_record	contributor	wcof_collated_string_list	2147483647	√		null
bibliographic_record_ext	contributor	varchar	2147483647	√		null
bibliographic_record	country	varchar	2147483647	√		null
bibliographic_record_ext	country	varchar	2147483647	√		null
department	country	varchar	2147483647	√		null
department_ext	country	varchar	2147483647	√		null
organization	country	varchar	2147483647	√		null
person	country	varchar	2147483647	√		null
person_ext	country	varchar	2147483647	√		null
wco_group	country	varchar	2147483647	√		null
bibliographic_record	course	varchar	2147483647	√		null
bibliographic_record_ext	course	varchar	2147483647	√		null
hold	created	timestamptz	35,6	√		null
integration_log	created	int8	19	√		null
invoice	created_by	int8	19	√		1		person.obj_oid fkcinvoice_created_by
invoice_line	created_by	int8	19	√		1		person.obj_oid fkinv_line_created_by
location_auto_email	created_reservation_cc	varchar	2147483647	√		null
location_auto_email	created_reservation_enabled	bool	1	√		null
invoice	creation_date	timestamptz	35,6	√		null
invoice_line	creation_date	timestamptz	35,6	√		null
allocation	creation_time	timestamptz	35,6	√		null
allocation	credit_card_type	varchar	2147483647	√		null
invoice	credit_card_type	varchar	2147483647	√		null
location	crestron_host	varchar	2147483647	√		null
location	crestron_port	int8	19	√		null
account_code_ext	csv_line_number	int4	10	√		null
bibliographic_record_ext	csv_line_number	int4	10	√		null
department_ext	csv_line_number	int4	10	√		null
group_ext	csv_line_number	int4	10	√		null
group_member_ext	csv_line_number	int4	10	√		null
person_ext	csv_line_number	int4	10	√		null
pir_auth_ext	csv_line_number	int4	10	√		null
resource_ext	csv_line_number	int4	10	√		null
resource_type_ext	csv_line_number	int4	10	√		null
location	custom_agreement_form_oid	int8	19	√		null
resource_controller	daily_sleep_time	timestamptz	35,6	√		null
resource_controller	daily_wake_time	timestamptz	35,6	√		null
dat_location	dat_oid	int4	10					default_allocation_times.obj_oid dat_location_dat_oid_fkey
dat_organization	dat_oid	int4	10					default_allocation_times.obj_oid dat_organization_dat_oid_fkey
inventory_event	date	timestamptz	35,6	√		null
person_location_signature	date	timestamptz	35,6	√		null
ticket_log	date	timestamptz	35,6	√		null
turndown	date	timestamptz	35,6	√		null
invoice	date_paid	timestamptz	35,6	√		null
ticket	date_returned	timestamptz	35,6	√		null
ticket	date_sent_out	timestamptz	35,6	√		null
location_schedule_node	day_number	int4	10
location	day_rollover	int4	10	√		null
organization	default_billing_type	wcof_tag	2147483647	√		null
location	default_delivery_type	wcof_tag	2147483647
resource_type	default_p	bool	1	√		null
location	default_resource_selector	wcof_tag	2147483647	√		null
account_code	deleted	bool	1	√		false
account_code_ext	deleted	varchar	2147483647	√		null
department	deleted	bool	1	√		null
department_ext	deleted	varchar	2147483647	√		null
integration_log	deleted	int8	19	√		null
person	deleted	bool	1	√		null
resource	deleted	bool	1			false
resource_type	deleted	bool	1	√		null
role	deleted	bool	1	√		false
sched_unpublished_shift	deleted	bool	1	√		null
wco_group	deleted	bool	1	√		null
calendar_allocation_fields	deliver_to	bool	1	√		null
coalesced_deliver_to_v	deliver_to	varchar	2147483647	√		null
allocation	deliver_to_oid	int8	19	√		null		resource.obj_oid fkcalloc_deliver_to_oid
allocation	deliver_to_string	varchar	2147483647	√		null
calendar_allocation_fields	delivery_people	bool	1	√		null
allocation	delivery_type	wcof_tag	2147483647	√		null
group_ext	department	varchar	2147483647	√		null
person	department	varchar	2147483647	√		null
person_ext	department	varchar	2147483647	√		null
pir_auth_ext	department	varchar	2147483647	√		null
account_code_ext	department_name	varchar	2147483647	√		null
account_code	department_oid	int8	19	√		null		department.obj_oid fkcdepartment_oid
department_code	department_oid	int8	19	√		null		department.obj_oid fkcdepartment_code_department_oid
agreement_form_config	description	varchar	2147483647	√		null
bibliographic_record	description	varchar	2147483647	√		null
bibliographic_record_ext	description	varchar	2147483647	√		null
file_attachment	description	varchar	2147483647	√		null
group_ext	description	varchar	2147483647	√		null
hold	description	varchar	2147483647	√		null
invoice	description	varchar	2147483647	√		null
invoice_line	description	varchar	2147483647	√		null
location	description	varchar	2147483647	√		null
resource	description	varchar	2147483647	√		null
resource_ext	description	varchar	2147483647	√		null
resource_type	description	varchar	2147483647	√		null
resource_type_ext	description	varchar	2147483647	√		null
sched_scheduling_group	description	varchar	2147483647	√		null
sched_staffed_location	description	varchar	2147483647	√		null
term	description	varchar	2147483647	√		null
ticket_log	description	varchar	2147483647	√		null
wco_group	description	varchar	2147483647	√		null
resource	destination	bool	1	√		null
resource_ext	destination	varchar	2147483647	√		null
resource_controller	device_id	varchar	2147483647	√		null
bibliographic_record	director	wcof_collated_string	2147483647	√		null
bibliographic_record_ext	director	varchar	2147483647	√		null
holding	distributor	varchar	2147483647	√		null
resource_ext	distributor	varchar	2147483647	√		null
invoice	due_date	timestamptz	35,6	√		null
organization	due_days	interval	49,6	√		null
allocation_reminder_interval	duration	interval	49,6
wco_http_event_log	edit_allocation_oid	int8	19	√		null
wco_request_log	edit_allocation_oid	int8	19	√		null
location_auto_email	edited_reservation_cc	varchar	2147483647	√		null
location_auto_email	edited_reservation_enabled	bool	1	√		null
pir_request_log	editing	bool	1	√		null
bibliographic_record	edition	varchar	2147483647	√		null
bibliographic_record_ext	edition	varchar	2147483647	√		null
wco_request_log	effective_operator_oid	int8	19	√		null
wco_http_event_log	elapsed	interval	49,6	√		null
department	email	varchar	2147483647	√		null
department_ext	email	varchar	2147483647	√		null
person	email	varchar	2147483647	√		null
person_ext	email	varchar	2147483647	√		null
wco_group	email	varchar	2147483647	√		null
person	email_local	varchar	2147483647	√		null
location	email_template_set	varchar	2147483647	√		null
default_allocation_times	end_application	wcof_tag	2147483647	√		null
group_ext	end_date	varchar	2147483647	√		null
wco_group	end_date	timestamptz	35,6	√		null
allocation	end_time	timestamptz	35,6	√		null
allocation_repeat_rule	end_time	timestamptz	35,6	√		null
integration_log	end_time	timestamptz	35,6	√		null
resource_schedule	end_time	timestamptz	35,6	√		null
sched_published_shift	end_time	timestamptz	35,6	√		null
sched_staff_availability	end_time	timestamptz	35,6	√		null
sched_unpublished_shift	end_time	timestamptz	35,6	√		null
wco_task_log	end_time	timestamptz	35,6	√		null
location_schedule_node	end_time_minutes	int4	10	√		null
default_allocation_times	end_tod_minutes	int4	10	√		null
subscription	entity_oid	int8	19	√		null
subscription	entity_type	varchar	2147483647	√		null
bibliographic_record	era	varchar	2147483647			'AD'::character varying
bibliographic_record_ext	era	varchar	2147483647	√		null
ticket	est_close_date	timestamptz	35,6	√		null
allocation	event_description	varchar	2147483647	√		null
calendar_allocation_fields	event_description	bool	1	√		null
invoice	event_description	varchar	2147483647	√		null
group_authorization	expire	timestamptz	35,6	√		null
group_member	expire	timestamptz	35,6	√		null
group_member_ext	expire	varchar	2147483647	√		null
allocation	expire_time	timestamptz	35,6	√		null
hold	expires	timestamptz	35,6	√		null
person	expires	timestamptz	35,6	√		null
person_ext	expires	varchar	2147483647	√		null
wco_group	facility_oid	int8	19	√		null		resource.obj_oid fkcwco_group_facility_oid
resource_type_fallback	fallback_oid	int8	19					resource_type.obj_oid resource_type_fallback_fallback_oid_fkey
department	fax	varchar	2147483647	√		null
department_ext	fax	varchar	2147483647	√		null
person	fax	varchar	2147483647	√		null
person_ext	fax	varchar	2147483647	√		null
wco_group	fax	varchar	2147483647	√		null
resource_ext	file_id	varchar	2147483647	√		null
file_attachment	file_name	varchar	2147483647
file_attachment	file_size	int8	19
import_session	files	_varchar	2147483647			ARRAY[]::character varying[]
allocation_staffing	filled	bool	1	√		null
organization	fine_account	varchar	2147483647	√		null
person	first_name	varchar	2147483647	√		null
person_ext	first_name	varchar	2147483647	√		null
group_ext	foreignid	varchar	2147483647	√		null
resource	foreignid	varchar	2147483647	√		null
wco_group	foreignid	varchar	2147483647	√		null
location	form_date_time_format	wcof_tag	2147483647
bibliographic_record	format	varchar	2147483647	√		null
bibliographic_record_ext	format	varchar	2147483647	√		null
calendar_allocation_fields	freelancers	bool	1	√		null
resource_container_tcm	gen	int8	19	√		null
resource_location_tcm	gen	int8	19	√		null
rtype_tree_tcm	gen	int8	19	√		null
bibliographic_record	genre	varchar	2147483647	√		null
bibliographic_record_ext	genre	varchar	2147483647	√		null
pir_request_log	get_parameters	_varchar	2147483647	√		null
wco_http_event_log	get_parameters	_varchar	2147483647	√		null
wco_request_log	get_parameters	_varchar	2147483647	√		null
group_member_ext	group_foreignid	varchar	2147483647	√		null
pir_auth_ext	group_foreignid	varchar	2147483647	√		null
group_authorization	group_oid	int8	19					group_member.group_oid authorization_group_fkeys wco_group.obj_oid group_authorization_group_oid_fkey
group_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_member	group_oid	int8	19					wco_group.obj_oid group_set_member_group_oid_fkey
group_set_member	group_set_oid	int8	19					group_set.obj_oid group_set_member_group_set_oid_fkey
allocation_freelancer	hash	varchar	2147483647
authentication	hash	varchar	2147483647	√		null
bibliographic_record_helix	helix_content_key	varchar	2147483647	√		null
bibliographic_record_helix_ext	helix_content_key	varchar	2147483647	√		null
bibliographic_record_helix	helix_guid	varchar	2147483647	√		null
bibliographic_record_helix_ext	helix_guid	varchar	2147483647	√		null
bibliographic_record_helix_ext	helix_path	varchar	2147483647	√		null
invoice	hold_date	timestamptz	35,6	√		null
organization	hold_days	interval	49,6	√		null
hold	hold_type	varchar	2147483647	√		null
resource	home_location_path	varchar	2147483647	√		null
resource_ext	home_location_string	varchar	2147483647	√		null
organization	honor_external_fines	_int4	10			ARRAY[]::integer[]
organization	honor_external_holds	_int4	10			ARRAY[]::integer[]
allocation	id	varchar	2147483647	√		null
calendar_allocation_fields	id	bool	1	√		null
bibliographic_record	identifier	varchar	2147483647
bibliographic_record_ext	identifier	varchar	2147483647	√		null
resource_type	image_url	varchar	2147483647	√		null
resource_type_ext	image_url	varchar	2147483647	√		null
wco_http_event_log	imho_element	varchar	2147483647	√		null
wco_response_log	imho_element	varchar	2147483647	√		null
wco_log	instance	int8	19	√		null
group_ext	instructor_foreignid	varchar	2147483647	√		null
wco_group	instructor_oid	int8	19	√		null		person.obj_oid fkcwco_group_instructor_oid
resource_ext	inventory_date	varchar	2147483647	√		null
invoice	invoice_id	varchar	2147483647	√		null
invoice_line_tax_rate	invoice_line_oid	int8	19	√		null		invoice_line.obj_oid invoice_line_tax_rate_invoice_line_oid_fkey
hold	invoice_oid	int8	19	√		null		invoice.obj_oid fkchold_invoice_oid
invoice_charges	invoice_oid	int8	19	√		null
invoice_line	invoice_oid	int8	19	√		null		invoice.obj_oid invoice_line_invoice_oid_fkey
invoice_payments	invoice_oid	int8	19	√		null
invoice_tax_rate	invoice_oid	int8	19	√		null		invoice.obj_oid invoice_tax_rate_invoice_oid_fkey
invoices_pending_export	invoice_oid	int8	19	√		null		invoice.obj_oid invoices_pending_export_invoice_oid_fkey
invoice	invoice_status	wcof_tag	2147483647	√		null
wco_log	ip_addr	int8	19	√		null
allocation_route	is_automatic	bool	1	√		null
allocation_route	is_record	bool	1	√		null
allocation	is_show	bool	1	√		null
calendar_allocation_fields	is_show	bool	1	√		null
resource_controller	is_sink	bool	1	√		null
resource_controller	is_source	bool	1	√		null
bibliographic_record	isbn	wcof_isbn_number	2147483647	√		null
bibliographic_record_ext	isbn	varchar	2147483647	√		null
wco_group	job_numbers	varchar	2147483647	√		null
string_map	key	varchar	2147483647
resource	label_id	varchar	2147483647	√		null
resource_ext	label_id	varchar	2147483647	√		null
bibliographic_record	language	varchar	2147483647	√		null
bibliographic_record_ext	language	varchar	2147483647	√		null
resource	last_inventoried_date	timestamptz	35,6	√		null
person	last_name	varchar	2147483647	√		null
person_ext	last_name	varchar	2147483647	√		null
allocation	last_renewal	timestamptz	35,6	√		null
allocation_freelancer	last_sent_mail	wcof_tag	2147483647	√		null
resource_controller	last_sleep_time	timestamptz	35,6	√		null
resource_controller	last_wake_time	timestamptz	35,6	√		null
late_returns	late_returns	int8	19	√		null
person	late_returns	int8	19	√		null
bibliographic_record	loc_control_number	varchar	2147483647	√		null
bibliographic_record_ext	loc_control_number	varchar	2147483647	√		null
wco_log	loc_oid	int8	19	√		null		location.obj_oid fkcwco_log_loc_oid
resource_ext	location	varchar	2147483647	√		null
agreement_form_config	location_oid	int8	19	√		null		location.obj_oid agreement_form_config_location_oid
allocation	location_oid	int8	19	√		null		location.obj_oid fkcalloc_location_oid
allocation_reminder_interval	location_oid	int8	19					location.obj_oid fkcallocation_reminder_interval_location
authset_location	location_oid	int4	10					location.obj_oid fkauthset_location_location_oid
calendar_allocation_fields	location_oid	int8	19	√		null		location.obj_oid calendar_allocation_fields_location_oid_fkey
dat_location	location_oid	int8	19					location.obj_oid dat_location_location_oid_fkey
freelancer_person_location	location_oid	int8	19	√		null		location.obj_oid fkcfreelancer_person_location_location_oid
location_auto_email	location_oid	int8	19	√		null		location.obj_oid fkextlocation_oid
location_pir_pickup_option	location_oid	int8	19	√		null		location.obj_oid location_pir_pickup_option_location_oid_fkey
location_schedule	location_oid	int4	10	√		null		location.obj_oid fkclocation_schedule_location
person_location_signature	location_oid	int8	19	√		null		location.obj_oid person_location_signature_location_oid_fkey
pir_person_location	location_oid	int8	19	√		null		location.obj_oid fkcpir_location_location_oid
pir_request_log	location_oid	int8	19	√		null		location.obj_oid fkcpir_request_log_location_oid
resource	location_oid	int8	19					location.obj_oid resource_location_oid_fkey
role	location_oid	int8	19			1
wco_request_log	location_oid	int8	19	√		null
wco_station	location_oid	int8	19	√		null		location.obj_oid fkcwco_station_location_oid
resource	location_resource_oid	int8	19	√		null		resource.obj_oid fkcres_loc_res
location_schedule_node	location_schedule_oid	int4	10					location_schedule.obj_oid fkclocation_schedule_node_location_schedule
wco_http_event_log	locked_allocations	_varchar	2147483647	√		null
wco_request_log	locked_allocations	_varchar	2147483647	√		null
wco_response_log	locked_allocations	_varchar	2147483647	√		null
wco_log	log_text	varchar	2147483647	√		null
wco_request_log	login_operator_oid	int8	19	√		null
resource	mac_address	varchar	2147483647	√		null
resource_ext	mac_address	varchar	2147483647	√		null
mail_event	mail_type	wcof_tag	2147483647	√		null
wco_group	maintenance_contract_notes	varchar	2147483647	√		null
wco_group	maintenance_contract_number	varchar	2147483647	√		null
sched_staff	manager	bool	1	√		null
resource	manufacturer	varchar	2147483647	√		null
resource_ext	manufacturer	varchar	2147483647	√		null
agreement_form_config	markup	varchar	2147483647			'The undersigned acknowledges receiving the listed equipment in good condition and accepts full liability for damage or loss including concealed or unreported damage discovered after return.'::character varying
resource	max_quantity	int4	10	√		null
subscription_notification	message	varchar	2147483647	√		null
organization	messaging_from_address	varchar	2147483647	√		null
resource	metaclass	wcof_tag	2147483647
resource_ext	metaclass	varchar	2147483647	√		null
resource	model	varchar	2147483647	√		null
resource_ext	model	varchar	2147483647	√		null
group_member	modified	timestamptz	35,6	√		null
invoice	modified	timestamptz	35,6	√		null
invoice_line	modified	timestamptz	35,6	√		null
person	modified	timestamptz	35,6	√		null
resource	modified	timestamptz	35,6	√		null
resource_type	modified	timestamptz	35,6	√		null
wco_group	modified	timestamptz	35,6	√		null
invoice	modified_by	int8	19	√		null		person.obj_oid fkcinvoice_modified_by
invoice_line	modified_by	int8	19	√		1		person.obj_oid fkinv_line_modified_by
wco_application	motd_text	varchar	2147483647	√		null
wco_application	multiple_ip	bool	1	√		null
agreement_form_config	name	varchar	2147483647			'Agreement Form'::character varying
department	name	varchar	2147483647
department_ext	name	varchar	2147483647	√		null
group_ext	name	varchar	2147483647	√		null
location	name	varchar	2147483647
operator_authorization	name	wcof_tag	2147483647
operator_role	name	wcof_tag	2147483647
organization	name	varchar	2147483647	√		null
organization_credit_card_type	name	varchar	2147483647	√		null
resource_type	name	varchar	2147483647	√		null
resource_type_ext	name	varchar	2147483647	√		null
role	name	varchar	2147483647	√		null
sched_published_shift	name	varchar	2147483647	√		null
sched_scheduling_group	name	varchar	2147483647
sched_staff_availability	name	varchar	2147483647	√		null
sched_staffed_location	name	varchar	2147483647
sched_unpublished_shift	name	varchar	2147483647	√		null
tax_rate	name	varchar	10
term	name	varchar	2147483647	√		null
ticket_problem_type	name	varchar	2147483647	√		null
ticket_remedy_type	name	varchar	2147483647	√		null
wco_group	name	varchar	2147483647	√		null
wco_station	name	varchar	2147483647	√		null
allocation	nonexpiring	bool	1	√		null
account_code	note	varchar	2147483647	√		null
account_code_ext	note	varchar	2147483647	√		null
allocation	note	varchar	2147483647	√		null
calendar_allocation_fields	note	bool	1	√		null
department_code	note	varchar	2147483647	√		null
person	note	varchar	2147483647	√		null
person_ext	note	varchar	2147483647	√		null
wco_group	note	varchar	2147483647	√		null
sched_published_shift	notes	varchar	2147483647	√		null
sched_unpublished_shift	notes	varchar	2147483647	√		null
account_code	obj_oid	int8	19
account_code_ext	obj_oid	int8	19
agreement_form_config	obj_oid	int8	19
allocation	obj_oid	int8	19				allocation_freelancer.allocation_oid fkcallocation_freelancer_allocation_oid allocation_group.allocation_oid allocation_group_allocation_oid_fkey allocation_group.source_allocation_oid fkcalloc_group_src_alloc_oid allocation_log.allocation_oid fkcalloc_log_alloc_oid allocation_person.allocation_oid allocation_person_allocation_oid_fkey allocation_repeat_rule.allocation_oid allocation_repeat_rule_allocation_oid_fkey allocation_route.allocation_oid allocation_route_allocation_oid_fkey allocation_route_message.allocation_oid allocation_route_message_allocation_oid_fkey allocation_staffing.allocation_oid fkallocation_staffing_allocation_oid allocation_task.allocation_oid allocation_task_allocation_oid_fkey invoice.allocation_oid fkcinvoice_alloc_oid mail_event.allocation_oid fkmail_event_alloc_oid pir_request_log.allocation_oid fkpir_request_log_allocation_oid pir_request_log.unsaved_allocation_oid fkpir_request_log_unsaved_allocation_oid resource_schedule.allocation_oid fkcresource_schedule_alloc_oid turndown.allocation_oid turndown_allocation_oid_fkey
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
authset	obj_oid	int4	10				authset_authorization.authset_oid fkauthset_authorization_authset_oid authset_location.authset_oid fkauthset_location_authset_oid
authset_authorization	obj_oid	int4	10
authset_location	obj_oid	int4	10
bibliographic_record	obj_oid	int8	19				bibliographic_record_helix.bibliographic_record_oid fkbiblio_record_oid holding.bibliographic_record_oid fkholding_bibliographic_record
bibliographic_record_ext	obj_oid	int8	19
bibliographic_record_helix	obj_oid	int8	19
calendar_allocation_fields	obj_oid	int8	19
calendar_authentication	obj_oid	int8	19
circulation_policy	obj_oid	int8	19
dat_location	obj_oid	int4	10
dat_organization	obj_oid	int4	10
default_allocation_times	obj_oid	int4	10				dat_location.dat_oid dat_location_dat_oid_fkey dat_organization.dat_oid dat_organization_dat_oid_fkey
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
department_ext	obj_oid	int8	19
file_attachment	obj_oid	int8	19
freelancer_person_location	obj_oid	int8	19
group_authorization	obj_oid	int8	19
group_member	obj_oid	int8	19
group_resource_type	obj_oid	int8	19
group_set	obj_oid	int8	19				group_set_member.group_set_oid group_set_member_group_set_oid_fkey
hold	obj_oid	int8	19
holding	obj_oid	int8	19
import_session	obj_oid	int8	19
integration_log	obj_oid	int8	19
inventory_event	obj_oid	int8	19
invoice	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
location	obj_oid	int8	19				agreement_form_config.location_oid agreement_form_config_location_oid allocation.location_oid fkcalloc_location_oid allocation_reminder_interval.location_oid fkcallocation_reminder_interval_location authset_location.location_oid fkauthset_location_location_oid calendar_allocation_fields.location_oid calendar_allocation_fields_location_oid_fkey dat_location.location_oid dat_location_location_oid_fkey freelancer_person_location.location_oid fkcfreelancer_person_location_location_oid invoice.cc_oid fkcinvoice_cc_oid location_auto_email.location_oid fkextlocation_oid location_pir_pickup_option.location_oid location_pir_pickup_option_location_oid_fkey location_schedule.location_oid fkclocation_schedule_location person_location_signature.location_oid person_location_signature_location_oid_fkey pir_person_location.location_oid fkcpir_location_location_oid pir_request_log.location_oid fkcpir_request_log_location_oid resource.location_oid resource_location_oid_fkey wco_log.loc_oid fkcwco_log_loc_oid wco_station.location_oid fkcwco_station_location_oid
location_auto_email	obj_oid	int8	19
location_pir_pickup_option	obj_oid	int8	19
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
mail_event	obj_oid	int8	19
organization	obj_oid	int8	19				authset.organization_oid fkauthset_organization_oid dat_organization.org_oid dat_organization_org_oid_fkey hold.organization_oid fkchold_organization_oid invoice.org_oid fkcinvoice_org_oid location.org_oid location_org_oid_fkey resource_type.org_oid fkcresource_type_org_oid sched_staffed_location.org_oid sched_staffed_location_org_oid_fkey tax_rate.organization_oid fk_taxrates_organization_oid wco_group.organization_oid fkcwco_group_organization_oid wco_log.org_oid fkcwco_log_org_oid
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 authset.person_oid fkauthset_person_oid department.billing_contact_oid fkcdepartment_billing_contact_oid file_attachment.upload_person_oid fkfile_attachment_upload_person_oid freelancer_person_location.person_oid fkcfreelancer_person_location_person_oid group_authorization.person_oid group_authorization_person_oid_fkey group_member.person_oid fkcgroup_member_person_oid hold.person_oid fkchold_person_oid inventory_event.agent_oid inventory_event_agent_oid_fkey invoice.created_by fkcinvoice_created_by invoice.modified_by fkcinvoice_modified_by invoice.person_oid fkcinvoice_person_oid invoice.real_payee fkcinvoice_real_payee invoice_line.created_by fkinv_line_created_by invoice_line.modified_by fkinv_line_modified_by organization.admin_id fkcorg_admin_id person_location_signature.person_oid person_location_signature_person_oid_fkey person_role.person_oid fkperson_role_person_oid pir_person_location.person_oid fkcpir_location_person_oid pir_request_log.patron_oid fkpir_request_log_patron_oid resource_schedule.return_agent_oid fkcresource_schedule_return_agent_oid sched_staff.person_oid sched_staff_person_oid_fkey sched_staff_availability.person_oid sched_staff_availability_person_oid_fkey subscription.person_oid fksubscription_person_oid ticket.agent_oid fkticket_agent ticket.patron_oid fkticket_patron ticket.responsible_op_oid fkticket_responsible_op ticket.vendor_oid fkticket_vendor ticket_log.agent_oid fkcticket_log_agent_oid turndown.patron_oid turndown_patron_oid_fkey wco_group.instructor_oid fkcwco_group_instructor_oid wco_group.teaching_assistant_oid fkcwco_group_teaching_assistant_oid wco_log.agent_oid fkcwco_log_agent_oid wco_log.responsible_agent_oid fkcwco_log_reps_agent_oid
person_ext	obj_oid	int8	19
person_location_signature	obj_oid	int8	19
person_role	obj_oid	int8	19
pir_auth_ext	obj_oid	int8	19
pir_person_location	obj_oid	int8	19
pir_request_log	obj_oid	int8	19
resource	obj_oid	int8	19				allocation.deliver_to_oid fkcalloc_deliver_to_oid allocation_route.sink_oid allocation_route_sink_oid_fkey allocation_route.source_oid allocation_route_source_oid_fkey holding.resource_oid fkholding_resource inventory_event.resource_oid inventory_event_resource_oid_fkey invoice_line.resource_oid fkinv_line_res resource.containing_resource_oid fkres_cont_res resource.location_resource_oid fkcres_loc_res resource_schedule.scheduled_resource_oid resource_schedule_scheduled_resource_oid_fkey ticket.resource_oid fkticket_res wco_group.facility_oid fkcwco_group_facility_oid
resource_controller	obj_oid	int8	19
resource_ext	obj_oid	int8	19
resource_schedule	obj_oid	int8	19
resource_sleep_queue	obj_oid	int8	19	√		null
resource_type	obj_oid	int8	19				circulation_policy.rtype_oid fkccirculation_policy_rtype_oid group_authorization.rtype_oid group_authorization_rtype_oid_fkey group_resource_type.rtype_oid group_resource_type_rtype_oid_fkey location.rtype_oid fkloc_rtype organization.rtype_oid fkorg_rtype resource.rtype_oid resource_rtype_oid_fkey resource_type_fallback.fallback_oid resource_type_fallback_fallback_oid_fkey resource_type_fallback.type_oid resource_type_fallback_type_oid_fkey
resource_type_ext	obj_oid	int8	19
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
sched_published_shift	obj_oid	int8	19				sched_unpublished_shift.published_shift_oid unpub_shift_staffed_loc_oid
sched_scheduling_group	obj_oid	int8	19				sched_published_shift.scheduling_group_oid published_sched_sched_group_oid sched_scheduling_group_member.scheduling_group_oid sched_scheduling_group_member_scheduling_group_oid_fkey sched_unpublished_shift.scheduling_group_oid unpub_sched_sched_group_oid
sched_scheduling_group_member	obj_oid	int8	19
sched_staff	obj_oid	int8	19				sched_published_shift.staff_oid shift_staff_oid sched_scheduling_group_member.staff_oid sched_scheduling_group_member_staff_oid_fkey sched_staffing_limit.staff_oid sched_staffing_limit_staff_oid_fkey sched_unpublished_shift.staff_oid unpub_shift_staff_oid
sched_staff_availability	obj_oid	int8	19
sched_staffed_location	obj_oid	int8	19				sched_published_shift.staffed_location_oid sched_published_shift_staffed_location_oid_fkey sched_scheduling_group.staffed_location_oid sched_scheduling_group_staffed_location_oid_fkey sched_staff.staffed_location_oid sched_staff_staffed_location_oid_fkey sched_unpublished_shift.staffed_location_oid sched_unpublished_shift_staffed_location_oid_fkey
sched_staffing_limit	obj_oid	int8	19
sched_unpublished_shift	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
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				group_authorization.group_oid group_authorization_group_oid_fkey group_member.group_oid fkcgroup_member_group_oid group_resource_type.group_oid group_resource_type_group_oid_fkey group_set_member.group_oid group_set_member_group_oid_fkey resource_type.open_group_oid fkcresource_type_open_group_oid
wco_log	obj_oid	int8	19
wco_request_log	obj_oid	int8	19
wco_response_log	obj_oid	int8	19
wco_station	obj_oid	int8	19
wco_task_log	obj_oid	int8	19
ticket	open_date	timestamptz	35,6	√		null
resource_type	open_group_oid	int8	19	√		null		wco_group.obj_oid fkcresource_type_open_group_oid
authset	operator_role_oid	int4	10	√		null		operator_role.obj_oid fkauthset_role_oid
dat_organization	org_oid	int8	19					organization.obj_oid dat_organization_org_oid_fkey
invoice	org_oid	int8	19	√		null		organization.obj_oid fkcinvoice_org_oid
location	org_oid	int8	19					organization.obj_oid location_org_oid_fkey
resource_type	org_oid	int8	19	√		null		organization.obj_oid fkcresource_type_org_oid
sched_staffed_location	org_oid	int8	19					organization.obj_oid sched_staffed_location_org_oid_fkey
wco_log	org_oid	int8	19	√		null		organization.obj_oid fkcwco_log_org_oid
group_ext	organization	varchar	2147483647	√		null
resource_type_ext	organization	varchar	2147483647	√		null
authset	organization_oid	int4	10					organization.obj_oid fkauthset_organization_oid
hold	organization_oid	int8	19	√		null		organization.obj_oid fkchold_organization_oid
person	organization_oid	int8	19	√		null
tax_rate	organization_oid	int8	19	√		null		organization.obj_oid fk_taxrates_organization_oid
turndown	organization_oid	int8	19	√		null
wco_group	organization_oid	int8	19	√		null		organization.obj_oid fkcwco_group_organization_oid
account_code	origin	varchar	2147483647
account_code_ext	origin	varchar	2147483647	√		null
bibliographic_record	origin	varchar	2147483647
bibliographic_record_ext	origin	varchar	2147483647	√		null
department	origin	varchar	2147483647
department_ext	origin	varchar	2147483647	√		null
group_ext	origin	varchar	2147483647	√		null
group_member	origin	varchar	2147483647
group_member_ext	origin	varchar	2147483647	√		null
import_session	origin	varchar	2147483647	√		null
person	origin	varchar	2147483647
person_ext	origin	varchar	2147483647	√		null
pir_auth_ext	origin	varchar	2147483647	√		null
resource	origin	varchar	2147483647
resource_ext	origin	varchar	2147483647	√		null
resource_type	origin	varchar	2147483647
resource_type_ext	origin	varchar	2147483647	√		null
wco_group	origin	varchar	2147483647
wco_request_log	origin	varchar	2147483647	√		null
allocation	original_agent_oid	int8	19	√		null		person.obj_oid fkallocation_original_agent_oid
person	other_name	varchar	2147483647	√		null
person_ext	other_name	varchar	2147483647	√		null
resource_type_ext	parent	varchar	2147483647	√		null
location_schedule	parent_oid	int4	10	√		null		location_schedule.obj_oid fkclocation_schedule_parent
resource_type	parent_oid	int8	19	√		null
resource_parent	parent_resource_oid	int8	19	√		null
authentication	password	varchar	2147483647	√		null
person_ext	password	varchar	2147483647	√		null
resource_type	path	varchar	2147483647	√		null
allocation	patron_class	wcof_tag	2147483647	√		null
circulation_policy	patron_class	wcof_tag	2147483647	√		null
person	patron_class	wcof_tag	2147483647	√		null
person_ext	patron_class	varchar	2147483647	√		null
pir_auth_ext	patron_class	varchar	2147483647	√		null
pir_auth_ext	patron_foreignid	varchar	2147483647	√		null
calendar_allocation_fields	patron_name	bool	1	√		null
allocation	patron_oid	int8	19	√		null		person.obj_oid fkcalloc_patron_oid
late_returns	patron_oid	int8	19	√		null
pir_request_log	patron_oid	int8	19	√		null		person.obj_oid fkpir_request_log_patron_oid
ticket	patron_oid	int8	19	√		null		person.obj_oid fkticket_patron
turndown	patron_oid	int8	19	√		null		person.obj_oid turndown_patron_oid_fkey
allocation	payee_oid	int8	19	√		null		person.obj_oid fkcalloc_payee_oid
invoice	paying_account	varchar	2147483647	√		null
allocation	paying_department_oid	int8	19	√		null		department.obj_oid fkcalloc_paying_department_oid
invoice	paying_dept_oid	int8	19	√		null		department.obj_oid fkcinvoice_paying_dept_oid
invoice	payment_rule	wcof_tag	2147483647	√		null
allocation	payment_type	wcof_tag	2147483647	√		null
bibliographic_record	performers	wcof_collated_string_list	2147483647	√		null
bibliographic_record_ext	performers	varchar	2147483647	√		null
wco_group	period	varchar	2147483647	√		null
group_member_ext	person_foreignid	varchar	2147483647	√		null
allocation_freelancer	person_oid	int8	19					person.obj_oid fkcallocation_freelancer_person_oid
allocation_person	person_oid	int8	19	√		null		person.obj_oid fkcalloc_person_person_oid
authset	person_oid	int4	10					person.obj_oid fkauthset_person_oid
calendar_authentication	person_oid	int4	10
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
sched_staff	person_oid	int8	19					person.obj_oid sched_staff_person_oid_fkey
sched_staff_availability	person_oid	int8	19					person.obj_oid sched_staff_availability_person_oid_fkey
subscription	person_oid	int8	19					person.obj_oid fksubscription_person_oid
person	person_type	varchar	2147483647	√		null
wco_group	phone	varchar	2147483647	√		null
location	pickup_default	wcof_tag	2147483647
allocation	pickup_instructions	varchar	2147483647	√		null
calendar_allocation_fields	pickup_instructions	bool	1	√		null
allocation	pickup_option	wcof_tag	2147483647	√		null
calendar_allocation_fields	pickup_option	bool	1	√		null
location_pir_pickup_option	pickup_option	wcof_tag	2147483647	√		null
location_auto_email	pickup_reservation_cc	varchar	2147483647	√		null
location_auto_email	pickup_reservation_enabled	bool	1	√		null
authentication	pin	varchar	2147483647	√		null
authentication	pin_hash	varchar	2147483647	√		null
location	pir_media_cc_query	bool	1	√		null
location	pir_mode	wcof_tag	2147483647	√		null
location	pir_motd	varchar	2147483647	√		null
wco_application	pir_motd	varchar	2147483647	√		null
resource_type	pir_p	bool	1	√		true
resource_type_ext	pir_p	varchar	2147483647	√		null
location	pir_requires_approval	bool	1	√		null
location	pir_restrict_delivery_locations	bool	1	√		null
location	pir_session_timeout	int4	10			15
allocation	po_number	varchar	2147483647	√		null
invoice	po_number	varchar	2147483647	√		null
circulation_policy	policy_class	wcof_tag	2147483647	√		null
circulation_policy	policy_value	varchar	2147483647	√		null
pir_request_log	post_parameters	_varchar	2147483647	√		null
wco_http_event_log	post_parameters	_varchar	2147483647	√		null
wco_request_log	post_parameters	_varchar	2147483647	√		null
department	postal_code	varchar	2147483647	√		null
department_ext	postal_code	varchar	2147483647	√		null
organization	postal_code	varchar	2147483647	√		null
person	postal_code	varchar	2147483647	√		null
person_ext	postal_code	varchar	2147483647	√		null
wco_group	postal_code	varchar	2147483647	√		null
location	print_queue	varchar	2147483647	√		'wco_local'::character varying
wco_station	print_queue	varchar	2147483647	√		null
location	print_template_set	varchar	2147483647	√		null
ticket	priority	int8	19	√		null
ticket	problem_type	varchar	2147483647	√		null
bibliographic_record	producer	wcof_collated_string	2147483647	√		null
bibliographic_record_ext	producer	varchar	2147483647	√		null
bibliographic_record	program_type	varchar	2147483647	√		null
bibliographic_record_ext	program_type	varchar	2147483647	√		null
allocation	project_code	varchar	2147483647	√		null
invoice	project_code	varchar	2147483647	√		null
wco_application	ps_accepted_terms	varchar	2147483647	√		null
bibliographic_record	publication_year	int8	19	√		null
bibliographic_record_ext	publication_year	varchar	2147483647	√		null
sched_unpublished_shift	published_shift_oid	int8	19	√		null		sched_published_shift.obj_oid unpub_shift_staffed_loc_oid
bibliographic_record	publisher	varchar	2147483647	√		null
bibliographic_record_ext	publisher	varchar	2147483647	√		null
resource	purchase_date	timestamptz	35,6	√		null
resource_ext	purchase_date	varchar	2147483647	√		null
resource	purchase_order	varchar	2147483647	√		null
resource_ext	purchase_order	varchar	2147483647	√		null
ticket	purchase_order	varchar	2147483647	√		null
invoice_line	quantity	int8	19	√		null
wco_http_event_log	query_path	varchar	2147483647	√		null
wco_request_log	query_path	varchar	2147483647	√		null
tax_rate	rate	numeric	131089
invoice	ready_to_bill	bool	1	√		null
allocation	real_end_time	timestamptz	35,6	√		null
resource_schedule	real_end_time	timestamptz	35,6	√		null
invoice	real_payee	int8	19	√		null		person.obj_oid fkcinvoice_real_payee
allocation	reference_id	varchar	2147483647	√		null
invoice	reference_id	varchar	2147483647	√		null
group_ext	registration_code	varchar	2147483647	√		null
allocation_task	related_types	varchar	2147483647	√		null
allocation_person	relation	wcof_tag	2147483647	√		null
ticket	remedy_type	varchar	2147483647	√		null
allocation	renewal_count	int8	19	√		null
ticket	repair_cost	odcl_money	2147483647	√		null
ticket	repair_cost_labor	odcl_money	2147483647	√		null
ticket	repair_cost_note	varchar	2147483647	√		null
ticket	repair_cost_parts	odcl_money	2147483647	√		null
ticket	repair_price	odcl_money	2147483647	√		null
ticket	repair_warranty_labor	varchar	2147483647	√		null
ticket	repair_warranty_parts	varchar	2147483647	√		null
location	repeats_in_pir	bool	1	√		null
resource	replacement_date	timestamptz	35,6	√		null
resource_ext	replacement_date	varchar	2147483647	√		null
wco_http_event_log	request_oid	int8	19	√		null
wco_http_event_log	request_time_stamp	timestamptz	35,6	√		null
wco_request_log	request_token	varchar	2147483647	√		null
wco_response_log	request_token	varchar	2147483647	√		null
resource_schedule	requested_rtype_oid	int8	19	√		null
location	require_signature_on_file	bool	1	√		false
allocation_staffing	required_staff	int4	10
resource_schedule	requires_building_pass	bool	1	√		false
ticket	resolution	wcof_tag	2147483647	√		null
holding	resource_oid	int8	19					resource.obj_oid fkholding_resource
inventory_event	resource_oid	int8	19	√		null		resource.obj_oid inventory_event_resource_oid_fkey
invoice_line	resource_oid	int8	19	√		null		resource.obj_oid fkinv_line_res
resource_parent	resource_oid	int8	19	√		null
ticket	resource_oid	int8	19	√		null		resource.obj_oid fkticket_res
calendar_allocation_fields	resource_types	bool	1	√		null
calendar_allocation_fields	resources	bool	1	√		null
wco_http_event_log	response_oid	int8	19	√		null
wco_http_event_log	response_time_stamp	timestamptz	35,6	√		null
wco_log	responsible_agent_oid	int8	19	√		1		person.obj_oid fkcwco_log_reps_agent_oid
ticket	responsible_op_oid	int8	19	√		1		person.obj_oid fkticket_responsible_op
organization	restricted	bool	1	√		null
holding	restrictions	varchar	2147483647	√		null
resource_ext	restrictions	varchar	2147483647	√		null
import_session	result	int8	19	√		null
resource_schedule	return_agent_oid	int8	19	√		1		person.obj_oid fkcresource_schedule_return_agent_oid
location_auto_email	return_checkout_cc	varchar	2147483647	√		null
location_auto_email	return_checkout_enabled	bool	1	√		null
location	return_default	wcof_tag	2147483647
allocation	return_option	wcof_tag	2147483647	√		null
allocation_freelancer_assigned	role_oid	int8	19					role.obj_oid fkcallocation_freelancer_role_oid
allocation_freelancer_role	role_oid	int8	19					role.obj_oid fkcallocation_freelancer_role_oid
allocation_staffing	role_oid	int8	19					role.obj_oid fkallocation_staffing_role_oid
person_role	role_oid	int8	19	√		null		role.obj_oid fkperson_role_role_oid
resource	roles	_varchar	2147483647			ARRAY[]::character varying[]
location	room	varchar	2147483647	√		null
sched_staffed_location	room	varchar	2147483647	√		null
resource	room_number	varchar	2147483647	√		null
resource_ext	room_number	varchar	2147483647	√		null
resource_ext	rtid	varchar	2147483647	√		null
resource_type	rtid	varchar	2147483647
resource_type_ext	rtid	varchar	2147483647	√		null
circulation_policy	rtype_oid	int8	19	√		null		resource_type.obj_oid fkccirculation_policy_rtype_oid
group_authorization	rtype_oid	int8	19					resource_type.obj_oid group_authorization_rtype_oid_fkey
group_resource_type	rtype_oid	int8	19					resource_type.obj_oid group_resource_type_rtype_oid_fkey
location	rtype_oid	int8	19	√		null		resource_type.obj_oid fkloc_rtype
organization	rtype_oid	int8	19	√		null		resource_type.obj_oid fkorg_rtype
resource	rtype_oid	int8	19					resource_type.obj_oid resource_rtype_oid_fkey
rrt_bundle	rtype_oid	int8	19
turndown	rtype_oid	int8	19	√		null
allocation_group	rule_oid	int8	19	√		null		allocation_repeat_rule.obj_oid fkcalloc_group_rule_oid
bibliographic_record	run_time	int8	19	√		null
bibliographic_record_ext	run_time	varchar	2147483647	√		null
authentication	salt	varchar	2147483647	√		null
location_schedule	schedule_end	timestamptz	35,6	√		null
location_schedule	schedule_length	int4	10	√		null
location_schedule	schedule_name	varchar	2147483647	√		null
location_schedule	schedule_start	timestamptz	35,6	√		null
location_schedule	schedule_type	wcof_tag	2147483647
resource_schedule	scheduled_resource_oid	int8	19					resource.obj_oid resource_schedule_scheduled_resource_oid_fkey
sched_published_shift	scheduling_group_oid	int8	19	√		null		sched_scheduling_group.obj_oid published_sched_sched_group_oid
sched_scheduling_group_member	scheduling_group_oid	int8	19					sched_scheduling_group.obj_oid sched_scheduling_group_member_scheduling_group_oid_fkey
sched_unpublished_shift	scheduling_group_oid	int8	19	√		null		sched_scheduling_group.obj_oid unpub_sched_sched_group_oid
wco_application	schema_version	int8	19	√		null
wco_response_log	seconds_used	float8	17,17	√		null
organization	semester_end	timestamptz	35,6	√		null
organization	semester_start	timestamptz	35,6	√		null
mail_event	send_time	timestamptz	35,6	√		null
allocation_group	seq_no	int8	19	√		null
resource	serial_number	varchar	2147483647	√		null
resource_ext	serial_number	varchar	2147483647	√		null
bibliographic_record	series_title	wcof_collated_string	2147483647	√		null
bibliographic_record_ext	series_title	varchar	2147483647	√		null
bibliographic_record	series_volume_number	varchar	2147483647	√		null
bibliographic_record_ext	series_volume_number	varchar	2147483647	√		null
pir_request_log	sessionid	varchar	2147483647	√		null
wco_http_event_log	sessionid	varchar	2147483647	√		null
wco_request_log	sessionid	varchar	2147483647	√		null
wco_response_log	sessionid	varchar	2147483647	√		null
ticket	severity	wcof_tag	2147483647	√		null
holding	shelf_location	varchar	2147483647	√		null
resource_ext	shelf_location	varchar	2147483647	√		null
allocation_route	sink_oid	int8	19					resource.obj_oid allocation_route_sink_oid_fkey
bibliographic_record	sound	varchar	2147483647	√		null
bibliographic_record_ext	sound	varchar	2147483647	√		null
bibliographic_record	source	varchar	2147483647	√		null
bibliographic_record_ext	source	varchar	2147483647	√		null
allocation_group	source_allocation_oid	int8	19	√		null		allocation.obj_oid fkcalloc_group_src_alloc_oid
allocation_route	source_oid	int8	19					resource.obj_oid allocation_route_source_oid_fkey
sched_published_shift	staff_oid	int8	19	√		null		sched_staff.obj_oid shift_staff_oid
sched_scheduling_group_member	staff_oid	int8	19					sched_staff.obj_oid sched_scheduling_group_member_staff_oid_fkey
sched_staffing_limit	staff_oid	int8	19					sched_staff.obj_oid sched_staffing_limit_staff_oid_fkey
sched_unpublished_shift	staff_oid	int8	19	√		null		sched_staff.obj_oid unpub_shift_staff_oid
sched_published_shift	staffed_location_oid	int8	19					sched_staffed_location.obj_oid sched_published_shift_staffed_location_oid_fkey
sched_scheduling_group	staffed_location_oid	int8	19					sched_staffed_location.obj_oid sched_scheduling_group_staffed_location_oid_fkey
sched_staff	staffed_location_oid	int8	19					sched_staffed_location.obj_oid sched_staff_staffed_location_oid_fkey
sched_unpublished_shift	staffed_location_oid	int8	19					sched_staffed_location.obj_oid sched_unpublished_shift_staffed_location_oid_fkey
default_allocation_times	start_application	wcof_tag	2147483647	√		null
group_authorization	start_date	timestamptz	35,6	√		null
group_ext	start_date	varchar	2147483647	√		null
wco_group	start_date	timestamptz	35,6	√		null
allocation	start_time	timestamptz	35,6	√		null
allocation_repeat_rule	start_time	timestamptz	35,6	√		null
import_session	start_time	timestamptz	35,6	√		null
integration_log	start_time	timestamptz	35,6	√		null
resource_schedule	start_time	timestamptz	35,6	√		null
sched_published_shift	start_time	timestamptz	35,6	√		null
sched_staff_availability	start_time	timestamptz	35,6	√		null
sched_unpublished_shift	start_time	timestamptz	35,6	√		null
wco_task_log	start_time	timestamptz	35,6	√		null
location_schedule_node	start_time_minutes	int4	10	√		null
default_allocation_times	start_tod_minutes	int4	10	√		null
department	state	varchar	2147483647	√		null
department_ext	state	varchar	2147483647	√		null
organization	state	varchar	2147483647	√		null
person	state	varchar	2147483647	√		null
person_ext	state	varchar	2147483647	√		null
ticket	state	wcof_tag	2147483647	√		null
wco_group	state	varchar	2147483647	√		null
wco_request_log	station	varchar	2147483647	√		null
integration_log	status	varchar	2147483647	√		null
location_schedule_node	status	wcof_tag	2147483647
person	status	wcof_tag	2147483647	√		null
person_ext	status	varchar	2147483647	√		null
wco_http_event_log	status	int4	10	√		null
wco_response_log	status	int4	10	√		null
import_session	step	wcof_tag	2147483647	√		null
department	street	varchar	2147483647	√		null
department_ext	street	varchar	2147483647	√		null
organization	street	varchar	2147483647	√		null
person	street	varchar	2147483647	√		null
person_ext	street	varchar	2147483647	√		null
department	street2	varchar	2147483647	√		null
department_ext	street2	varchar	2147483647	√		null
organization	street2	varchar	2147483647	√		null
person	street2	varchar	2147483647	√		null
person_ext	street2	varchar	2147483647	√		null
invoice_line	struck	bool	1	√		null
resource_container_tcm	sub	int8	19	√		null
resource_location_tcm	sub	int8	19	√		null
rtype_tree_tcm	sub	int8	19	√		null
rrt_bundle	sub_rtype_oid	int8	19
bibliographic_record	subject	_varchar	2147483647			ARRAY[]::character varying[]
bibliographic_record_ext	subject	varchar	2147483647	√		null
subscription_contact	subscription_oid	int8	19					subscription.obj_oid fksubscription_notification_subscription
subscription_notification	subscription_oid	int8	19					subscription.obj_oid fksubscription_notification_subscription
invoice_line	subtype	wcof_tag	2147483647	√		null
ticket	summary	varchar	2147483647	√		null
resource_container_tcm	super	int8	19	√		null
resource_location_tcm	super	int8	19	√		null
rtype_tree_tcm	super	int8	19	√		null
organization	suppress_autopayment	bool	1	√		null
person	suppress_email	bool	1	√		null
wco_task_log	task_object	varchar	2147483647	√		null
allocation_task	task_time	timestamptz	35,6	√		null
allocation_task	task_type	wcof_tag	2147483647	√		null
invoice_line	tax	odcl_money	2147483647	√		null
invoice_line_tax_rate	tax_amount	odcl_money	2147483647	√		null
department	tax_exempt_number	varchar	2147483647	√		null
department_ext	tax_exempt_number	varchar	2147483647	√		null
invoice_line_tax_rate	tax_rate_oid	int8	19	√		null		tax_rate.obj_oid invoice_line_tax_rate_tax_rate_oid_fkey
invoice_tax_rate	tax_rate_oid	int8	19	√		null		tax_rate.obj_oid invoice_tax_rate_tax_rate_oid_fkey
account_code	taxable	bool	1	√		null
account_code_ext	taxable	varchar	2147483647	√		null
invoice	taxable	bool	1	√		null
wco_group	teaching_assistant_oid	int8	19	√		null		person.obj_oid fkcwco_group_teaching_assistant_oid
department	telephone	varchar	2147483647	√		null
department_ext	telephone	varchar	2147483647	√		null
location	telephone	varchar	2147483647	√		null
person	telephone	varchar	2147483647	√		null
person_ext	telephone	varchar	2147483647	√		null
sched_staffed_location	telephone	varchar	2147483647	√		null
person	telephone_local	varchar	2147483647	√		null
group_ext	term_foreignid	varchar	2147483647	√		null
allocation_log	text	varchar	2147483647	√		null
allocation_route_message	text	varchar	2147483647	√		null
location_auto_email	ticket_cc	varchar	2147483647	√		null
location_auto_email	ticket_enabled	bool	1	√		null
ticket_log	ticket_oid	int8	19	√		null		ticket.obj_oid fkcticket_log_ticket_oid
ticket	ticket_type	wcof_tag	2147483647	√		null
allocation_log	time	timestamptz	35,6	√		null
subscription_notification	time	timestamptz	35,6	√		null
sched_staffing_limit	time_limit	int8	19	√		null
pir_request_log	time_stamp	timestamptz	35,6	√		null
wco_log	time_stamp	timestamptz	35,6	√		null
wco_request_log	time_stamp	timestamptz	35,6	√		null
wco_response_log	time_stamp	timestamptz	35,6	√		null
location	timeline_granularity	int8	19	√		null
location	timeline_zoom_factor	int8	19	√		null
bibliographic_record	title	wcof_collated_string	2147483647	√		null
bibliographic_record_ext	title	varchar	2147483647	√		null
person	title	varchar	2147483647	√		null
calendar_authentication	token	varchar	2147483647	√		null
allocation_log	type	wcof_tag	2147483647	√		null
allocation_reminder_interval	type	wcof_tag	2147483647
allocation_repeat_rule	type	wcof_tag	2147483647	√		null
coalesced_deliver_to_v	type	text	2147483647	√		null
group_ext	type	varchar	2147483647	√		null
invoice_line	type	wcof_tag	2147483647	√		null
resource_schedule	type	wcof_tag	2147483647
sched_staffing_limit	type	varchar	2147483647	√		null
ticket_log	type	wcof_tag	2147483647	√		null
wco_group	type	wcof_tag	2147483647	√		null
invoice	type_of_payment	wcof_tag	2147483647	√		null
resource_type_fallback	type_oid	int8	19					resource_type.obj_oid resource_type_fallback_type_oid_fkey
wco_response_log	ui_allocation_next_state	wcof_tag	2147483647	√		null
wco_request_log	ui_current_allocation_oid	int8	19	√		null
pir_request_log	unsaved_allocation_oid	int8	19	√		null		allocation.obj_oid fkpir_request_log_unsaved_allocation_oid
resource	unserialized	bool	1	√		null
resource_ext	unserialized	varchar	2147483647	√		null
person	unused_reservations	int8	19	√		null
integration_log	updated	int8	19	√		null
file_attachment	upload_person_oid	int8	19					person.obj_oid fkfile_attachment_upload_person_oid
file_attachment	upload_time	timestamptz	35,6
resource	url	varchar	2147483647	√		null
resource_ext	url	varchar	2147483647	√		null
wco_group	url	varchar	2147483647	√		null
location	usage_exclude_closed	bool	1	√		null
allocation	use_charge_duration	bool	1	√		null
person	userid	varchar	2147483647	√		null
person_ext	userid	varchar	2147483647	√		null
resource_schedule	uuid	varchar	2147483647
resource	value	odcl_money	2147483647	√		null
resource_ext	value	varchar	2147483647	√		null
string_map	value	varchar	2147483647
resource	vendor	varchar	2147483647	√		null
resource_ext	vendor	varchar	2147483647	√		null
person	vendor_name	varchar	2147483647	√		null
ticket	vendor_oid	int8	19	√		1		person.obj_oid fkticket_vendor
wco_version	version	int8	19
wco_http_event_log	view_allocation_oid	int8	19	√		null
wco_request_log	view_allocation_oid	int8	19	√		null
resource	warranty_labor	varchar	2147483647	√		null
resource_ext	warranty_labor	varchar	2147483647	√		null
resource	warranty_parts	varchar	2147483647	√		null
resource_ext	warranty_parts	varchar	2147483647	√		null
pir_request_log	webmethod	varchar	2147483647	√		null
wco_request_log	webmethod	varchar	2147483647	√		null
person	weekly_max_hours	int8	19	√		null
import_session	what	wcof_tag	2147483647	√		null
wco_task_log	work_object	varchar	2147483647	√		null
wco_request_log	xhrmethod	varchar	2147483647	√		null