Naming conventions and data types
This topic describes the naming conventions for tables and columns, as well as the data types supported by primary key columns and attribute columns.
Naming conventions
The following table describes the naming conventions for tables and columns.
Item | Description |
Element | A name consists of uppercase letters (A to Z) or lowercase letters (a to z), digits (0 to 9), and underscores (_). |
First letter of a name | A name must start with an uppercase letter (A to Z), a lowercase letter (a to z), or an underscore (_). |
Case sensitivity | A name is case-sensitive. |
Length | A name can be 1 to 255 characters in length. |
Uniqueness |
|
Data types
Data types supported by primary key columns include STRING, INTEGER, and BINARY. Data types supported by attribute columns include STRING, INTEGER, DOUBLE, BOOLEAN, and BINARY.
Data types supported by primary key columns
Data type
Definition
Size
String
Data is UTF-8 encoded.
Up to 1 KB
Integer
Data is 64-bit signed integers. Auto-increment primary key columns are supported.
8 bytes
Binary
Data is of the BINARY type.
Up to 1 KB
Data types supported by attribute columns
Data type
Definition
Size
String
Data is UTF-8 encoded. Empty strings are allowed.
For more information, see Wide table model limits.
Integer
Data is 64-bit signed integers.
8 bytes
Double
Data is 64-bit and of the DOUBLE type.
8 bytes
Boolean
Data is of the BOOLEAN type. The value can be True or False.
1 byte
Binary
Data is of the BINARY type. Empty values are allowed.
For more information, see Wide table model limits.