Query

database.sqlite — workflow_review_request

SQL

CREATE TABLE "workflow_review_request"  (
  "id" varchar(36) PRIMARY KEY NOT NULL,
  "projectId" varchar(36) NOT NULL,
  "state" varchar(16) NOT NULL DEFAULT ('open'),
  "decision" varchar(50) NOT NULL DEFAULT ('pending'),
  "title" varchar(255) NOT NULL,
  "description" text,
  "createdById" varchar,
  "updatedById" varchar,
  "closedById" varchar,
  "approvedAt" datetime(3),
  "createdAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
  "updatedAt" datetime(3) NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'NOW')),
  CONSTRAINT "CHK_workflow_review_request_state" CHECK ("state" IN ('open', 'closed')),
  CONSTRAINT "CHK_workflow_review_request_decision" CHECK ("decision" IN ('pending', 'changes_requested', 'approved')),
  CONSTRAINT "FK_c218d1df94adc3b169dee3cc06c" FOREIGN KEY ("projectId") REFERENCES "project" ("id") ON DELETE CASCADE,
  CONSTRAINT "FK_21d5f5a831d2e38960030bb4f60" FOREIGN KEY ("createdById") REFERENCES "user" ("id") ON DELETE SET NULL,
  CONSTRAINT "FK_2817c3a0245197b498818c447cb" FOREIGN KEY ("updatedById") REFERENCES "user" ("id") ON DELETE SET NULL,
  CONSTRAINT "FK_d53ef208e6055f328dd7b897e51" FOREIGN KEY ("closedById") REFERENCES "user" ("id") ON DELETE SET NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id varchar(36) ✓ Rename | Drop
projectId varchar(36) Rename | Drop
state varchar(16) Rename | Drop
decision varchar(50) Rename | Drop
title varchar(255) Rename | Drop
description TEXT ✓ Rename | Drop
createdById varchar ✓ Rename | Drop
updatedById varchar ✓ Rename | Drop
closedById varchar ✓ Rename | Drop
approvedAt datetime(3) ✓ Rename | Drop
createdAt datetime(3) Rename | Drop
updatedAt datetime(3) Rename | Drop

Foreign Keys

Column Destination
closedById user.id
updatedById user.id
createdById user.id
projectId project.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_workflow_review_request_project_state
  • projectId
  • state
 SQL 
CREATE INDEX "IDX_workflow_review_request_project_state"
ON "workflow_review_request"("projectId", "state")
Drop
sqlite_autoindex_workflow_review_request_1 id ✓ SQL
-- no sql found --
 Drop