• Home
• tech.aroma
• aroma-data-operations
• 2.1
• source code
• user_preferences_ddl.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

tech.aroma.sql.ddl.user_preferences_ddl.sql Maven / Gradle / Ivy

---------------------------------------
-- DDL FOR AROMA REACTIONS
--
--  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 User_Preferences
(
    user_id            UUID,
    serialized_devices TEXT [] DEFAULT ARRAY[]::TEXT[],
    last_sign_in       TIMESTAMPTZ DEFAULT now(),

    PRIMARY KEY (user_id)
);