Create Model

Create Admatic Keyspace and Tables

cqlsh 172.31.85.62

CREATE KEYSPACE admatic WITH replication = {'class':'SimpleStrategy', 'replication_factor' : 3};

use admatic;

CREATE TABLE users_by_username (
    username text PRIMARY KEY,
    email text,
    age int
);

CREATE TABLE users_by_email (
    email text PRIMARY KEY,
    username text,
    age int
);

Create Others Keyspace and Tables

CREATE KEYSPACE others WITH replication = {'class':'SimpleStrategy', 'replication_factor' : 3};

use others;

CREATE TABLE users (
    id uuid PRIMARY KEY,
    username text,
    email text,
    age int
);

CREATE TABLE users_by_username (
    username text PRIMARY KEY,
    id uuid
);

CREATE TABLE users_by_email (
    email text PRIMARY KEY,
    id uuid
);