query.record_column

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

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('query.record_column_id_seq'::regclass)
from_relation FK	`integer`	No		→ query.from_relation(id)
seq_no	`integer`	No
column_name	`text`	No
column_type FK	`integer`	No		→ query.datatype(id)

id PK

integer

nextval('query.record_column_id_seq'::regclass)

from_relation FK

integer

→ query.from_relation(id)

seq_no

integer

column_name

text

column_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
`column_type`	query.datatype(id)	CASCADE	NO ACTION	DEFERRED	`record_column_column_type_fkey`
`from_relation`	query.from_relation(id)	CASCADE	NO ACTION	DEFERRED	`record_column_from_relation_fkey`

column_type

query.datatype(id)

CASCADE

NO ACTION

DEFERRED

record_column_column_type_fkey

from_relation

query.from_relation(id)

CASCADE

NO ACTION

DEFERRED

record_column_from_relation_fkey

Unique Constraints

column_sequence: (from_relation, seq_no)

Indexes

Index Method Definition

Index	Method	Definition
`record_column_pkey` PK	btree	`CREATE UNIQUE INDEX record_column_pkey ON query.record_column USING btree (id)`
`column_sequence` UNIQUE	btree	`CREATE UNIQUE INDEX column_sequence ON query.record_column USING btree (from_relation, seq_no)`

record_column_pkey PK

btree

CREATE UNIQUE INDEX record_column_pkey ON query.record_column USING btree (id)

column_sequence UNIQUE

btree

CREATE UNIQUE INDEX column_sequence ON query.record_column USING btree (from_relation, seq_no)