authority.control_set

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default
id PK	`integer`	No	nextval('authority.control_set_id_seq'::regclass)
name	`text`	No
description	`text`	Yes

id PK

integer

nextval('authority.control_set_id_seq'::regclass)

name

text

description

text

Yes

(id)

Index Method Definition

Index	Method	Definition
`control_set_pkey` PK	btree	`CREATE UNIQUE INDEX control_set_pkey ON authority.control_set USING btree (id)`
`control_set_name_key` UNIQUE	btree	`CREATE UNIQUE INDEX control_set_name_key ON authority.control_set USING btree (name)`

control_set_pkey PK

btree

CREATE UNIQUE INDEX control_set_pkey ON authority.control_set USING btree (id)

control_set_name_key UNIQUE

btree

CREATE UNIQUE INDEX control_set_name_key ON authority.control_set USING btree (name)

The following tables have foreign keys pointing to authority.control_set (3 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

Table	Referencing Column(s)	Referenced Column(s)	Constraint
authority.control_set_authority_field	`control_set`	`id`	`control_set_authority_field_control_set_fkey`
authority.record_entry	`control_set`	`id`	`record_entry_control_set_fkey`
authority.thesaurus	`control_set`	`id`	`thesaurus_control_set_fkey`

control_set

id

control_set_authority_field_control_set_fkey

control_set

id

record_entry_control_set_fkey

control_set

id

thesaurus_control_set_fkey