CREATE TABLE `data_simulation` (
`SimGuid` varchar(255) NOT NULL,
`Package` varchar(100) DEFAULT NULL,
`WorkflowName` varchar(100) DEFAULT NULL,
`StartTime` datetime DEFAULT NULL,
`EndTime` datetime DEFAULT NULL,
`FirstName` varchar(100) DEFAULT NULL,
`LastName` varchar(100) DEFAULT NULL,
`Email` varchar(255) DEFAULT NULL,
`Phone` varchar(50) DEFAULT NULL,
`Address` varchar(255) DEFAULT NULL,
`City` varchar(100) DEFAULT NULL,
`Country` varchar(100) DEFAULT NULL,
`CallPriority` int DEFAULT NULL,
`DiallerWorked` int DEFAULT NULL,
`ValidCell` tinyint(1) DEFAULT NULL,
`Saturday` tinyint(1) DEFAULT NULL,
`Age` int DEFAULT NULL,
`Income` decimal(12,2) DEFAULT NULL,
`CreditScore` int DEFAULT NULL,
`MonthsEmployed` int DEFAULT NULL,
`Balance` decimal(12,2) DEFAULT NULL,
`Transactions` int DEFAULT NULL,
`Gender` varchar(10) DEFAULT NULL,
`MaritalStatus` varchar(10) DEFAULT NULL,
`EmploymentStatus` varchar(50) DEFAULT NULL,
`RiskBand` varchar(20) DEFAULT NULL,
`VirtualScore` int DEFAULT NULL,
`DecisionAction` varchar(50) DEFAULT NULL,
`ContactEligible` tinyint(1) DEFAULT NULL,
`DecisionPriority` varchar(20) DEFAULT NULL,
`Module` varchar(255) DEFAULT NULL,
PRIMARY KEY (`SimGuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE={collation};