Constraints

26 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

record_attr_vector_list_source_fkey

record_attr_vector_list.source

record_entry.id

Restrict delete

metabib_identifier_field_entry_source_pkey

identifier_field_entry.source

record_entry.id

Cascade on delete

metabib_identifier_field_entry_field_pkey

identifier_field_entry.field

metabib_field.id

Cascade on delete

metabib_keyword_field_entry_source_pkey

keyword_field_entry.source

record_entry.id

Cascade on delete

metabib_keyword_field_entry_field_pkey

keyword_field_entry.field

metabib_field.id

Cascade on delete

metabib_title_field_entry_source_pkey

title_field_entry.source

record_entry.id

Cascade on delete

metabib_title_field_entry_field_pkey

title_field_entry.field

metabib_field.id

Cascade on delete

browse_entry_simple_heading_map_simple_heading_fkey

browse_entry_simple_heading_map.simple_heading

simple_heading.id

Cascade on delete

browse_entry_simple_heading_map_entry_fkey

browse_entry_simple_heading_map.entry

browse_entry.id

Restrict delete

metabib_metarecord_master_record_fkey

metarecord.master_record

record_entry.id

Restrict delete

metabib_full_rec_record_fkey

real_full_rec.record

record_entry.id

Cascade on delete

uncontrolled_record_attr_value_attr_fkey

uncontrolled_record_attr_value.attr

record_attr_definition.name

Restrict delete

metabib_author_field_entry_source_pkey

author_field_entry.source

record_entry.id

Cascade on delete

metabib_author_field_entry_field_pkey

author_field_entry.field

metabib_field.id

Cascade on delete

metabib_subject_field_entry_source_pkey

subject_field_entry.source

record_entry.id

Cascade on delete

metabib_subject_field_entry_field_pkey

subject_field_entry.field

metabib_field.id

Cascade on delete

metabib_series_field_entry_field_pkey

series_field_entry.field

metabib_field.id

Cascade on delete

metabib_series_field_entry_source_pkey

series_field_entry.source

record_entry.id

Cascade on delete

metabib_metarecord_source_map_metarecord_fkey

metarecord_source_map.metarecord

Cascade on delete

metabib_metarecord_source_map_source_fkey

metarecord_source_map.source

record_entry.id

Cascade on delete

browse_entry_def_map_authority_fkey

browse_entry_def_map.authority

record_entry.id

Null on delete

browse_entry_def_map_def_fkey

browse_entry_def_map.def

metabib_field.id

Restrict delete

browse_entry_def_map_source_fkey

browse_entry_def_map.source

record_entry.id

Restrict delete

browse_entry_def_map_entry_fkey

browse_entry_def_map.entry

browse_entry.id

Restrict delete

record_sorter_attr_fkey

record_sorter.attr

record_attr_definition.name

Cascade on delete

record_sorter_source_fkey

record_sorter.source

record_entry.id

Cascade on delete

Check Constraints

Table	Constraint Name	Constraint