oz_2.12.5.3.0.source-code.mojoz-default-types.yaml Maven / Gradle / Ivy
type: string
xsd name: string
json name: string
scala name: java.lang.String
jdbc:
- LONGNVARCHAR 0
- LONGNVARCHAR 1..* -> size
- LONGVARCHAR 0
- LONGVARCHAR 1..* -> size
- DISTINCT # TODO need base type to solve this correctly
- 'NULL'
- NCHAR -> size
- NCLOB -> size
- NVARCHAR -> size
- VARCHAR *..2147483646 -> size
- VARCHAR 2147483647..*
- REF -> size
- REF_CURSOR -> size
- ROWID -> size
- SQLXML
- CHAR -> size
- CLOB *..2147483646 -> size
- CLOB 2147483647..*
- DATALINK -> size # anyURI instead?
hsqldb jdbc:
- VARCHAR *..1073741823 -> size
- VARCHAR 1073741824..*
- CLOB *..1073741823 -> size
- CLOB 1073741824..*
h2 jdbc:
- (CHARACTER VARYING *..2147483646 -> size)
- (CHARACTER VARYING 2147483647..*)
yaml:
- string
- string * -> size
sql:
- string -> clob
- string * -> varchar(size)
hsqldb sql:
- string 0..1073741823 -> varchar(size)
- string 1073741824..* -> clob
- string -> clob
postgresql:
- string -> text
- string * -> varchar(size)
oracle sql:
- string 0..4000 -> varchar2(size char)
- string 4001..* -> clob
- string -> clob
cql:
- string -> text
- string * -> text
type: date
xsd name: date
json name: string
#scala name:java.sql.Date
scala name: java.time.LocalDate
jdbc:
- DATE
yaml:
- date
sql:
- date
cql:
- date
type: time
xsd name: time
json name: string
#scala name:java.sql.Time
scala name: java.time.LocalTime
jdbc:
- TIME
- TIME_WITH_TIMEZONE
yaml:
- time
sql:
- time
cql:
- time
type: dateTime
xsd name: dateTime
json name: string
#scala name:java.sql.Timestamp
scala name: java.time.LocalDateTime
jdbc:
- TIMESTAMP
- TIMESTAMP_WITH_TIMEZONE
yaml:
- dateTime
sql:
- timestamp
cql:
- timestamp
type: short
xsd name: short
json name: number
scala name: java.lang.Short
jdbc:
- SMALLINT
- TINYINT # TODO? signed/unsigned byte?
yaml:
- short
- short * -> size, none
sql:
- smallint
cql:
- tinyint
type: int
xsd name: int
json name: number
scala name: java.lang.Integer
jdbc:
- DECIMAL *..9 0 -> size, none
- NUMERIC *..9 0 -> size, none
- INTEGER
postgresql jdbc:
- (INT4 10 0 -> none)
yaml:
- int
- int * -> size, none
sql:
- int -> integer
- int * -> numeric(size)
oracle sql:
- int -> numeric(9)
- int * -> numeric(size)
cql:
- int -> int
- int * -> int
type: long
xsd name: long
json name: number
scala name: java.lang.Long
jdbc:
- DECIMAL 10..18 0 -> size, none
- NUMERIC 10..18 0 -> size, none
- BIGINT
postgresql jdbc:
- (INT4 10..18 0 -> size, none)
- (INT8 19 0 -> none)
yaml:
- long
- long * -> size, none
sql:
- long -> bigint
- long * -> numeric(size)
oracle sql:
- long -> numeric(18)
- long * -> numeric(size)
cql:
- long -> bigint
- long * -> bigint
type: integer
xsd name: integer
json name: number
scala name: scala.math.BigInt
jdbc:
- DECIMAL 19..* 0 -> size, none
- NUMERIC 19..* 0 -> size, none
yaml:
- integer
- integer * -> size, none
sql:
- integer -> numeric
- integer * -> numeric(size)
cql:
- integer -> varint
- integer * -> varint
type: float
xsd name: float
json name: number
scala name: java.lang.Float
jdbc:
- REAL
yaml:
- float
sql:
- float
hsqldb sql:
- real
postgresql:
- real
cql:
- float
type: double
xsd name: double
json name: number
scala name: java.lang.Double
jdbc:
- DOUBLE
- FLOAT
yaml:
- double
sql:
- double precision
hsqldb sql:
- float
cql:
- double
type: decimal
xsd name: decimal
json name: number
scala name: scala.math.BigDecimal
jdbc:
- DECIMAL * 1..* -> size, frac
- NUMERIC * 1..* -> size, frac
yaml:
- decimal
- decimal * -> size, 0
- decimal * * -> size, frac
- null * * -> size, frac
sql:
- decimal -> numeric
- decimal * -> numeric(size)
- decimal * * -> numeric(size, frac)
cql:
- decimal -> decimal
- decimal * -> decimal
- decimal * * -> decimal
type: boolean
xsd name: boolean
json name: boolean
scala name: java.lang.Boolean
jdbc:
- BIT
- BOOLEAN
postgresql jdbc:
- (BOOL)
yaml:
- boolean
sql:
- boolean
postgresql:
- bool
oracle sql:
- char
cql:
- boolean
type: bytes
xsd name: base64Binary
scala name: Array[Byte]
jdbc:
- BINARY
- BLOB
- JAVA_OBJECT
- LONGVARBINARY
- OTHER
- STRUCT
- VARBINARY
yaml:
- bytes
- bytes * -> size
sql:
- bytes -> blob
- bytes * -> varbinary(size)
postgresql:
- bytes -> bytea
- bytes * -> bytea
cql:
- bytes -> blob
- bytes * -> blob
type: json
xsd name: string
scala name: java.lang.String
yaml:
- json
sql:
- text
hsqldb sql:
- longvarchar
postgresql:
- jsonb
cql:
- text
type: any
xsd name: anyType
scala name: Any
yaml:
- any