The following data types are supported by the Scorer. The corresponding data types on Aster Database are also listed.
| Scoring Data Type | Aster (SQL) Data type |
|---|---|
| INT | INTEGER, SERIAL |
| LONG | BIGINT, BIGSERIAL |
| SHORT | SMALLINT |
| FLOAT | REAL |
| DOUBLE | DOUBLE PRECISION, NUMERIC, DECIMAL |
| BOOLEAN | BOOLEAN |
| BYTE | BYTEA |
| STRING | CHARACTER, CHARACTER VARYING, VARCHAR, IP4, IP4RANGE, BIT, BIT VARYING, UUID, INTERVAL, TEXT |
| DATE | DATE |
| TIME | TIME (TIME WITHOUT TIME ZONE), TIME WITH TIME ZONE |
| TIMESTAMP | TIMESTAMP (TIMESTAMP WITHOUT TIME ZONE), TIMESTAMP WITH TIME ZONE |
For date, time, and timestamp data types, format conversions are required when transforming data from Aster Database to Aster Scoring SDK for compatibility of SQL data types with the Java library (java.sql package).