inventory_service_points


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.service_point_id circulation_check_ins_service_point_id_fkeyR
circulation_loans.checkin_service_point_id circulation_loans_checkin_service_point_id_fkeyR
circulation_loans.checkout_service_point_id circulation_loans_checkout_service_point_id_fkeyR
circulation_requests.pickup_service_point_id circulation_requests_pickup_service_point_id_fkeyR
inventory_locations.primary_service_point inventory_locations_primary_service_point_fkeyR
inventory_service_points_users.default_service_point_id inventory_service_points_users_default_service_point_id_fkeyR
code varchar 9 √ null
discovery_display_name varchar 22 √ null
name varchar 22 √ null
pickup_location bool 1 √ null
shelving_lag_time int8 19 √ null
data json 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
inventory_service_points_pkey Primary key Asc id
inventory_service_points_code_idx Performance Asc code
inventory_service_points_discovery_display_name_idx Performance Asc discovery_display_name
inventory_service_points_name_idx Performance Asc name
inventory_service_points_pickup_location_idx Performance Asc pickup_location
inventory_service_points_shelving_lag_time_idx Performance Asc shelving_lag_time

Relationships

Close relationships within degrees of separation