query.datatype

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default
id PK	`integer`	No	nextval('query.datatype_id_seq'::regclass)
datatype_name	`text`	No
is_numeric	`boolean`	No	false
is_composite	`boolean`	No	false

id PK

integer

nextval('query.datatype_id_seq'::regclass)

datatype_name

text

is_numeric

boolean

false

is_composite

boolean

false

(id)

Index Method Definition

Index	Method	Definition
`datatype_pkey` PK	btree	`CREATE UNIQUE INDEX datatype_pkey ON query.datatype USING btree (id)`
`datatype_datatype_name_key` UNIQUE	btree	`CREATE UNIQUE INDEX datatype_datatype_name_key ON query.datatype USING btree (datatype_name)`

datatype_pkey PK

btree

CREATE UNIQUE INDEX datatype_pkey ON query.datatype USING btree (id)

datatype_datatype_name_key UNIQUE

btree

CREATE UNIQUE INDEX datatype_datatype_name_key ON query.datatype USING btree (datatype_name)

The following tables have foreign keys pointing to query.datatype (6 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

Table	Referencing Column(s)	Referenced Column(s)	Constraint
query.expression	`cast_type`	`id`	`expression_cast_type_fkey`
query.function_param_def	`datatype`	`id`	`function_param_def_datatype_fkey`
query.function_sig	`return_type`	`id`	`function_sig_return_type_fkey`
query.record_column	`column_type`	`id`	`record_column_column_type_fkey`
query.subfield	`composite_type`	`id`	`subfield_composite_type_fkey`
query.subfield	`subfield_type`	`id`	`subfield_subfield_type_fkey`