record_entry

195 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('authority.record_entry_id_seq'::regclass)
authority_linking.source authority_linking_source_fkey R
authority_linking.target authority_linking_target_fkey R
bib_linking.authority bib_linking_authority_fkey R
record_note.record record_note_record_fkey R
simple_heading.record simple_heading_record_fkey R
browse_entry_def_map.authority browse_entry_def_map_authority_fkey N
authority_match.eg_record authority_match_eg_record_fkey R
queued_authority_record.imported_as queued_authority_record_imported_as_fkey R
create_date timestamptz 35,6 now()
edit_date timestamptz 35,6 now()
creator int4 10 1
editor int4 10 1
active bool 1 true
deleted bool 1 false
source int4 10 √ null
control_set int4 10 √ null
control_set.id record_entry_control_set_fkey R
marc text 2147483647 null
last_xact_id text 2147483647 null
owner int4 10 √ null
heading text 2147483647 √ null
simple_heading text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
record_entry_pkey Primary key Asc id
authority_record_deleted_idx Performance Asc deleted
authority_record_entry_create_date_idx Performance Asc create_date
authority_record_entry_creator_idx Performance Asc creator
authority_record_entry_edit_date_idx Performance Asc edit_date
authority_record_entry_editor_idx Performance Asc editor
by_heading Performance Asc simple_heading
by_heading_and_thesaurus Performance Asc heading

Relationships

Close relationships within degrees of separation