Constraints

32 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

case_branch_parent_expr_fkey

case_branch.parent_expr

Cascade on delete

case_branch_condition_fkey

case_branch.condition

Restrict delete

case_branch_result_fkey

case_branch.result

Restrict delete

function_param_def_function_id_fkey

function_param_def.function_id

function_sig.id

Cascade on delete

function_param_def_datatype_fkey

function_param_def.datatype

Restrict delete

stored_query_offset_count_fkey

stored_query.offset_count

Restrict delete

stored_query_where_clause_fkey

stored_query.where_clause

Restrict delete

stored_query_from_clause_fkey

stored_query.from_clause

from_relation.id

Restrict delete

stored_query_having_clause_fkey

stored_query.having_clause

Restrict delete

stored_query_limit_count_fkey

stored_query.limit_count

Restrict delete

query_sequence_child_query_fkey

query_sequence.child_query

stored_query.id

Cascade on delete

query_sequence_parent_query_fkey

query_sequence.parent_query

stored_query.id

Cascade on delete

from_relation_parent_relation_fkey

from_relation.parent_relation

from_relation.id

Cascade on delete

from_relation_subquery_fkey

from_relation.subquery

stored_query.id

Restrict delete

from_relation_function_call_fkey

from_relation.function_call

Restrict delete

from_relation_on_clause_fkey

from_relation.on_clause

Restrict delete

subfield_subfield_type_fkey

subfield.subfield_type

Restrict delete

subfield_composite_type_fkey

subfield.composite_type

Cascade on delete

function_sig_return_type_fkey

function_sig.return_type

Restrict delete

order_by_item_expression_fkey

order_by_item.expression

Cascade on delete

order_by_item_stored_query_fkey

order_by_item.stored_query

stored_query.id

Cascade on delete

expression_cast_type_fkey

expression.cast_type

Restrict delete

expression_parent_expr_fkey

expression.parent_expr

Cascade on delete

expression_function_id_fkey

expression.function_id

function_sig.id

Restrict delete

expression_bind_variable_fkey

expression.bind_variable

bind_variable.name

Restrict delete

expression_left_operand_fkey

expression.left_operand

Restrict delete

expression_subquery_fkey

expression.subquery

stored_query.id

Restrict delete

expression_right_operand_fkey

expression.right_operand

Restrict delete

select_item_stored_query_fkey

select_item.stored_query

stored_query.id

Cascade on delete

select_item_expression_fkey

select_item.expression

Restrict delete

record_column_from_relation_fkey

record_column.from_relation

from_relation.id

Cascade on delete

record_column_column_type_fkey

record_column.column_type

Cascade on delete

Check Constraints

Table	Constraint Name	Constraint
function_param_def	qfpd_pos_seq_no	((seq_no > 0))
stored_query	query_type	((type = ANY (ARRAY['SELECT'::text, 'UNION'::text, 'INTERSECT'::text, 'EXCEPT'::text])))
bind_variable	bind_variable_type	((type = ANY (ARRAY['string'::text, 'number'::text, 'string_list'::text, 'number_list'::text])))
datatype	qdt_comp_not_num	(((is_numeric IS FALSE) OR (is_composite IS FALSE)))
from_relation	good_join_type	(((join_type IS NULL) OR (join_type = ANY (ARRAY['INNER'::text, 'LEFT'::text, 'RIGHT'::text, 'FULL'::text]))))
from_relation	join_or_core	((((parent_relation IS NULL) AND (join_type IS NULL) AND (on_clause IS NULL)) OR ((parent_relation IS NOT NULL) AND (join_type IS NOT NULL) AND (on_clause IS NOT NULL))))
from_relation	relation_type	((type = ANY (ARRAY['RELATION'::text, 'SUBQUERY'::text, 'FUNCTION'::text])))
subfield	qsf_pos_seq_no	((seq_no > 0))
function_sig	qfd_rtn_or_aggr	(((return_type IS NULL) OR (is_aggregate = false)))
expression	expression_type	((type = ANY (ARRAY['xbet'::text, 'xbind'::text, 'xbool'::text, 'xcase'::text, 'xcast'::text, 'xcol'::text, 'xex'::text, 'xfunc'::text, 'xin'::text, 'xisnull'::text, 'xnull'::text, 'xnum'::text, 'xop'::text, 'xser'::text, 'xstr'::text, 'xsubq'::text])))