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 |
---|---|
Structure | A name can contain uppercase letters (A to Z), lowercase letters (a to z), digits (0 to 9), and underscores (_). |
First character | 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 limit String Data is UTF-8 encoded. Empty strings are allowed. Up to 1 KB Integer Data is 64-bit integers. Auto-increment columns are supported. 8 Bytes Binary Data is of the BINARY type. Empty values are allowed. Up to 1 KB in length - Data types supported by attribute columns
Data type Definition Size limit String Data is UTF-8 encoded. Empty strings are allowed. For more information, see Limits. Integer Data is 64-bit 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 Limits.