service_point__t


Columns

Column Type Size Nulls Auto Default Children Parents Comments
__id int8 19 √ null
__cf bool 1 true
__start timestamptz 35,6 null
__source varchar 63 null
__origin varchar 63 ''::character varying
id uuid 2147483647 null
openings__t.service_point_id openings__t_service_point_id_fkeyR
check_in__t.service_point_id check_in__t_service_point_id_fkeyR
loan__t.checkin_service_point_id loan__t_checkin_service_point_id_fkeyR
loan__t.checkout_service_point_id loan__t_checkout_service_point_id_fkeyR
request__t.pickup_service_point_id request__t_pickup_service_point_id_fkeyR
user_request_preference__t.default_service_point_id user_request_preference__t_default_service_point_id_fkeyR
item__t.in_transit_destination_service_point_id item__t_in_transit_destination_service_point_id_fkeyR
location__t.primary_service_point location__t_primary_service_point_fkeyR
service_point_user__t.default_service_point_id service_point_user__t_default_service_point_id_fkeyR
code varchar 9 √ null
name varchar 22 √ null
pickup_location bool 1 √ null
shelving_lag_time numeric 131089 √ null
discovery_display_name varchar 22 √ null

Indexes

Constraint Name Type Sort Column(s)
service_point__t_pkey Primary key Asc id
service_point__t___origin_idx Performance Asc __origin
service_point__t___source_idx Performance Asc __source
service_point__t___start_idx Performance Asc __start
service_point__t_code_idx Performance Asc code
service_point__t_discovery_display_name_idx Performance Asc discovery_display_name
service_point__t_id_idx Performance Asc id
service_point__t_name_idx Performance Asc name
service_point__t_pickup_location_idx Performance Asc pickup_location
service_point__t_shelving_lag_time_idx Performance Asc shelving_lag_time

Relationships

Close relationships within degrees of separation