{
	"name": "table/prf/field_type.json",
	"field_type": [
		{
			"show": "boolean",
			"value": "boolean",
			"lua_type": "boolean",
			"db_value": "BOOLEAN",
			"db_array_value": "boolean[]",
			"default_value": false,
			"default_width": 60
		},
		{
			"show": "double",
			"value": "double",
			"lua_type": "number",
			"db_value": "DOUBLE PRECISION",
			"db_array_value": "double precision[]",
			"default_value": 0,
			"default_width": 60
		},
		{
			"show": "numeric",
			"value": "numeric",
			"info": "for example numeric(10,2), but we do not support numeric data type is sql",
			"lua_type": "number",
			"db_value": "DOUBLE PRECISION",
			"db_array_value": "double precision[]",
			"default_value": 0,
			"default_width": 60
		},
		{
			"show": "integer",
			"value": "integer",
			"lua_type": "number",
			"basic_type": "integer",
			"db_value": "INTEGER",
			"db_array_value": "integer[]",
			"default_value": 0,
			"default_width": 40
		},
		{
			"show": "smallint",
			"value": "smallint",
			"lua_type": "number",
			"basic_type": "integer",
			"db_value": "SMALLINT",
			"db_array_value": "smallint[]",
			"default_value": 0,
			"default_width": 40
		},
		{
			"show": "bigint",
			"value": "bigint",
			"lua_type": "number",
			"basic_type": "integer",
			"db_value": "BIGINT",
			"db_array_value": "bigint[]",
			"default_value": 0,
			"default_width": 40
		},
		{
			"show": "varchar",
			"value": "varchar",
			"lua_type": "string",
			"db_value": "VARCHAR",
			"db_array_value": "varchar[]",
			"default_value": "''",
			"default_width": 80
		},
		{
			"show": "character varying",
			"value": "character varying",
			"lua_type": "string",
			"change_to_value": "varchar",
			"db_value": "VARCHAR",
			"db_array_value": "varchar[]",
			"default_value": "''",
			"default_width": 80
		},
		{
			"show": "text",
			"value": "text",
			"lua_type": "string",
			"db_value": "TEXT",
			"db_array_value": "text[]",
			"default_value": "''",
			"default_width": 120
		},
		{
			"show": "date",
			"value": "date",
			"lua_type": "string",
			"basic_type": "date",
			"db_value": "DATE",
			"db_array_value": "date[]",
			"default_value": "'1970-01-01'",
			"default_width": 60
		},
		{
			"show": "time",
			"value": "time",
			"lua_type": "string",
			"basic_type": "time",
			"db_value": "TIME",
			"db_array_value": "time[]",
			"default_value": "'00:00:00'",
			"default_width": 60
		},
		{
			"show": "time without time zone",
			"value": "time without time zone",
			"lua_type": "string",
			"basic_type": "time",
			"db_value": "TIME WITHOUT TIME ZONE",
			"db_array_value": "time without time zone[]",
			"default_value": "'00:00:00'",
			"default_width": 60
		},
		{
			"show": "timestamp without time zone",
			"value": "timestamp without time zone",
			"lua_type": "string",
			"basic_type": "time",
			"db_value": "TIMESTAMP WITHOUT TIME ZONE",
			"db_array_value": "timestamp without time zone[]",
			"default_value": "'1970-01-01 00:00:00'",
			"default_width": 60
		},
		{
			"show": "timestamp",
			"value": "timestamp",
			"lua_type": "string",
			"basic_type": "time",
			"db_value": "TIMESTAMP WITH TIME ZONE",
			"db_array_value": "timestamp with time zone[]",
			"default_value": "'1970-01-01 00:00:00'",
			"default_width": 100
		},
		{
			"show": "jsonb",
			"value": "jsonb",
			"lua_type": "string",
			"db_value": "JSONB",
			"db_array_value": "jsonb[]",
			"default_value": "'{}'",
			"default_width": 100
		},
		{
			"show": "json",
			"value": "json",
			"lua_type": "string",
			"db_value": "JSON",
			"db_array_value": "json[]",
			"default_value": "'{}'",
			"default_width": 100
		},
		{
			"show": "blob",
			"value": "blob",
			"lua_type": "string",
			"db_value": "BYTEA",
			"db_array_value": "bytea[]",
			"default_width": 50
		},
		{
			"show": "uuid",
			"value": "uuid",
			"lua_type": "string",
			"db_value": "UUID",
			"db_array_value": "uuid[]",
			"default_value": "00000000-0000-0000-0000-000000000000",
			"default_width": 100
		},
		{
			"show": "vector",
			"value": "vector",
			"lua_type": "string",
			"db_value": "vector",
			"db_array_value": "vector[]",
			"default_width": 50
		}
	]
}
