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

------------------------------------------------------------------------------
-- APPLICATIONS PROVISIONED TO WORK WITH AROMA
------------------------------------------------------------------------------

CREATE TABLE IF NOT EXISTS Applications
(
    app_id                   UUID,
    app_name                 TEXT,
    app_description          TEXT,
    organization_id          UUID,
    owners                   UUID[],
    programming_language     TEXT,
    time_provisioned         TIMESTAMPTZ DEFAULT now(),
    time_last_updated        TIMESTAMPTZ DEFAULT now(),
    tier                     TEXT,
    time_of_token_expiration TIMESTAMP,
    app_icon_media_id        UUID,

    PRIMARY KEY (app_id)
);

CREATE INDEX IF NOT EXISTS Applications_By_Organization
    ON Applications (organization_id);

-- USED FOR REMEMBERING AN Application's Owners
CREATE TABLE IF NOT EXISTS Application_Owners
(
    app_id   UUID,
    owner_id UUID,
    since    TIMESTAMP DEFAULT now(),

    PRIMARY KEY (app_id, owner_id)
)