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

Go to download

//Assumes the existence of a 'Aroma' Keyspace

/*
    Used to store User Preferences and secondary information about Users, such as:
	+ Mobile Devices they own or use (for push notifications)
	+ Their Personal Reactions which are run on messages that show up in their Inbox.
	+ User Activity
*/
CREATE TABLE IF NOT EXISTS Aroma.User_Preferences
(
    user_id uuid,
    //A Serialized Set of Mobile Devices used by this user, (Android, or iOS), Serialized as a JSON String
	serialized_devices set,
    last_sign_in_time timestamp,

	PRIMARY KEY (user_id)
);