copy_location

89 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('asset.copy_location_id_seq'::regclass)
distribution_formula_entry.location distribution_formula_entry_location_fkey R
lineitem_detail.location lineitem_detail_location_fkey N
circulation.copy_location circulation_copy_location_fkey R
org_unit_proximity_adjustment.copy_location actor_org_unit_proximity_copy_location_fkey R
copy.location copy_location_fkey R
copy_location_group_map.location copy_location_group_map_location_fkey C
copy_location_order.location copy_location_order_location_fkey C
copy_template.location copy_template_location_fkey R
course_module_course_materials.original_location course_module_course_materials_original_location_fkey R
circ_limit_set_copy_loc_map.copy_loc circ_limit_set_copy_loc_map_copy_loc_fkey C
circ_matrix_matchpoint.copy_location circ_matrix_matchpoint_copy_location_fkey R
name text 2147483647 null
owning_lib int4 10 null
org_unit.id copy_location_owning_lib_fkey R
holdable bool 1 true
hold_verify bool 1 false
opac_visible bool 1 true
circulate bool 1 true
label_prefix text 2147483647 √ null
label_suffix text 2147483647 √ null
checkin_alert bool 1 false
deleted bool 1 false
url text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
copy_location_pkey Primary key Asc id
acl_name_once_per_lib Must be unique Asc/Asc name + owning_lib

Relationships

Close relationships within degrees of separation