-- CreateTable CREATE TABLE `CostItem` ( `id` INTEGER NOT NULL AUTO_INCREMENT, `name` VARCHAR(191) NOT NULL, `region` VARCHAR(191) NOT NULL, `year` INTEGER NOT NULL, `createdAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), `updatedAt` DATETIME(3) NOT NULL, INDEX `CostItem_region_year_idx`(`region`, `year`), PRIMARY KEY (`id`) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -- CreateTable CREATE TABLE `SubCostItem` ( `id` INTEGER NOT NULL AUTO_INCREMENT, `name` VARCHAR(191) NOT NULL, `subCost` DOUBLE NOT NULL, `costItemId` INTEGER NOT NULL, INDEX `SubCostItem_costItemId_idx`(`costItemId`), PRIMARY KEY (`id`) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -- CreateTable CREATE TABLE `TrendAiPercentage` ( `id` INTEGER NOT NULL AUTO_INCREMENT, `region` VARCHAR(191) NOT NULL, `year` INTEGER NOT NULL, `percentage` DOUBLE NOT NULL, UNIQUE INDEX `TrendAiPercentage_region_year_key`(`region`, `year`), PRIMARY KEY (`id`) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -- CreateTable CREATE TABLE `Year` ( `year` INTEGER NOT NULL, PRIMARY KEY (`year`) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; -- AddForeignKey ALTER TABLE `SubCostItem` ADD CONSTRAINT `SubCostItem_costItemId_fkey` FOREIGN KEY (`costItemId`) REFERENCES `CostItem`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;