create_postgres_state_tbl.sql

CREATE TABLE IF NOT EXISTS "states" (
	"state_id" CHARACTER VARYING NOT NULL COMMENT E'',
	"flow_name" CHARACTER VARYING NULL DEFAULT NULL COMMENT E'',
	"current_map_element" CHARACTER VARYING NULL DEFAULT NULL COMMENT E'',
	"flow_id" CHARACTER VARYING NULL DEFAULT NULL COMMENT E'',
	"version_id" CHARACTER VARYING NULL DEFAULT NULL COMMENT E'',
	"current_map_element_id" CHARACTER VARYING NULL DEFAULT NULL COMMENT E'',
	"current_user_email" CHARACTER VARYING NULL DEFAULT NULL COMMENT E'',
	"current_user_id" CHARACTER VARYING NULL DEFAULT NULL COMMENT E'',
	"date_created" CHARACTER VARYING NULL DEFAULT NULL COMMENT E'',
	"date_modified" CHARACTER VARYING NULL DEFAULT NULL COMMENT E'',
	"expires_at" CHARACTER VARYING NULL DEFAULT NULL COMMENT E'',
	"external_identifier" CHARACTER VARYING NULL DEFAULT NULL COMMENT E'',
	"has_root_faults" BOOLEAN NULL DEFAULT NULL COMMENT E'',
	"is_done" BOOLEAN NULL DEFAULT NULL COMMENT E'',
	"is_expired" BOOLEAN NULL DEFAULT NULL COMMENT E'',
	"joinuri" CHARACTER VARYING NULL DEFAULT NULL COMMENT E'',
	"log" CHARACTER VARYING NULL DEFAULT NULL COMMENT E'',
	"tenant_id" CHARACTER VARYING NULL DEFAULT NULL COMMENT E'',
	"parent_id" CHARACTER VARYING NULL DEFAULT NULL COMMENT E'',
	"root_faults" CHARACTER VARYING NULL DEFAULT NULL COMMENT E'',
	"store_id" CHARACTER VARYING NULL DEFAULT NULL COMMENT E'',
	PRIMARY KEY ("state_id")
);