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.

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

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.

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