CREATE TABLE `average_daily_balance` (
  `Id` bigint NOT NULL AUTO_INCREMENT COMMENT 'Unique Id generation',
  `Client_Id` varchar(30) DEFAULT NULL COMMENT 'Customer ID',
  `As_On_Date` datetime DEFAULT NULL COMMENT 'As on Date',
  `Avg_Daily_Balance` decimal(15,2) DEFAULT NULL COMMENT 'Average Daily Balance',
  `Created_By` varchar(50) DEFAULT NULL COMMENT 'Created By',
  `Created_On` datetime DEFAULT CURRENT_TIMESTAMP COMMENT 'Created Date',
  PRIMARY KEY (`Id`),
  KEY `idx_average_daily_balance_Client_Id` (`Client_Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

CREATE TABLE `average_daily_balance_history` (
  `Id` bigint NOT NULL AUTO_INCREMENT COMMENT 'Unique Id generation',
  `Client_Id` varchar(30) DEFAULT NULL COMMENT 'Customer ID',
  `As_On_Date` datetime DEFAULT NULL COMMENT 'As on Date',
  `Avg_Daily_Balance` decimal(15,2) DEFAULT NULL COMMENT 'Average Daily Balance',
  `Created_By` varchar(50) DEFAULT NULL COMMENT 'Created By',
  `Created_On` datetime DEFAULT CURRENT_TIMESTAMP COMMENT 'Created Date',
  PRIMARY KEY (`Id`),
  KEY `idx_average_daily_balance_history_Client_Id` (`Client_Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;