• Home
• sk.objectify
• notiflow
• 1.1.39
• source code
• V0_0_13__nc_intent_table.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.

db.migration.V0_0_13__nc_intent_table.sql Maven / Gradle / Ivy

/*
 *   Copyright (C) 2021 the original author or authors.
 *
 *   This file is part of Notiflow
 *
 *   This program is free software: you can redistribute it and/or modify
 *   it under the terms of the GNU Lesser General Public License as published by
 *   the Free Software Foundation, either version 3 of the License, or
 *   (at your option) any later version.
 *
 *   This program is distributed in the hope that it will be useful,
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *   GNU Lesser General Public License for more details.
 *
 *   You should have received a copy of the GNU Lesser General Public License
 *   along with this program.  If not, see .
 */

CREATE TABLE nc_intent (
	id uuid NOT NULL,
	flow_id varchar(100),
	event_ids _uuid NULL,
	payload_json jsonb NOT NULL,
	time_created timestamptz NULL,
	CONSTRAINT nc_intent_pkey PRIMARY KEY (id)
);
CREATE UNIQUE INDEX ndx_intent_id ON nc_intent USING btree (id);