Primary key¶
The primary key constraint combines a unique constraint and a not-null constraint. It also defines the default routing value used for sharding.
Example:
cr> create table my_table1 (
... first_column integer primary key,
... second_column text
... );
CREATE OK, 1 row affected (... sec)
Currently primary keys cannot be auto generated and have to be specified if data is inserted, otherwise an error is returned.
Defining multiple columns with a primary key constraint is also supported:
cr> create table my_table1pk (
... first_column integer primary key,
... second_column text primary key,
... third_column text
... );
CREATE OK, 1 row affected (... sec)
Or using a alternate syntax:
cr> create table my_table1pk1 (
... first_column integer,
... second_column text,
... third_column text,
... primary key (first_column, second_column)
... );
CREATE OK, 1 row affected (... sec)