CREATE TABLE "type_availability_policy_scope" (
"id" varchar(36) PRIMARY KEY NOT NULL,
"kind" varchar(64) NOT NULL,
"projectId" varchar(36),
"defaultAction" varchar(16) NOT NULL,
"version" integer NOT NULL DEFAULT (1),
"updatedBy" varchar(36) NOT NULL,
"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_type_availability_policy_scope_defaultAction" CHECK ("defaultAction" IN ('allow', 'deny', 'delegate')),
CONSTRAINT "FK_73c152c542cea477208c3106193" FOREIGN KEY ("projectId") REFERENCES "project" ("id") ON DELETE CASCADE
)