record_entry

345 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('biblio.record_entry_id_seq'::regclass)
lineitem.eg_bib_id lineitem_eg_bib_id_fkey R
user_request.eg_bib user_request_eg_bib_fkey C
event.context_bib event_context_bib_fkey R
call_number.record asset_call_number_record_fkey R
course_module_course_materials.record course_module_course_materials_record_fkey R
bib_linking.bib bib_linking_bib_fkey R
monograph_part.record monograph_part_record_fkey R
peer_bib_copy_map.peer_record peer_bib_copy_map_peer_record_fkey R
record_entry.merged_to record_entry_merged_to_fkey R
record_note.record biblio_record_note_record_fkey C
resource_type.record resource_type_record_fkey R
biblio_record_entry_bucket_item.target_biblio_record_entry biblio_record_entry_bucket_item_target_biblio_record_entry_fkey C
author_field_entry.source metabib_author_field_entry_source_pkey C
browse_entry_def_map.source browse_entry_def_map_source_fkey R
identifier_field_entry.source metabib_identifier_field_entry_source_pkey C
keyword_field_entry.source metabib_keyword_field_entry_source_pkey C
metarecord.master_record metabib_metarecord_master_record_fkey R
metarecord_source_map.source metabib_metarecord_source_map_source_fkey C
real_full_rec.record metabib_full_rec_record_fkey C
record_attr_vector_list.source record_attr_vector_list_source_fkey R
record_sorter.source record_sorter_source_fkey C
series_field_entry.source metabib_series_field_entry_source_pkey C
subject_field_entry.source metabib_subject_field_entry_source_pkey C
title_field_entry.source metabib_title_field_entry_source_pkey C
record_badge_score.record record_badge_score_record_fkey C
record_entry.record record_entry_record_fkey N
subscription.record_entry subscription_record_entry_fkey N
bib_match.eg_record bib_match_eg_record_fkey C
queued_bib_record.imported_as queued_bib_record_imported_as_fkey R
creator int4 10 1
usr.id biblio_record_entry_creator_fkey R
editor int4 10 1
usr.id biblio_record_entry_editor_fkey R
source int4 10 √ null
quality int4 10 √ null
create_date timestamptz 35,6 now()
edit_date timestamptz 35,6 now()
active bool 1 true
deleted bool 1 false
fingerprint text 2147483647 √ null
tcn_source text 2147483647 'AUTOGEN'::text
tcn_value text 2147483647 biblio.next_autogen_tcn_value()
marc text 2147483647 null
last_xact_id text 2147483647 null
vis_attr_vector _int4 10 √ null
owner int4 10 √ null
org_unit.id biblio_record_entry_owner_fkey R
share_depth int4 10 √ null
merge_date timestamptz 35,6 √ null
merged_to int8 19 √ null
record_entry.id record_entry_merged_to_fkey R

Indexes

Constraint Name Type Sort Column(s)
record_entry_pkey Primary key Asc id
biblio_record_entry_create_date_idx Performance Asc create_date
biblio_record_entry_creator_idx Performance Asc creator
biblio_record_entry_edit_date_idx Performance Asc edit_date
biblio_record_entry_editor_idx Performance Asc editor
biblio_record_entry_fp_idx Performance Asc fingerprint
biblio_record_unique_tcn Must be unique Asc tcn_value

Relationships

Close relationships within degrees of separation