-- CreateTable
CREATE TABLE `payments` (
    `id` BIGINT NOT NULL AUTO_INCREMENT,
    `publicId` VARCHAR(36) NOT NULL,
    `paymentCode` VARCHAR(50) NOT NULL,
    `bookingId` BIGINT NOT NULL,
    `customerUserId` BIGINT NOT NULL,
    `method` ENUM('CASH', 'UPI', 'CARD', 'NET_BANKING', 'WALLET', 'PAYMENT_GATEWAY') NOT NULL,
    `status` ENUM('CREATED', 'PENDING', 'AUTHORIZED', 'CAPTURED', 'SUCCESS', 'FAILED', 'CANCELLED', 'PARTIALLY_REFUNDED', 'REFUNDED') NOT NULL DEFAULT 'CREATED',
    `amount` DECIMAL(14, 2) NOT NULL,
    `currency` CHAR(3) NOT NULL DEFAULT 'INR',
    `gatewayProvider` VARCHAR(80) NULL,
    `gatewayOrderId` VARCHAR(191) NULL,
    `gatewayPaymentId` VARCHAR(191) NULL,
    `gatewayReference` VARCHAR(191) NULL,
    `idempotencyKey` VARCHAR(191) NULL,
    `failureCode` VARCHAR(100) NULL,
    `failureMessage` VARCHAR(500) NULL,
    `authorizedAt` DATETIME(3) NULL,
    `capturedAt` DATETIME(3) NULL,
    `paidAt` DATETIME(3) NULL,
    `failedAt` DATETIME(3) NULL,
    `createdAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
    `updatedAt` DATETIME(3) NOT NULL,

    UNIQUE INDEX `payments_publicId_key`(`publicId`),
    UNIQUE INDEX `payments_paymentCode_key`(`paymentCode`),
    UNIQUE INDEX `payments_idempotencyKey_key`(`idempotencyKey`),
    INDEX `payments_bookingId_status_idx`(`bookingId`, `status`),
    INDEX `payments_customerUserId_createdAt_idx`(`customerUserId`, `createdAt`),
    INDEX `payments_gatewayProvider_gatewayOrderId_idx`(`gatewayProvider`, `gatewayOrderId`),
    INDEX `payments_gatewayProvider_gatewayPaymentId_idx`(`gatewayProvider`, `gatewayPaymentId`),
    INDEX `payments_status_createdAt_idx`(`status`, `createdAt`),
    PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- CreateTable
CREATE TABLE `refunds` (
    `id` BIGINT NOT NULL AUTO_INCREMENT,
    `publicId` VARCHAR(36) NOT NULL,
    `refundCode` VARCHAR(50) NOT NULL,
    `paymentId` BIGINT NOT NULL,
    `amount` DECIMAL(14, 2) NOT NULL,
    `currency` CHAR(3) NOT NULL DEFAULT 'INR',
    `status` ENUM('CREATED', 'PENDING', 'PROCESSING', 'SUCCESS', 'FAILED', 'CANCELLED') NOT NULL DEFAULT 'CREATED',
    `reason` VARCHAR(500) NULL,
    `gatewayRefundId` VARCHAR(191) NULL,
    `gatewayReference` VARCHAR(191) NULL,
    `idempotencyKey` VARCHAR(191) NULL,
    `requestedAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
    `processedAt` DATETIME(3) NULL,
    `failedAt` DATETIME(3) NULL,
    `createdAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
    `updatedAt` DATETIME(3) NOT NULL,

    UNIQUE INDEX `refunds_publicId_key`(`publicId`),
    UNIQUE INDEX `refunds_refundCode_key`(`refundCode`),
    UNIQUE INDEX `refunds_idempotencyKey_key`(`idempotencyKey`),
    INDEX `refunds_paymentId_status_idx`(`paymentId`, `status`),
    INDEX `refunds_status_requestedAt_idx`(`status`, `requestedAt`),
    PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- CreateTable
CREATE TABLE `wallets` (
    `id` BIGINT NOT NULL AUTO_INCREMENT,
    `publicId` VARCHAR(36) NOT NULL,
    `userId` BIGINT NOT NULL,
    `ownerType` ENUM('CUSTOMER', 'DRIVER') NOT NULL,
    `availableBalance` DECIMAL(14, 2) NOT NULL DEFAULT 0,
    `pendingBalance` DECIMAL(14, 2) NOT NULL DEFAULT 0,
    `currency` CHAR(3) NOT NULL DEFAULT 'INR',
    `createdAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
    `updatedAt` DATETIME(3) NOT NULL,

    UNIQUE INDEX `wallets_publicId_key`(`publicId`),
    UNIQUE INDEX `wallets_userId_key`(`userId`),
    INDEX `wallets_ownerType_idx`(`ownerType`),
    PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- CreateTable
CREATE TABLE `wallet_transactions` (
    `id` BIGINT NOT NULL AUTO_INCREMENT,
    `publicId` VARCHAR(36) NOT NULL,
    `walletId` BIGINT NOT NULL,
    `transactionType` ENUM('CREDIT', 'DEBIT') NOT NULL,
    `reason` ENUM('RIDE_PAYMENT', 'RIDE_EARNING', 'REFUND', 'COMMISSION', 'SETTLEMENT', 'ADJUSTMENT', 'PROMOTION', 'CANCELLATION', 'OTHER') NOT NULL,
    `amount` DECIMAL(14, 2) NOT NULL,
    `balanceBefore` DECIMAL(14, 2) NOT NULL,
    `balanceAfter` DECIMAL(14, 2) NOT NULL,
    `currency` CHAR(3) NOT NULL DEFAULT 'INR',
    `referenceType` VARCHAR(80) NULL,
    `referenceId` VARCHAR(191) NULL,
    `idempotencyKey` VARCHAR(191) NOT NULL,
    `description` VARCHAR(500) NULL,
    `createdAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),

    UNIQUE INDEX `wallet_transactions_publicId_key`(`publicId`),
    UNIQUE INDEX `wallet_transactions_idempotencyKey_key`(`idempotencyKey`),
    INDEX `wallet_transactions_walletId_createdAt_idx`(`walletId`, `createdAt`),
    INDEX `wallet_transactions_referenceType_referenceId_idx`(`referenceType`, `referenceId`),
    PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- CreateTable
CREATE TABLE `commissions` (
    `id` BIGINT NOT NULL AUTO_INCREMENT,
    `publicId` VARCHAR(36) NOT NULL,
    `bookingId` BIGINT NOT NULL,
    `driverId` BIGINT NOT NULL,
    `grossFare` DECIMAL(14, 2) NOT NULL,
    `commissionPercent` DECIMAL(6, 2) NOT NULL,
    `commissionAmount` DECIMAL(14, 2) NOT NULL,
    `taxAmount` DECIMAL(14, 2) NOT NULL DEFAULT 0,
    `driverNetAmount` DECIMAL(14, 2) NOT NULL,
    `currency` CHAR(3) NOT NULL DEFAULT 'INR',
    `status` ENUM('PENDING', 'CALCULATED', 'SETTLED', 'WAIVED', 'REVERSED') NOT NULL DEFAULT 'PENDING',
    `calculatedAt` DATETIME(3) NULL,
    `settledAt` DATETIME(3) NULL,
    `createdAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
    `updatedAt` DATETIME(3) NOT NULL,

    UNIQUE INDEX `commissions_publicId_key`(`publicId`),
    INDEX `commissions_driverId_status_idx`(`driverId`, `status`),
    INDEX `commissions_status_createdAt_idx`(`status`, `createdAt`),
    UNIQUE INDEX `commissions_bookingId_driverId_key`(`bookingId`, `driverId`),
    PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- CreateTable
CREATE TABLE `settlements` (
    `id` BIGINT NOT NULL AUTO_INCREMENT,
    `publicId` VARCHAR(36) NOT NULL,
    `settlementCode` VARCHAR(50) NOT NULL,
    `driverId` BIGINT NOT NULL,
    `grossAmount` DECIMAL(14, 2) NOT NULL,
    `deductionAmount` DECIMAL(14, 2) NOT NULL DEFAULT 0,
    `netAmount` DECIMAL(14, 2) NOT NULL,
    `currency` CHAR(3) NOT NULL DEFAULT 'INR',
    `status` ENUM('CREATED', 'PENDING', 'PROCESSING', 'SUCCESS', 'FAILED', 'CANCELLED') NOT NULL DEFAULT 'CREATED',
    `bankReference` VARCHAR(191) NULL,
    `gatewayReference` VARCHAR(191) NULL,
    `idempotencyKey` VARCHAR(191) NULL,
    `periodStart` DATETIME(3) NULL,
    `periodEnd` DATETIME(3) NULL,
    `initiatedAt` DATETIME(3) NULL,
    `processedAt` DATETIME(3) NULL,
    `failedAt` DATETIME(3) NULL,
    `createdAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
    `updatedAt` DATETIME(3) NOT NULL,

    UNIQUE INDEX `settlements_publicId_key`(`publicId`),
    UNIQUE INDEX `settlements_settlementCode_key`(`settlementCode`),
    UNIQUE INDEX `settlements_idempotencyKey_key`(`idempotencyKey`),
    INDEX `settlements_driverId_status_idx`(`driverId`, `status`),
    INDEX `settlements_status_createdAt_idx`(`status`, `createdAt`),
    PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- CreateTable
CREATE TABLE `settlement_items` (
    `id` BIGINT NOT NULL AUTO_INCREMENT,
    `publicId` VARCHAR(36) NOT NULL,
    `settlementId` BIGINT NOT NULL,
    `commissionId` BIGINT NOT NULL,
    `amount` DECIMAL(14, 2) NOT NULL,
    `createdAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),

    UNIQUE INDEX `settlement_items_publicId_key`(`publicId`),
    UNIQUE INDEX `settlement_items_commissionId_key`(`commissionId`),
    INDEX `settlement_items_settlementId_idx`(`settlementId`),
    PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- AddForeignKey
ALTER TABLE `payments` ADD CONSTRAINT `payments_bookingId_fkey` FOREIGN KEY (`bookingId`) REFERENCES `bookings`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE `payments` ADD CONSTRAINT `payments_customerUserId_fkey` FOREIGN KEY (`customerUserId`) REFERENCES `users`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE `refunds` ADD CONSTRAINT `refunds_paymentId_fkey` FOREIGN KEY (`paymentId`) REFERENCES `payments`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE `wallets` ADD CONSTRAINT `wallets_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `users`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE `wallet_transactions` ADD CONSTRAINT `wallet_transactions_walletId_fkey` FOREIGN KEY (`walletId`) REFERENCES `wallets`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE `commissions` ADD CONSTRAINT `commissions_bookingId_fkey` FOREIGN KEY (`bookingId`) REFERENCES `bookings`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE `commissions` ADD CONSTRAINT `commissions_driverId_fkey` FOREIGN KEY (`driverId`) REFERENCES `drivers`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE `settlements` ADD CONSTRAINT `settlements_driverId_fkey` FOREIGN KEY (`driverId`) REFERENCES `drivers`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE `settlement_items` ADD CONSTRAINT `settlement_items_settlementId_fkey` FOREIGN KEY (`settlementId`) REFERENCES `settlements`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE `settlement_items` ADD CONSTRAINT `settlement_items_commissionId_fkey` FOREIGN KEY (`commissionId`) REFERENCES `commissions`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

