CREATE TABLE "project" (
"id" varchar(36) PRIMARY KEY NOT NULL,
"name" varchar(255) NOT NULL,
"type" 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')),
"icon" text,
"description" varchar(512),
"creatorId" varchar,
"customTelemetryTags" text NOT NULL DEFAULT ('[]'),
CONSTRAINT "projects_creatorId_foreign" FOREIGN KEY ("creatorId") REFERENCES "user" ("id") ON DELETE SET NULL ON UPDATE NO ACTION
)