config.idl_field_doc

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: idl_field_doc_owner_fkey.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`bigint`	No	nextval('config.idl_field_doc_id_seq'::regclass)
fm_class	`text`	No
field	`text`	No
owner FK	`integer`	No		→ actor.org_unit(id)
string	`text`	No

id PK

bigint

nextval('config.idl_field_doc_id_seq'::regclass)

fm_class

text

field

text

owner FK

integer

→ actor.org_unit(id)

string

text

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`owner`	actor.org_unit(id)	CASCADE	CASCADE	DEFERRED	`idl_field_doc_owner_fkey`

owner

actor.org_unit(id)

CASCADE

DEFERRED

idl_field_doc_owner_fkey

Indexes

Index Method Definition

Index	Method	Definition
`idl_field_doc_pkey` PK	btree	`CREATE UNIQUE INDEX idl_field_doc_pkey ON config.idl_field_doc USING btree (id)`
`idl_field_doc_identity` UNIQUE	btree	`CREATE UNIQUE INDEX idl_field_doc_identity ON config.idl_field_doc USING btree (fm_class, field, owner)`

idl_field_doc_pkey PK

btree

CREATE UNIQUE INDEX idl_field_doc_pkey ON config.idl_field_doc USING btree (id)

idl_field_doc_identity UNIQUE

btree

CREATE UNIQUE INDEX idl_field_doc_identity ON config.idl_field_doc USING btree (fm_class, field, owner)