Constraints

34 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

match_bucket_fkey

bib_queue.match_bucket

biblio_record_entry_bucket.id

Null on delete

bib_queue_item_attr_def_fkey

bib_queue.item_attr_def

import_item_attr_definition.id

Null on delete

merge_profile_owner_fkey

merge_profile.owner

Cascade on delete

queued_authority_record_import_error_fkey

queued_authority_record.import_error

import_error.code

Null on delete

queued_authority_record_imported_as_fkey

queued_authority_record.imported_as

record_entry.id

Restrict delete

queued_authority_record_queue_fkey

queued_authority_record.queue

authority_queue.id

Cascade on delete

match_set_quality_match_set_fkey

match_set_quality.match_set

Cascade on delete

match_set_quality_svf_fkey

match_set_quality.svf

record_attr_definition.name

Restrict delete

bib_match_eg_record_fkey

bib_match.eg_record

record_entry.id

Cascade on delete

bib_match_queued_record_fkey

bib_match.queued_record

queued_bib_record.id

Cascade on delete

match_set_owner_fkey

match_set.owner

Cascade on delete

queue_match_set_fkey

queue.match_set

Null on delete

queue_owner_fkey

queue.owner

usr.id

Restrict delete

match_set_point_match_set_fkey

match_set_point.match_set

Cascade on delete

match_set_point_parent_fkey

match_set_point.parent

match_set_point.id

Restrict delete

match_set_point_svf_fkey

match_set_point.svf

record_attr_definition.name

Restrict delete

import_item_attr_definition_owner_fkey

import_item_attr_definition.owner

Cascade on delete

import_item_definition_fkey

import_item.definition

import_item_attr_definition.id

Cascade on delete

import_item_record_fkey

import_item.record

queued_bib_record.id

Cascade on delete

import_item_import_error_fkey

import_item.import_error

import_error.code

Null on delete

import_bib_trash_fields_grp_fkey

import_bib_trash_fields.grp

import_bib_trash_group.id

Restrict delete

authority_match_queued_record_fkey

authority_match.queued_record

queued_authority_record.id

Cascade on delete

authority_match_eg_record_fkey

authority_match.eg_record

record_entry.id

Restrict delete

queued_authority_record_attr_field_fkey

queued_authority_record_attr.field

authority_attr_definition.id

Restrict delete

queued_authority_record_attr_record_fkey

queued_authority_record_attr.record

queued_authority_record.id

Restrict delete

queued_bib_record_attr_field_fkey

queued_bib_record_attr.field

bib_attr_definition.id

Restrict delete

queued_bib_record_attr_record_fkey

queued_bib_record_attr.record

queued_bib_record.id

Restrict delete

session_tracker_usr_fkey

session_tracker.usr

usr.id

Restrict delete

session_tracker_workstation_fkey

session_tracker.workstation

Cascade on delete

import_bib_trash_group_owner_fkey

import_bib_trash_group.owner

Restrict delete

queued_bib_record_import_error_fkey

queued_bib_record.import_error

import_error.code

Null on delete

queued_bib_record_imported_as_fkey

queued_bib_record.imported_as

record_entry.id

Restrict delete

queued_bib_record_bib_source_fkey

queued_bib_record.bib_source

Restrict delete

queued_bib_record_queue_fkey

queued_bib_record.queue

Cascade on delete

Check Constraints

Table	Constraint Name	Constraint
merge_profile	add_replace_strip_or_preserve	(((preserve_spec IS NOT NULL) OR (replace_spec IS NOT NULL) OR ((preserve_spec IS NULL) AND (replace_spec IS NULL))))
queued_authority_record	queued_record_purpose_check	((purpose = ANY (ARRAY['import'::text, 'overlay'::text])))
match_set_quality	vmsq_need_a_subfield_with_a_tag	((((tag IS NOT NULL) AND (subfield IS NOT NULL)) OR (tag IS NULL)))
match_set_quality	vmsq_need_a_tag_or_a_ff	((((tag IS NOT NULL) AND (svf IS NULL)) OR ((tag IS NULL) AND (svf IS NOT NULL))))
match_set_point	match_set_point_bool_op_check	(((bool_op IS NULL) OR (bool_op = ANY (ARRAY['AND'::text, 'OR'::text, 'NOT'::text]))))
match_set_point	vmsp_need_a_subfield_with_a_tag	((((tag IS NOT NULL) AND (subfield IS NOT NULL)) OR (tag IS NULL)))
match_set_point	vmsp_need_a_tag_or_a_ff_or_a_bo	((((tag IS NOT NULL) AND (svf IS NULL) AND (heading IS FALSE) AND (bool_op IS NULL)) OR ((tag IS NULL) AND (svf IS NOT NULL) AND (heading IS FALSE) AND (bool_op IS NULL)) OR ((tag IS NULL) AND (svf IS NULL) AND (heading IS TRUE) AND (bool_op IS NULL)) OR ((tag IS NULL) AND (svf IS NULL) AND (heading IS FALSE) AND (bool_op IS NOT NULL))))
session_tracker	vand_tracker_valid_action_type	((action_type = ANY (ARRAY['upload'::text, 'enqueue'::text, 'import'::text])))
session_tracker	vand_tracker_valid_record_type	((record_type = ANY (ARRAY['bib'::text, 'authority'::text])))
session_tracker	vand_tracker_valid_state	((state = ANY (ARRAY['active'::text, 'error'::text, 'complete'::text])))
queued_record	queued_record_purpose_check	((purpose = ANY (ARRAY['import'::text, 'overlay'::text])))
queued_bib_record	queued_record_purpose_check	((purpose = ANY (ARRAY['import'::text, 'overlay'::text])))