• Home
• tech.aroma
• aroma-data-operations
• 2.1
• source code
• followings_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.followings_ddl.sql Maven / Gradle / Ivy

------------------------------------------------------------------------------
-- STORES AN APP'S FOLLOWERS AND REMEMBERS WHAT APP A User Follows
------------------------------------------------------------------------------

CREATE TABLE IF NOT EXISTS Followings
(
    app_id         UUID,
    user_id        UUID,
    time_of_follow TIMESTAMPTZ DEFAULT now(),

    PRIMARY KEY (user_id, app_id)
)
;

CREATE INDEX IF NOT EXISTS App_Followers
    ON Followings (app_id)
;