queued_bib_record

147 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('vandelay.queued_record_id_seq'::regclass)
lineitem.queued_record lineitem_queued_record_fkey N
bib_match.queued_record bib_match_queued_record_fkey C
import_item.record import_item_record_fkey C
queued_bib_record_attr.record queued_bib_record_attr_record_fkey R
create_time timestamptz 35,6 now()
import_time timestamptz 35,6 √ null
purpose text 2147483647 'import'::text
marc text 2147483647 null
quality int4 10 0
queue int4 10 null
bib_queue.id queued_bib_record_queue_fkey C
bib_source int4 10 √ null
bib_source.id queued_bib_record_bib_source_fkey R
imported_as int8 19 √ null
record_entry.id queued_bib_record_imported_as_fkey R
import_error text 2147483647 √ null
import_error.code queued_bib_record_import_error_fkey N
error_detail text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
queued_bib_record_pkey Primary key Asc id
queued_bib_record_queue_idx Performance Asc queue

Check Constraints

Constraint Name Constraint
queued_record_purpose_check ((purpose = ANY (ARRAY['import'::text, 'overlay'::text])))

Relationships

Close relationships within degrees of separation