vandelay.background_import

↑ vandelay schema

Cascading Deletes: Deleting rows from this table will cascade to: actor.usr.

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: background_import_owner_fkey, background_import_workstation_fkey.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('vandelay.background_import_id_seq'::regclass)

owner FK

integer

No

→ actor.usr(id)

workstation FK

integer

Yes

→ actor.workstation(id)

import_type

text

No

'bib'::text

params

text

Yes

email

text

Yes

state

text

No

'new'::text

request_time

timestamp with time zone

No

now()

complete_time

timestamp with time zone

Yes

queue

bigint

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

owner

actor.usr(id)

CASCADE

NO ACTION

DEFERRED

background_import_owner_fkey

workstation

actor.workstation(id)

SET NULL

NO ACTION

DEFERRED

background_import_workstation_fkey

Check Constraints

  • background_import_import_type_check: CHECK import_type = ANY (ARRAY['bib'::text, 'acq'::text, 'authority'::text])

  • background_import_state_check: CHECK state = ANY (ARRAY['new'::text, 'running'::text, 'complete'::text])

Indexes

Index Method Definition

background_import_pkey PK

btree

CREATE UNIQUE INDEX background_import_pkey ON vandelay.background_import USING btree (id)
Previous
Next