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

---------------------------------------
-- DDL FOR AROMA TOKENS
--
-- Tokens are used to authenticate Users
-- and Applications
---------------------------------------

CREATE TABLE IF NOT EXISTS Tokens
(
    token_id           UUID,
    owner_id           UUID,
    organization_id    UUID,
    owner_name         TEXT,
    time_of_creation   TIMESTAMPTZ DEFAULT now(),
    time_of_expiration TIMESTAMPTZ DEFAULT now() + INTERVAL '30 Days',
    token_type         TEXT,
    token_status       TEXT,

    PRIMARY KEY (token_id)
);

CREATE INDEX IF NOT EXISTS Tokens_By_Type
    ON Tokens (token_type);

CREATE INDEX IF NOT EXISTS Tokens_By_Owner
    ON Tokens (owner_id);