authority.authority_linking

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`bigint`	No	nextval('authority.authority_linking_id_seq'::regclass)
source FK	`bigint`	No		→ authority.record_entry(id)
target FK	`bigint`	No		→ authority.record_entry(id)
field FK	`integer`	No		→ authority.control_set_authority_field(id)

id PK

bigint

No

nextval('authority.authority_linking_id_seq'::regclass)

source FK

bigint

No

target FK

bigint

No

field FK

integer

No

(id)

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`field`	authority.control_set_authority_field(id)	NO ACTION	NO ACTION	No	`authority_linking_field_fkey`
`source`	authority.record_entry(id)	NO ACTION	NO ACTION	No	`authority_linking_source_fkey`
`target`	authority.record_entry(id)	NO ACTION	NO ACTION	No	`authority_linking_target_fkey`

field

NO ACTION

No

authority_linking_field_fkey

source

NO ACTION

No

authority_linking_source_fkey

target

NO ACTION

No

authority_linking_target_fkey

Index Method Definition

Index	Method	Definition
`authority_linking_pkey` PK	btree	`CREATE UNIQUE INDEX authority_linking_pkey ON authority.authority_linking USING btree (id)`

authority_linking_pkey PK

btree

CREATE UNIQUE INDEX authority_linking_pkey ON authority.authority_linking USING btree (id)