queued_authority_record

97 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('vandelay.queued_record_id_seq'::regclass)
authority_match.queued_record authority_match_queued_record_fkey C
queued_authority_record_attr.record queued_authority_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
authority_queue.id queued_authority_record_queue_fkey C
imported_as int4 10 √ null
record_entry.id queued_authority_record_imported_as_fkey R
import_error text 2147483647 √ null
import_error.code queued_authority_record_import_error_fkey N
error_detail text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
queued_authority_record_pkey Primary key Asc id
queued_authority_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