CREATE TABLE "user_broadcast"( 
    "id"                    bigserial PRIMARY KEY,
    "usertype"              TEXT[] NOT NULL,
    "message"               TEXT   NOT NULL,
    "created_at"            TIMESTAMPTZ NOT NULL DEFAULT(now())
);

CREATE TABLE "process_broadcast"( 
    "id"                    bigserial PRIMARY KEY,
    "process"               VARCHAR NOT NULL,
    "emails"                TEXT[]  NOT NULL,
    "status"                VARCHAR NOT NULL,
    "created_at"            TIMESTAMPTZ NOT NULL DEFAULT(now())
);
