Skip to content

Schema

Create a table schema; define properties of the table and data columns via the UI. Additional information on Table configuration can be found here.

Screenshot

Set up

  1. Name a schema and optionally add to a schema list.

  2. Add details to current Table, add additional tables as needed.

  3. Define Table properties

  4. Add a data column; define type and include optional Description.

Create

item description
Schema Name Name the schema to be created
Add To Add schema to existing schema list

Screenshot

Properties

item description
Primary Keys A list of primary key column names.
Description Description of the table purpose.
Type Select between splayed or partitioned.
Shards Set number of shards.
Partitions Set number of partitions.
Block Size Set block size.
Partition Column Select from dropdown options; defaults to none.
Timestamp Column Select from dropdown options; defaults to none.
On-Disk Column Sort (Temporal Partitioning) A list of names of columns to sort on when stored on disk.
In-Memory Column Sort A list of names of columns to sort on when stored in memory.
On-Disk Column Sort (Ordinal Partitioning) A list of names of columns to sort on when stored on disk with an ordinal partition scheme.

Columns

Click [+] to add a column, [-] to remove one. Columns can be repositioned by click-and-drag.

Screenshot

item description
Name Assign a name to the column in the table.
Type Select the data type for the column; boolean, guid, byte, short, int, long, real, float, char, symbol, timestamp, month, date, datetime, timespan, minute, second or time.
Description Optional description of the column purpose.
Primary Key Check if a Primary Key column.
On-Disk Attribute (Temporal Partitioning) Column attribute when stored on disk. Select from None, Sorted, Grouped, Parted and Unique.
In-Memory Attribute Column attribute when stored in memory. Select from None, Sorted, Grouped, Parted and Unique.
On-Disk Attribute (Ordinal Partitioning) Column attribute when stored on disk with an ordinal partition scheme. Select from None, Sorted, Grouped, Parted and Unique.
Foreign A foreign key into another table in this Assembly of the form table.column.

Storage Manager Tables Configuration