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

---------------------------------------
-- DDL FOR AROMA INBOX MESSAGES
--
-- The inbox is where messages are kept individually for
-- Aroma users
---------------------------------------

CREATE TABLE IF NOT EXISTS Inbox
(
    user_id       UUID,
    message_id    UUID,
    app_id        UUID,
    app_name      TEXT,
    title         TEXT,
    body          TEXT,
    priority      TEXT,
    time_created  TIMESTAMPTZ DEFAULT now(),
    time_received TIMESTAMPTZ DEFAULT now(),
    hostname      TEXT,
    mac_address   TEXT,
    device_name   TEXT,

    PRIMARY KEY (user_id, message_id)
);