query.function_param_def

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

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('query.function_param_def_id_seq'::regclass)
function_id FK	`integer`	No		→ query.function_sig(id)
seq_no	`integer`	No
datatype FK	`integer`	No		→ query.datatype(id)

id PK

integer

nextval('query.function_param_def_id_seq'::regclass)

function_id FK

integer

→ query.function_sig(id)

seq_no

integer

datatype 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
`datatype`	query.datatype(id)	NO ACTION	NO ACTION	DEFERRED	`function_param_def_datatype_fkey`
`function_id`	query.function_sig(id)	CASCADE	NO ACTION	DEFERRED	`function_param_def_function_id_fkey`

datatype

query.datatype(id)

NO ACTION

DEFERRED

function_param_def_datatype_fkey

function_id

query.function_sig(id)

CASCADE

NO ACTION

DEFERRED

function_param_def_function_id_fkey

Unique Constraints

qfpd_function_param_seq: (function_id, seq_no)

Check Constraints

qfpd_pos_seq_no: CHECK seq_no > 0

Indexes

Index Method Definition

Index	Method	Definition
`function_param_def_pkey` PK	btree	`CREATE UNIQUE INDEX function_param_def_pkey ON query.function_param_def USING btree (id)`
`qfpd_function_param_seq` UNIQUE	btree	`CREATE UNIQUE INDEX qfpd_function_param_seq ON query.function_param_def USING btree (function_id, seq_no)`

function_param_def_pkey PK

btree

CREATE UNIQUE INDEX function_param_def_pkey ON query.function_param_def USING btree (id)

qfpd_function_param_seq UNIQUE

btree

CREATE UNIQUE INDEX qfpd_function_param_seq ON query.function_param_def USING btree (function_id, seq_no)