from_relation

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('query.from_relation_id_seq'::regclass)
from_relation.parent_relation from_relation_parent_relation_fkey C
record_column.from_relation record_column_from_relation_fkey C
stored_query.from_clause stored_query_from_clause_fkey R
type text 2147483647 null
table_name text 2147483647 √ null
bind_variable.name Implied Constraint R
class_name text 2147483647 √ null
bind_variable.name Implied Constraint R
subquery int4 10 √ null
stored_query.id from_relation_subquery_fkey R
function_call int4 10 √ null
expression.id from_relation_function_call_fkey R
table_alias text 2147483647 √ null
parent_relation int4 10 √ null
from_relation.id from_relation_parent_relation_fkey C
seq_no int4 10 1
join_type text 2147483647 √ null
on_clause int4 10 √ null
expression.id from_relation_on_clause_fkey R

Indexes

Constraint Name Type Sort Column(s)
from_relation_pkey Primary key Asc id
from_parent_seq Must be unique Asc/Asc parent_relation + seq_no

Check Constraints

Constraint Name Constraint
relation_type ((type = ANY (ARRAY['RELATION'::text, 'SUBQUERY'::text, 'FUNCTION'::text])))
good_join_type (((join_type IS NULL) OR (join_type = ANY (ARRAY['INNER'::text, 'LEFT'::text, 'RIGHT'::text, 'FULL'::text]))))
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))))

Relationships

Close relationships within degrees of separation