query.subfield

Cascading Deletes: Deleting rows from this table will cascade to: query.datatype.

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('query.subfield_id_seq'::regclass)
composite_type FK	`integer`	No		→ query.datatype(id)
seq_no	`integer`	No
subfield_type FK	`integer`	No		→ query.datatype(id)

id PK

integer

nextval('query.subfield_id_seq'::regclass)

composite_type FK

integer

→ query.datatype(id)

seq_no

integer

subfield_type FK

integer

→ query.datatype(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`composite_type`	query.datatype(id)	CASCADE	NO ACTION	DEFERRED	`subfield_composite_type_fkey`
`subfield_type`	query.datatype(id)	NO ACTION	NO ACTION	DEFERRED	`subfield_subfield_type_fkey`

composite_type

query.datatype(id)

CASCADE

NO ACTION

DEFERRED

subfield_composite_type_fkey

subfield_type

query.datatype(id)

NO ACTION

DEFERRED

subfield_subfield_type_fkey

Unique Constraints

qsf_datatype_seq_no: (composite_type, seq_no)

Check Constraints

qsf_pos_seq_no: CHECK seq_no > 0

Indexes

Index Method Definition

Index	Method	Definition
`subfield_pkey` PK	btree	`CREATE UNIQUE INDEX subfield_pkey ON query.subfield USING btree (id)`
`qsf_datatype_seq_no` UNIQUE	btree	`CREATE UNIQUE INDEX qsf_datatype_seq_no ON query.subfield USING btree (composite_type, seq_no)`

subfield_pkey PK

btree

CREATE UNIQUE INDEX subfield_pkey ON query.subfield USING btree (id)

qsf_datatype_seq_no UNIQUE

btree

CREATE UNIQUE INDEX qsf_datatype_seq_no ON query.subfield USING btree (composite_type, seq_no)