org_unit

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('actor.org_unit_id_seq'::regclass)
cancel_reason.org_unit cancel_reason_org_unit_fkey R
claim_event_type.org_unit claim_event_type_org_unit_fkey R
claim_policy.org_unit claim_policy_org_unit_fkey R
claim_type.org_unit claim_type_org_unit_fkey R
distribution_formula.owner distribution_formula_owner_fkey R
distribution_formula_entry.owning_lib distribution_formula_entry_owning_lib_fkey R
fund.org fund_org_fkey C
fund_allocation_percent.org fund_allocation_percent_org_fkey R
fund_tag.owner fund_tag_owner_fkey R
funding_source.owner funding_source_owner_fkey R
invoice.receiver invoice_receiver_fkey R
lineitem_alert_text.owning_lib lineitem_alert_text_owning_lib_fkey R
lineitem_detail.owning_lib lineitem_detail_owning_lib_fkey N
picklist.org_unit picklist_org_unit_fkey R
provider.owner provider_owner_fkey R
purchase_order.ordering_agency purchase_order_ordering_agency_fkey R
shipment_notification.receiver shipment_notification_receiver_fkey R
user_request.pickup_lib user_request_pickup_lib_fkey R
circulation.circ_lib action_circulation_circ_lib_fkey N
curbside.org curbside_org_fkey C
fieldset.owning_lib fieldset_owning_lib_fkey R
fieldset_group.owning_lib fieldset_group_owning_lib_fkey C
hold_request.current_shelf_lib hold_request_current_shelf_lib_fkey R
hold_request.fulfillment_lib hold_request_fulfillment_lib_fkey R
hold_request.pickup_lib hold_request_pickup_lib_fkey R
hold_request.request_lib hold_request_request_lib_fkey R
hold_request.selection_ou hold_request_selection_ou_fkey R
in_house_use.org_unit in_house_use_org_unit_fkey R
non_cat_in_house_use.org_unit non_cat_in_house_use_org_unit_fkey R
non_cataloged_circulation.circ_lib non_cataloged_circulation_circ_lib_fkey R
survey.owner survey_owner_fkey R
transit_copy.dest transit_copy_dest_fkey R
transit_copy.prev_dest transit_copy_prev_dest_fkey R
transit_copy.source transit_copy_source_fkey R
event.context_library event_context_library_fkey R
event_def_group.owner event_def_group_owner_fkey R
event_definition.owner event_definition_owner_fkey R
address_alert.owner address_alert_owner_fkey R
copy_alert_suppress.org copy_alert_suppress_org_fkey C
hours_of_operation.id hours_of_operation_id_fkey C
org_address.org_unit org_address_org_unit_fkey R
org_lasso_map.org_unit org_lasso_map_org_unit_fkey C
org_unit.parent_ou org_unit_parent_ou_fkey R
org_unit_closed.org_unit org_unit_closed_org_unit_fkey R
org_unit_custom_tree_node.org_unit org_unit_custom_tree_node_org_unit_fkey R
org_unit_proximity_adjustment.hold_pickup_lib org_unit_proximity_adjustment_hold_pickup_lib_fkey R
org_unit_proximity_adjustment.hold_request_lib org_unit_proximity_adjustment_hold_request_lib_fkey R
org_unit_proximity_adjustment.item_circ_lib org_unit_proximity_adjustment_item_circ_lib_fkey R
org_unit_proximity_adjustment.item_owning_lib org_unit_proximity_adjustment_item_owning_lib_fkey R
org_unit_setting.org_unit org_unit_setting_org_unit_fkey C
search_filter_group.owner search_filter_group_owner_fkey C
stat_cat.owner actor_stat_cat_owner_fkey C
stat_cat_entry.owner actor_stat_cat_entry_owner_fkey C
stat_cat_entry_default.owner stat_cat_entry_default_owner_fkey C
toolbar.org toolbar_org_fkey C
usr.home_ou actor_usr_home_ou_fkey R
usr_message.sending_lib usr_message_sending_lib_fkey R
usr_org_unit_opt_in.org_unit usr_org_unit_opt_in_org_unit_fkey R
usr_standing_penalty.org_unit usr_standing_penalty_org_unit_fkey C
workstation.owning_lib workstation_owning_lib_fkey R
call_number.owning_lib asset_call_number_owning_lib_fkey R
call_number_prefix.owning_lib call_number_prefix_owning_lib_fkey R
call_number_suffix.owning_lib call_number_suffix_owning_lib_fkey R
copy.circ_lib copy_circ_lib_fkey R
copy_location.owning_lib copy_location_owning_lib_fkey R
copy_location_group.owner copy_location_group_owner_fkey C
copy_location_order.org copy_location_order_org_fkey C
copy_tag.owner copy_tag_owner_fkey R
copy_template.circ_lib copy_template_circ_lib_fkey R
copy_template.owning_lib copy_template_owning_lib_fkey R
course_module_course.owning_lib course_module_course_owning_lib_fkey R
course_module_course_materials.original_circ_lib course_module_course_materials_original_circ_lib_fkey R
course_module_term.owning_lib course_module_term_owning_lib_fkey R
stat_cat.owner a_sc_owner_fkey C
stat_cat_entry.owner a_sce_owner_fkey C
record_entry.owner biblio_record_entry_owner_fkey R
reservation.pickup_lib reservation_pickup_lib_fkey R
reservation.request_lib reservation_request_lib_fkey R
resource.owner resource_owner_fkey R
resource_attr.owner resource_attr_owner_fkey R
resource_attr_value.owner resource_attr_value_owner_fkey R
resource_type.owner resource_type_owner_fkey R
barcode_completion.org_unit config_barcode_completion_org_unit_fkey C
billing_type.owner config_billing_type_owner_fkey C
circ_limit_set.owning_lib circ_limit_set_owning_lib_fkey R
circ_matrix_matchpoint.copy_circ_lib circ_matrix_matchpoint_copy_circ_lib_fkey R
circ_matrix_matchpoint.copy_owning_lib circ_matrix_matchpoint_copy_owning_lib_fkey R
circ_matrix_matchpoint.org_unit circ_matrix_matchpoint_org_unit_fkey R
circ_matrix_matchpoint.user_home_ou circ_matrix_matchpoint_user_home_ou_fkey R
copy_alert_type.scope_org copy_alert_type_scope_org_fkey C
copy_tag_type.owner copy_tag_type_owner_fkey R
filter_dialog_filter_set.owning_lib config_filter_dialog_filter_set_owning_lib_fkey C
floating_group_member.org_unit floating_group_member_org_unit_fkey R
geolocation_service.owner cgs_owner_fkey R
hold_matrix_matchpoint.item_circ_ou hold_matrix_matchpoint_item_circ_ou_fkey R
hold_matrix_matchpoint.item_owning_ou hold_matrix_matchpoint_item_owning_ou_fkey R
hold_matrix_matchpoint.pickup_ou hold_matrix_matchpoint_pickup_ou_fkey R
hold_matrix_matchpoint.request_ou hold_matrix_matchpoint_request_ou_fkey R
hold_matrix_matchpoint.user_home_ou hold_matrix_matchpoint_user_home_ou_fkey R
idl_field_doc.owner idl_field_doc_owner_fkey C
marc_field.owner config_marc_field_owner_fkey R
marc_subfield.owner config_marc_subfield_owner_fkey R
openathens_identity.org_unit config_openathens_identity_ou_fkey C
org_unit_setting_type_log.org config_org_unit_setting_type_log_fkey C
print_template.owner cpt_owner_fkey R
remote_account.owner config_remote_account_owner_fkey C
remoteauth_profile.context_org remoteauth_profile_context_org_fkey C
ui_staff_portal_page_entry.owner cusppe_owner_fkey C
weight_assoc.org_unit weight_assoc_org_unit_fkey C
z3950_source_credentials.owner z3950_source_creds_owner_fkey C
biblio_record_entry_bucket.owning_lib biblio_record_entry_bucket_owning_lib_fkey C
call_number_bucket.owning_lib call_number_bucket_owning_lib_fkey C
carousel.owner carousel_owner_fkey R
carousel_org_unit.org_unit carousel_org_unit_org_unit_fkey R
copy_bucket.owning_lib copy_bucket_owning_lib_fkey C
user_bucket.owning_lib user_bucket_owning_lib_fkey C
collections_tracker.location collections_tracker_location_fkey R
grp_penalty_threshold.org_unit grp_penalty_threshold_org_unit_fkey C
grp_tree_display_entry.org grp_tree_display_entry_org_fkey R
usr_work_ou_map.work_ou usr_work_ou_map_work_ou_fkey C
badge.scope badge_scope_fkey C
output_folder.share_with output_folder_share_with_fkey R
report_folder.share_with report_folder_share_with_fkey R
template_folder.share_with template_folder_share_with_fkey R
distribution.holding_lib distribution_holding_lib_fkey R
pattern_template.owning_lib pattern_template_owning_lib_fkey R
record_entry.owning_lib record_entry_owning_lib_fkey N
subscription.owning_lib subscription_owning_lib_fkey N
session.owning_lib session_owning_lib_fkey R
import_bib_trash_group.owner import_bib_trash_group_owner_fkey R
import_item_attr_definition.owner import_item_attr_definition_owner_fkey C
match_set.owner match_set_owner_fkey C
merge_profile.owner merge_profile_owner_fkey C
parent_ou int4 10 √ null
org_unit.id org_unit_parent_ou_fkey R
ou_type int4 10 null
org_unit_type.id org_unit_ou_type_fkey R
ill_address int4 10 √ null
org_address.id actor_org_unit_ill_address_fkey R
holds_address int4 10 √ null
org_address.id actor_org_unit_holds_address_fkey R
mailing_address int4 10 √ null
org_address.id actor_org_unit_mailing_address_fkey R
billing_address int4 10 √ null
org_address.id actor_org_unit_billing_address_fkey R
shortname text 2147483647 null
name text 2147483647 null
email text 2147483647 √ null
phone text 2147483647 √ null
opac_visible bool 1 true
fiscal_calendar int4 10 1
fiscal_calendar.id org_unit_fiscal_calendar_fkey R

Indexes

Constraint Name Type Sort Column(s)
org_unit_pkey Primary key Asc id
actor_org_unit_billing_address_idx Performance Asc billing_address
actor_org_unit_holds_address_idx Performance Asc holds_address
actor_org_unit_ill_address_idx Performance Asc ill_address
actor_org_unit_mailing_address_idx Performance Asc mailing_address
actor_org_unit_ou_type_idx Performance Asc ou_type
actor_org_unit_parent_ou_idx Performance Asc parent_ou
org_unit_name_key Must be unique Asc name
org_unit_shortname_key Must be unique Asc shortname

Relationships

Close relationships within degrees of separation