org_unit_proximity_adjustment

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('actor.org_unit_proximity_adjustment_id_seq'::regclass)
item_circ_lib int4 10 √ null
org_unit.id org_unit_proximity_adjustment_item_circ_lib_fkey R
item_owning_lib int4 10 √ null
org_unit.id org_unit_proximity_adjustment_item_owning_lib_fkey R
copy_location int4 10 √ null
copy_location.id actor_org_unit_proximity_copy_location_fkey R
hold_pickup_lib int4 10 √ null
org_unit.id org_unit_proximity_adjustment_hold_pickup_lib_fkey R
hold_request_lib int4 10 √ null
org_unit.id org_unit_proximity_adjustment_hold_request_lib_fkey R
pos int4 10 0
absolute_adjustment bool 1 false
prox_adjustment numeric 0 √ null
circ_mod text 2147483647 √ null
circ_modifier.code actor_org_unit_proximity_adjustment_circ_mod_fkey R

Indexes

Constraint Name Type Sort Column(s)
org_unit_proximity_adjustment_pkey Primary key Asc id
prox_adj_circ_lib_idx Performance Asc item_circ_lib
prox_adj_circ_mod_idx Performance Asc circ_mod
prox_adj_copy_location_idx Performance Asc copy_location
prox_adj_once_idx Must be unique Asc pos
prox_adj_owning_lib_idx Performance Asc item_owning_lib
prox_adj_pickup_lib_idx Performance Asc hold_pickup_lib
prox_adj_request_lib_idx Performance Asc hold_request_lib

Check Constraints

Constraint Name Constraint
prox_adj_criterium ((COALESCE((item_circ_lib)::text, (item_owning_lib)::text, (copy_location)::text, (hold_pickup_lib)::text, (hold_request_lib)::text, circ_mod) IS NOT NULL))

Relationships

Close relationships within degrees of separation