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

CREATE TABLE "process_comments" (
  "process_id"          VARCHAR(254)    NOT NULL,
  "process_version_id"  INTEGER         NOT NULL,
  "content"             VARCHAR(100000) NOT NULL,
  "user"                VARCHAR(254)    NOT NULL,
  "create_date"         TIMESTAMP       NOT NULL
);

ALTER TABLE "process_comments"
ADD CONSTRAINT "proc_comments_proc_version_fk" FOREIGN KEY ("process_id", "process_version_id") REFERENCES "process_versions" ("process_id", "id");