You can use the Tablestore Wide Column model to store structured data. You can query, insert, modify, and delete data in the tables. One user can create multiple tables. Data in the tables is organized in forms of columns, rows, and values.
The preceding figure compares the concepts such as tables in Tablestore and spreadsheets. The following content describes the differences:
table: similar to sheets in spreadsheets. Each sheet corresponds to a table.
row: similar to rows in spreadsheets. Each row consists of column names and values in the columns.
column: similar to columns in spreadsheets. All data in a column shares the same dimension attributes.
value: similar to cells in spreadsheets. Each value indicates the value of a column in a specific row. Unlike spreadsheets, Tablestore allows columns to contain null values. Null values do not occupy storage.
The following data types are supported for values: STRING, INTEGER, BOOLEAN, DOUBLE, and BINARY. Data types of values in primary key columns can only be STRING, INTEGER, or BINARY. For more information, see Naming conventions and data types.