-- CreateTable CREATE TABLE "CostItem" ( "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "name" TEXT NOT NULL, "region" TEXT NOT NULL, "year" INTEGER NOT NULL, "createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, "updatedAt" DATETIME NOT NULL ); -- CreateTable CREATE TABLE "SubCostItem" ( "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "name" TEXT NOT NULL, "subCost" REAL NOT NULL, "costItemId" INTEGER NOT NULL, CONSTRAINT "SubCostItem_costItemId_fkey" FOREIGN KEY ("costItemId") REFERENCES "CostItem" ("id") ON DELETE CASCADE ON UPDATE CASCADE ); -- CreateTable CREATE TABLE "TrendAiPercentage" ( "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "region" TEXT NOT NULL, "year" INTEGER NOT NULL, "percentage" REAL NOT NULL ); -- CreateIndex CREATE INDEX "CostItem_region_year_idx" ON "CostItem"("region", "year"); -- CreateIndex CREATE INDEX "SubCostItem_costItemId_idx" ON "SubCostItem"("costItemId"); -- CreateIndex CREATE UNIQUE INDEX "TrendAiPercentage_region_year_key" ON "TrendAiPercentage"("region", "year");