inventory_service_points

Columns

Related columns Constraint Comments

Search:

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

Showing 1 to 7 of 7 entries

Indexes

Search:

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

Showing 1 to 6 of 6 entries

Relationships

Close relationships within degrees of separation

One
Two degrees

inventory_service_points

Description

Columns

Indexes

Relationships

Close relationships within degrees of separation