CREATE TABLE `def_scorecard` (
`Package` CHAR(255) NULL DEFAULT NULL COLLATE {collation},
`Module` VARCHAR(255) DEFAULT NULL,
`ScorecardGuid` CHAR(50) NOT NULL COLLATE {collation},
`Scorecard` CHAR(50) NOT NULL COLLATE {collation},
`Variable` CHAR(50) NOT NULL COLLATE {collation},
`AttributeID` INT(11) NOT NULL DEFAULT 0,
`AttributeType` CHAR(50) NULL DEFAULT NULL COLLATE {collation},
`AttributeLower` CHAR(50) NULL DEFAULT NULL COLLATE {collation},
`AttributeHigher` CHAR(50) NULL DEFAULT NULL COLLATE {collation},
`Attribute` CHAR(200) NULL DEFAULT NULL COLLATE {collation},
`Score` DOUBLE NULL DEFAULT NULL,
`Description` CHAR(255) NULL DEFAULT NULL COLLATE {collation},
`Version` CHAR(255) NULL DEFAULT NULL COLLATE {collation},
`Active` CHAR(1) NULL DEFAULT NULL COLLATE {collation},
`DatasetName` VARCHAR(255) NULL DEFAULT NULL COLLATE {collation},
`ModelName` VARCHAR(255) NULL DEFAULT NULL COLLATE {collation},
`TargetClass` VARCHAR(100) NULL DEFAULT NULL COLLATE {collation},
`WoeValue` DOUBLE NULL DEFAULT NULL,
`CreatedAt` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
`UpdatedAt` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`ScorecardGuid`) USING BTREE,
UNIQUE INDEX `Scorecard` (`Scorecard`, `Variable`, `AttributeID`) USING BTREE,
INDEX `Score` (`Scorecard`) USING BTREE,
INDEX `Variable` (`Variable`) USING BTREE,
INDEX `AttributeID` (`AttributeID`) USING BTREE,
INDEX `DatasetModel` (`DatasetName`, `ModelName`) USING BTREE
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE={collation} COMMENT='Unified scorecard table for both production and ML use cases';