CREATE TABLE `Schedular_Master` ( `ScheduleId` INTEGER NOT NULL AUTO_INCREMENT , `AuditId` INTEGER NOT NULL , `UserId` INTEGER NOT NULL , `FrequencyId` INTEGER NOT NULL , `TotalNoAudit` INTEGER NOT NULL , `ScheduleDate` DATETIME (?) NOT NULL , `IsActive` TINYINT (?) NOT NULL , `IsDeleted` TINYINT (?) NOT NULL , `IsSuspended` TINYINT (?) NOT NULL , `ScheduleStatus` VARCHARACTER (?) CHARACTER SET ASCII NULL , `IsUnsuspended` TINYINT (?) NOT NULL , `CreatedBy` INTEGER NOT NULL , `UpdatedBy` INTEGER NOT NULL , `CreatedDate` DATETIME (?) NOT NULL , `UpdatedDate` DATETIME (?) NULL , `IsCompleted` TINYINT (?) NOT NULL , `CompletedDate` DATETIME (?) NULL , `StartDate` DATETIME (?) NULL , `EndDate` DATETIME (?) NULL , `IsEdited` TINYINT (?) NOT NULL , `IsSelfAssessment` TINYINT (?) NOT NULL , `ComplianceId` INTEGER NOT NULL , CONSTRAINT `PK_Schedular_Master` PRIMARY KEY ( `ScheduleId` ) ) CHARACTER SET = ASCII 