tech.aroma.cql.token_tables.cql Maven / Gradle / Ivy

Go to download
//Assumes the existence of a 'Aroma' Keyspace

/*
In these tables, an owner can be either a User or an Application,
depending on the Token Type.
*/
CREATE TABLE IF NOT EXISTS Aroma.Tokens
(
	token_id uuid,
	owner_id uuid,
	owner_name text,
	features list,
	time_of_expiration timestamp,
	time_of_creation timestamp,
	organization_id uuid,
	token_type text,
	token_status text,

	PRIMARY KEY (token_id)
);

CREATE INDEX IF NOT EXISTS Tokens_By_Type ON Aroma.Tokens (token_type);

CREATE TABLE IF NOT EXISTS Aroma.Tokens_By_Owner
(
	owner_id uuid,
	token_id uuid,
	owner_name text,
	time_of_creation timestamp,
	time_of_expiration timestamp,
	organization_id uuid,
	token_type text,
	token_status text,

	PRIMARY KEY ((owner_id), token_id)
);