Documentation

Data types and constraints

Data types and constraints are used to define table columns when creating tables via SQL.

NOTE: For ease of use, Constraint information is included with the relevant Data type reference.

Before you begin

Data types

Data types used to define the type of data that a table column can contain. They are modified by Constraints.

Mapping data types

SQL Data Type FeatureBase Data Type
int int
bool bool
timestamp timestamp
decimal decimal
string keyed mutex
stringset keyed set
id mutex
idset set

Numeric data types

String data types

Date/Time data types

FeatureBase data types

Constraints

Constraints are applied to data types to modify and optimize how table data is stored and accessed.

Constraints are applied when a column is created.

Constraint Data type
EPOCH TIMESTAMP
MIN, MAX INT
SCALE DECIMAL
TIMEQUANTUM, TTL IDSET
STRINGSET
TIMEUNIT TIMESTAMP

Further information

Something missing or incorrect?
Help improve this article or join us on Discord!

© 2022 Molecula Corp. (DBA FeatureBase). All rights reserved.