vandelay.merge_profile

↑ vandelay schema

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

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

Columns

Column Type Nullable Default Notes

id PK

bigint

No

nextval('vandelay.merge_profile_id_seq'::regclass)

owner FK

integer

No

→ actor.org_unit(id)

name

text

No

add_spec

text

Yes

replace_spec

text

Yes

strip_spec

text

Yes

preserve_spec

text

Yes

update_bib_source

boolean

No

false

update_bib_editor

boolean

No

false

lwm_ratio

numeric

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

owner

actor.org_unit(id)

CASCADE

CASCADE

DEFERRED

merge_profile_owner_fkey

Unique Constraints

  • vand_merge_prof_owner_name_idx: (owner, name)

Check Constraints

  • add_replace_strip_or_preserve: CHECK

Indexes

Index Method Definition

merge_profile_pkey PK

btree

CREATE UNIQUE INDEX merge_profile_pkey ON vandelay.merge_profile USING btree (id)

vand_merge_prof_owner_name_idx UNIQUE

btree

CREATE UNIQUE INDEX vand_merge_prof_owner_name_idx ON vandelay.merge_profile USING btree (owner, name)
Previous
Next