background_import

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('vandelay.background_import_id_seq'::regclass)
owner int4 10 null
usr.id background_import_owner_fkey C
workstation int4 10 √ null
workstation.id background_import_workstation_fkey N
import_type text 2147483647 'bib'::text
params text 2147483647 √ null
email text 2147483647 √ null
state text 2147483647 'new'::text
request_time timestamptz 35,6 now()
complete_time timestamptz 35,6 √ null
queue int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
background_import_pkey Primary key Asc id

Check Constraints

Constraint Name Constraint
background_import_import_type_check ((import_type = ANY (ARRAY['bib'::text, 'acq'::text, 'authority'::text])))
background_import_state_check ((state = ANY (ARRAY['new'::text, 'running'::text, 'complete'::text])))

Relationships

Close relationships within degrees of separation