A test Table

CREATE TABLE `TAppointMst` (
  `AppId` int(11) NOT NULL AUTO_INCREMENT,
  `AcceptId` int(11) DEFAULT NULL,
  `DayRootId` int(11) DEFAULT NULL,
  `BookId` int(11) DEFAULT '0',
  `WorkUserId` int(11) DEFAULT '0',
  `AppDate` date DEFAULT NULL,
  `FromTime` varchar(4) DEFAULT NULL,
  `ToTime` varchar(4) DEFAULT NULL,
  `FreeTime` int(11) DEFAULT '0',
  `DisPlayIndex` int(11) DEFAULT NULL,
  `DisPlayEndIndex` int(11) DEFAULT NULL,
  `DisPlayLineSpan` varchar(50) DEFAULT NULL,
  `MemberCnt` int(11) DEFAULT '0',
  `CarType` int(1) DEFAULT '0',
  `AppIntentionId` int(3) DEFAULT '0',
  `AppResutId` int(3) DEFAULT '0',
  `Sales` decimal(10,0) DEFAULT NULL,
  `CardSales` decimal(10,0) DEFAULT NULL,
  `FirstMenoy` decimal(10,0) DEFAULT NULL,
  `LeavMenoy` decimal(10,0) DEFAULT NULL,
  `LeavMenoyDate` date DEFAULT NULL,
  `Comment` text,
  `Comment2` text,
  `Comment3` text,
  `ReportUser` text,
  `OverHour` varchar(2) DEFAULT NULL,
  `OverMinute` varchar(2) DEFAULT NULL,
  `Status` int(1) DEFAULT '0',
  `HelpAppId` int(11) DEFAULT '0',
  `ConfirmUserId` int(11) DEFAULT NULL,
  `ParentAppId` int(11) DEFAULT '0',
  `ChildAppId` int(11) DEFAULT '0',
  `ParentPlanDate` date DEFAULT NULL,
  `ChildPlanDate` date DEFAULT NULL,
  `Yobi1` int(11) DEFAULT '0',
  `Yobi2` int(11) DEFAULT '0',
  `Yobi3` int(11) DEFAULT '0',
  `Yobi4` int(11) DEFAULT '0',
  `Yobi5` int(11) DEFAULT '0',
  `Yobi6` varchar(50) DEFAULT NULL,
  `Yobi7` varchar(50) DEFAULT NULL,
  `Yobi8` varchar(50) DEFAULT NULL,
  `Yobi9` varchar(50) DEFAULT NULL,
  `Yobi10` varchar(50) DEFAULT NULL,
  `Yobi11` date DEFAULT NULL,
  `Yobi12` date DEFAULT NULL,
  `Yobi13` datetime DEFAULT NULL,
  `InsertDate` datetime NOT NULL,
  `SakuseiSyaId` int(11) NOT NULL,
  `UpdateDate` datetime NOT NULL,
  `UpdateUserId` int(11) NOT NULL,
  PRIMARY KEY (`AppId`),
  KEY `AcceptId` (`AcceptId`), -- index
  KEY `DayRootId` (`DayRootId`),--index
  KEY `AppDate` (`AppDate`),--index
  KEY `WorkUserId` (`WorkUserId`),
  KEY `BookId` (`BookId`)
) ENGINE=InnoDB AUTO_INCREMENT=84191 DEFAULT CHARSET=utf8;