• Home
• pl.touk.nussknacker
• nussknacker-designer_2.13
• 1.16.0
• source code
• V1_012__CreateProcessAttachments.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.postgres.V1_012__CreateProcessAttachments.sql Maven / Gradle / Ivy

CREATE TABLE "process_attachments" (
  "id"                  VARCHAR(254)  NOT NULL PRIMARY KEY,
  "process_id"          VARCHAR(254)  NOT NULL,
  "process_version_id"  INTEGER       NOT NULL,
  "file_name"           VARCHAR(254)  NOT NULL,
  "file_path"           VARCHAR(1000) NOT NULL,
  "user"                VARCHAR(254)  NOT NULL,
  "create_date"         TIMESTAMP     NOT NULL
);

ALTER TABLE "process_attachments"
ADD CONSTRAINT "proc_attach_proc_version_fk" FOREIGN KEY ("process_id", "process_version_id") REFERENCES "process_versions" ("process_id", "id") ON DELETE CASCADE;