call_number

1822 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('asset.call_number_id_seq'::regclass)
call_number_note.call_number asset_call_number_note_record_fkey C
copy.call_number asset_copy_call_number_fkey R
course_module_course_materials.original_callnumber course_module_course_materials_original_callnumber_fkey R
uri_call_number_map.call_number uri_call_number_map_call_number_fkey R
call_number_bucket_item.target_call_number call_number_bucket_item_target_call_number_fkey C
distribution.bind_call_number distribution_bind_call_number_fkey R
distribution.receive_call_number distribution_receive_call_number_fkey R
unit.call_number serial_unit_call_number_fkey R
creator int8 19 null
usr.id asset_call_number_creator_fkey R
create_date timestamptz 35,6 √ now()
editor int8 19 null
usr.id asset_call_number_editor_fkey R
edit_date timestamptz 35,6 √ now()
record int8 19 null
record_entry.id asset_call_number_record_fkey R
owning_lib int4 10 null
org_unit.id asset_call_number_owning_lib_fkey R
label text 2147483647 null
deleted bool 1 false
prefix int4 10 '-1'::integer
call_number_prefix.id call_number_prefix_fkey R
suffix int4 10 '-1'::integer
call_number_suffix.id call_number_suffix_fkey R
label_class int8 19 null
call_number_class.id call_number_label_class_fkey R
label_sortkey text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
call_number_pkey Primary key Asc id
asset_call_number_creator_idx Performance Asc creator
asset_call_number_dewey_idx Performance
asset_call_number_editor_idx Performance Asc editor
asset_call_number_label_once_per_lib Must be unique Asc/Asc/Asc/Asc/Asc record + owning_lib + label + prefix + suffix
asset_call_number_label_sortkey Performance
asset_call_number_label_sortkey_browse Performance Asc/Asc id + owning_lib
asset_call_number_record_idx Performance Asc record
asset_call_number_upper_label_id_owning_lib_idx Performance Asc/Asc id + owning_lib

Relationships

Close relationships within degrees of separation