Supported Features
Kuneiform has a set of supported data types and attributes
Kwil supports a restricted set of data types compared to other relational databases. If there is a data type your application would like to see added, please let us know! Below is a list of currently supported data types
Data Type | Restrictions |
---|---|
TEXT | Must be no greater than 1024 characters |
INT | Must be within -9,223,372,036,854,775,808 and 9,223,372,036,854,775,807 |
Attributes refer to a the properties and constraints of a column. A column can have multiple attributes. Some attributes require values to be defined with them. Below is a list of supported attributes:
Attribute | Description |
---|---|
Primary Key | Identifies a column as the table's primary key. In Kwil, primary key variables are nullable. |
Unique | Ensures that all values in a column are unique. Also creates a unique index on the column. |
Not Null | Ensures that all values in the column are not null. |
Default | If no value is provided to a new record, the column will be set to the passed value. |
Min | Specifies a minimum value for an INT column. |
Max | Specifies a maximum value for an INT column. |
Min Length | Specifies a minimum length for a TEXT column. |
Max Length | Specifies a maximum length for a TEXT column. |
Last modified 1mo ago