-- CreateEnum CREATE TYPE "ActivityType" AS ENUM ('UPDATE_GROUP', 'CREATE_EXPENSE', 'UPDATE_EXPENSE', 'DELETE_EXPENSE'); -- CreateTable CREATE TABLE "Activity" ( "id" TEXT NOT NULL, "groupId" TEXT NOT NULL, "time" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP, "activityType" "ActivityType" NOT NULL, "participantId" TEXT, "expenseId" TEXT, "data" TEXT, CONSTRAINT "Activity_pkey" PRIMARY KEY ("id") ); -- AddForeignKey ALTER TABLE "Activity" ADD CONSTRAINT "Activity_groupId_fkey" FOREIGN KEY ("groupId") REFERENCES "Group"("id") ON DELETE RESTRICT ON UPDATE CASCADE;