OpenAPI types mapping: BDL

Conversion mapping for Genero BDL data types in OpenAPI documentation.

Table 1. OpenAPI (JSON) data types mapping for Genero BDL data types
Genero BDL data types JSON data types Format Additional format keywords
STRING STRING
VARCHAR(5) STRING maxLength: 5

For an example, go to VARCHAR(N)
CHAR STRING
DATE STRING format: date For examples of date conversion, go to DATE/DATETIME
DATETIME YEAR TO SECOND STRING format: date-time For examples of datetime conversion, go to DATE/DATETIME
INTERVAL DAY(5) TO SECOND STRING
TEXT STRING
BYTE STRING format: binary
BOOLEAN BOOLEAN
INTEGER INTEGER

format: int32

TINYINT INTEGER
SMALLINT INTEGER
BIGINT INTEGER

format: int64  
DECIMAL NUMBER For examples of decimal conversion, go to DECIMAL(p,s)
SMALLFLOAT NUMBER format: float
FLOAT NUMBER format: double
MONEY NUMBER format: double

multipleOf: 0.01

minimum:-100000000000000

exclusiveMinimum: true

maximum: 100000000000000

exclusiveMaximum: true
RECORD OBJECT
DYNAMIC ARRAY OF ARRAY
ARRAY [ ] OF N/A N/A
DICTIONARY OF OBJECT additionalProperties:"type":"object"
util.JSONObject OBJECT additionalProperties: {}
util.JSONArray OBJECT additionalProperties: {}