CREATE TABLE `AuditSchedule_Application` ( `Id` INTEGER NOT NULL AUTO_INCREMENT , `UserId` INTEGER NOT NULL , `AuditId` INTEGER NOT NULL , `ScheduledId` INTEGER NOT NULL , `IsDeleted` TINYINT (?) NOT NULL , `IsActive` TINYINT (?) NOT NULL , `Createdby` INTEGER NOT NULL , `CreatedDate` DATETIME (?) NOT NULL , `Updatedby` INTEGER NOT NULL , `UpdatedDate` DATETIME (?) NULL , `QuestionId` INTEGER NOT NULL , `QuestionType` LONGTEXT CHARACTER SET ASCII NULL , `QuestionTitle` LONGTEXT CHARACTER SET ASCII NULL , `Answer` LONGTEXT CHARACTER SET ASCII NULL , `AnswerType` LONGTEXT CHARACTER SET ASCII NULL , `DocumentUrl` LONGTEXT CHARACTER SET ASCII NULL , `SM_Id` INTEGER NOT NULL , `Comments` LONGTEXT CHARACTER SET ASCII NULL , `IsStatus` INTEGER NOT NULL , `IsIAStatus` INTEGER NOT NULL , `IsEAStatus` INTEGER NOT NULL , `IA_Id` INTEGER NOT NULL , `IA_Answer` VARCHARACTER (?) CHARACTER SET ASCII NULL , `IA_DocumentUrl` VARCHARACTER (?) CHARACTER SET ASCII NULL , `IA_Comments` VARCHARACTER (?) CHARACTER SET ASCII NULL , `EA_Id` INTEGER NOT NULL , `EA_Answer` VARCHARACTER (?) CHARACTER SET ASCII NULL , `Likelihood` VARCHARACTER (?) CHARACTER SET ASCII NULL , `Consequence` VARCHARACTER (?) CHARACTER SET ASCII NULL , `Exposure` VARCHARACTER (?) CHARACTER SET ASCII NULL , `EA_DocumentUrl` VARCHARACTER (?) CHARACTER SET ASCII NULL , `EA_Comments` VARCHARACTER (?) CHARACTER SET ASCII NULL , `ComplinaceType` LONGTEXT CHARACTER SET ASCII NULL , `sm_Comments` LONGTEXT CHARACTER SET ASCII NULL , CONSTRAINT `PK_AuditSchedule_Application` PRIMARY KEY ( `Id` ) ) CHARACTER SET = ASCII 