Add Column

Cancel

Current Schema

CREATE TABLE "type_availability_policy_attachment"  (
  "scopeId" varchar(36) NOT NULL,
  "policyId" varchar(36) NOT NULL,
  "priority" integer NOT NULL,
  "isFloor" boolean NOT NULL DEFAULT (false),
  "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 "FK_118709fc9fe21d3406f81665a53" FOREIGN KEY ("scopeId") REFERENCES "type_availability_policy_scope" ("id") ON DELETE CASCADE,
  CONSTRAINT "FK_674705e4c8a3d3eb0736f8e8eee" FOREIGN KEY ("policyId") REFERENCES "type_availability_policy" ("id") ON DELETE RESTRICT,
  PRIMARY KEY ("scopeId", "policyId")
)