Constraints

13 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
verification_attempt_session_fkey
verification_attempt.session
session.id
Cascade on delete
verification_attempt_usr_fkey
verification_attempt.usr
usr.id
Restrict delete
url_selector_session_fkey
url_selector.session
session.id
Cascade on delete
url_verification_attempt_fkey
url_verification.attempt
verification_attempt.id
Restrict delete
url_verification_url_fkey
url_verification.url
url.id
Cascade on delete
url_verification_redirect_to_fkey
url_verification.redirect_to
url.id
Restrict delete
session_container_fkey
session.container
biblio_record_entry_bucket.id
Restrict delete
session_owning_lib_fkey
session.owning_lib
org_unit.id
Restrict delete
session_creator_fkey
session.creator
usr.id
Restrict delete
url_session_fkey
url.session
session.id
Cascade on delete
url_redirect_from_fkey
url.redirect_from
url.id
Cascade on delete
url_item_fkey
url.item
biblio_record_entry_bucket_item.id
Restrict delete
url_url_selector_fkey
url.url_selector
url_selector.id
Restrict delete

Check Constraints

Table Constraint Name Constraint
url_verification url_verification_res_code_check (((res_code >= 100) AND (res_code <= 999)))
url redirect_or_from_item (((redirect_from IS NOT NULL) OR ((item IS NOT NULL) AND (url_selector IS NOT NULL) AND (tag IS NOT NULL) AND (subfield IS NOT NULL) AND (ord IS NOT NULL))))