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.
ItemDescription
ElementA name consists of uppercase letters (A to Z) or lowercase letters (a to z), digits (0 to 9), and underscores (_).
First letter of a nameA name must start with an uppercase letter (A to Z), a lowercase letter (a to z), or an underscore (_).
Case sensitivityA name is case-sensitive.
LengthA name can be 1 to 255 characters in length.
Uniqueness
  • A table name must be unique in the same instance.
  • Table names can be the same in different instances.

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 typeDefinitionSize
    StringData is UTF-8 encoded. Empty strings are allowed.Up to 1 KB
    IntegerData is 64-bit signed integers. Auto-increment primary key columns are supported.8 bytes
    BinaryData is of the BINARY type. Empty values are allowed.Up to 1 KB
  • Data types supported by attribute columns
    Data typeDefinitionSize
    StringData is UTF-8 encoded. Empty strings are allowed.For more information, see General limits.
    IntegerData is 64-bit signed integers.8 bytes
    DoubleData is 64-bit and of the DOUBLE type.8 bytes
    BooleanData is of the BOOLEAN type. The value can be True or False.1 byte
    BinaryData is of the BINARY type. Empty values are allowed.For more information, see General limits.