inventory_locations


Description

https://dev.folio.org/reference/api/#mod-inventory-storage

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id varchar 36 null
circulation_check_ins.item_location_id circulation_check_ins_item_location_id_fkeyR
circulation_loans.item_effective_location_id_at_check_out circulation_loans_item_effective_location_id_at_check_out_fkeyR
inventory_holdings.effective_location_id inventory_holdings_effective_location_id_fkeyR
inventory_holdings.permanent_location_id inventory_holdings_permanent_location_id_fkeyR
inventory_items.effective_location_id inventory_items_effective_location_id_fkeyR
po_pieces.location_id po_pieces_location_id_fkeyR
po_receiving_history.location_id po_receiving_history_location_id_fkeyR
campus_id varchar 36 √ null
inventory_campuses.id inventory_locations_campus_id_fkeyR
code varchar 17 √ null
description varchar 79 √ null
discovery_display_name varchar 84 √ null
institution_id varchar 36 √ null
inventory_institutions.id inventory_locations_institution_id_fkeyR
is_active bool 1 √ null
library_id varchar 36 √ null
inventory_libraries.id inventory_locations_library_id_fkeyR
name varchar 79 √ null
primary_service_point varchar 36 √ null
inventory_service_points.id inventory_locations_primary_service_point_fkeyR
data json 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
inventory_locations_pkey Primary key Asc id
inventory_locations_campus_id_idx Performance Asc campus_id
inventory_locations_code_idx Performance Asc code
inventory_locations_description_idx Performance Asc description
inventory_locations_discovery_display_name_idx Performance Asc discovery_display_name
inventory_locations_institution_id_idx Performance Asc institution_id
inventory_locations_is_active_idx Performance Asc is_active
inventory_locations_library_id_idx Performance Asc library_id
inventory_locations_name_idx Performance Asc name
inventory_locations_primary_service_point_idx Performance Asc primary_service_point

Relationships

Close relationships within degrees of separation