data_types - DATADA.AI Server

Tables

data_types 16 records

name	display_name	description	parameter_schema
INTEGER	Integer	Whole number without decimal places	{"type": "object", "properties": {"min_value": {"type": "int", "description": "Minimum allowed value...
DECIMAL	Decimal	Exact numeric value with fixed precision and scale	{"type": "object", "properties": {"precision": {"type": "int", "description": "Total number of digit...
FLOAT	Float	Approximate numeric value with floating-point precision	{"type": "object", "properties": {"precision": {"type": "int", "description": "Number of significant...
STRING	String	Variable-length character string	{"type": "object", "properties": {"min_length": {"type": "int", "description": "Minimum number of ch...
CHAR	Fixed Character	Fixed-length character string	{"type": "object", "properties": {"length": {"type": "int", "description": "Exact number of characte...
BINARY	Binary	Fixed or variable-length binary data	{"type": "object", "properties": {"length": {"type": "int", "description": "Fixed length in bytes (f...
BLOB	Binary Large Object	Large binary data storage	{"type": "object", "properties": {"max_size": {"type": "int", "description": "Maximum size in bytes"...
DATE	Date	Calendar date without time component	{"type": "object", "properties": {"min_date": {"type": "string", "description": "Minimum allowed dat...
TIME	Time	Time of day without date component	{"type": "object", "properties": {"with_timezone": {"type": "boolean", "description": "Whether to in...
DATETIME	DateTime	Date and time combined	{"type": "object", "properties": {"with_timezone": {"type": "boolean", "description": "Whether to in...
BOOLEAN	Boolean	True/false logical value	{"type": "object", "properties": {}}
JSON	JSON	JSON document storage	{"type": "object", "properties": {"binary": {"type": "boolean", "description": "Whether to use binar...
ENUM	Enumeration	Value from a predefined set of allowed values	{"type": "object", "properties": {"values": {"type": "string", "description": "JSON array of allowed...
GEOGRAPHY	Geography	Geographic data (spherical coordinates)	{"type": "object", "properties": {"srid": {"type": "int", "description": "Spatial Reference System I...
MONEY	Money	Currency amount with precision	{"type": "object", "properties": {"currency": {"type": "string", "description": "ISO 4217 currency c...
INTERVAL	Interval	Time duration or interval	{"type": "object", "properties": {"fields": {"type": "enum", "description": "Interval precision fiel...

Attribute	Record 1	Record 2	Record 3	Record 4	Record 5	Record 6	Record 7	Record 8	Record 9	Record 10	Record 11	Record 12	Record 13	Record 14	Record 15	Record 16
name	INTEGER	DECIMAL	FLOAT	STRING	CHAR	BINARY	BLOB	DATE	TIME	DATETIME	BOOLEAN	JSON	ENUM	GEOGRAPHY	MONEY	INTERVAL
display_name	Integer	Decimal	Float	String	Fixed Character	Binary	Binary Large Object	Date	Time	DateTime	Boolean	JSON	Enumeration	Geography	Money	Interval
description	Whole number without decimal places	Exact numeric value with fixed precision and scale	Approximate numeric value with floating-point precision	Variable-length character string	Fixed-length character string	Fixed or variable-length binary data	Large binary data storage	Calendar date without time component	Time of day without date component	Date and time combined	True/false logical value	JSON document storage	Value from a predefined set of allowed values	Geographic data (spherical coordinates)	Currency amount with precision	Time duration or interval
parameter_schema	{"type": "object", "properties": {"min_value": {"type": "int", "description": "Minimum allowed value...	{"type": "object", "properties": {"precision": {"type": "int", "description": "Total number of digit...	{"type": "object", "properties": {"precision": {"type": "int", "description": "Number of significant...	{"type": "object", "properties": {"min_length": {"type": "int", "description": "Minimum number of ch...	{"type": "object", "properties": {"length": {"type": "int", "description": "Exact number of characte...	{"type": "object", "properties": {"length": {"type": "int", "description": "Fixed length in bytes (f...	{"type": "object", "properties": {"max_size": {"type": "int", "description": "Maximum size in bytes"...	{"type": "object", "properties": {"min_date": {"type": "string", "description": "Minimum allowed dat...	{"type": "object", "properties": {"with_timezone": {"type": "boolean", "description": "Whether to in...	{"type": "object", "properties": {"with_timezone": {"type": "boolean", "description": "Whether to in...	{"type": "object", "properties": {}}	{"type": "object", "properties": {"binary": {"type": "boolean", "description": "Whether to use binar...	{"type": "object", "properties": {"values": {"type": "string", "description": "JSON array of allowed...	{"type": "object", "properties": {"srid": {"type": "int", "description": "Spatial Reference System I...	{"type": "object", "properties": {"currency": {"type": "string", "description": "ISO 4217 currency c...	{"type": "object", "properties": {"fields": {"type": "enum", "description": "Interval precision fiel...