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

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

/* Stores Organization Information */
CREATE TABLE IF NOT EXISTS Aroma.Organizations
(
	org_id uuid,
	org_name text,
	owners set,
	icon_link text,
	industry text,
	contact_email text,
	github_profile text,
	stock_name text,
	tier text,
	description text,
	website text,

	PRIMARY KEY (org_id)
);

CREATE INDEX IF NOT EXISTS Organizations_By_Tier ON Aroma.Organizations (tier);

CREATE INDEX IF NOT EXISTS Organizations_By_Industry ON Aroma.Organizations (industry);

/* Stores information relating to an Organization's members */
CREATE TABLE IF NOT EXISTS Aroma.Organizations_Members
(
	org_id uuid,
	user_id uuid,
	org_name text,
	user_first_name text,
	user_middle_name text,
	user_last_name text,
	user_roles set,
	user_email text,

	PRIMARY KEY ((org_id), user_id)
);

CREATE INDEX IF NOT EXISTS Organizations_Members_By_Email ON Aroma.Organizations_Members (user_email);

CREATE INDEX IF NOT EXISTS Organizations_Members_By_Role ON Aroma.Organizations_Members (user_roles);

CREATE INDEX IF NOT EXISTS Organizations_Members_By_User ON Aroma.Organizations_Members (user_id);