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
-
Name a schema and optionally add to a schema list.
-
Add details to current Table, add additional tables as needed.
-
Define Table properties
-
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. |