m-00kie

schedules |CREATE TABLE `schedules` (  `ID` int(8) unsigned NOT NULL auto_increment,  `START_DATE` datetime NOT NULL default '0000-00-00 00:00:00',  `END_DATE` datetime NOT NULL default '0000-00-00 00:00:00',  `IS_RECURRING` smallint(1) unsigned NOT NULL default '0',  `Mo` smallint(1) NOT NULL default '0',  `Tu` smallint(1) unsigned NOT NULL default '0',  `We` smallint(1) unsigned NOT NULL default '0',  `Th` smallint(1) unsigned NOT NULL default '0',  `Fr` smallint(1) unsigned NOT NULL default '0',  `Sa` smallint(1) unsigned NOT NULL default '0',  `Su` smallint(1) unsigned NOT NULL default '0',  `DRESS_CODE` varchar(255) NOT NULL default '0',  `SERVICE_CATEGORY` varchar(255) default '0' COMMENT 'Service Category - Business, Conf, Edu, Med',  `SERVICE_TYPE` int(8) NOT NULL default '0' COMMENT 'Terp, Cart, etc',  `TITLE` varchar(255) NOT NULL default '',  `LOCATION` int(8) NOT NULL default '0',  `LINKID` varchar(50) NOT NULL default '',  `PARTICIPATORS` text,  `COMMENTS` text,  `DATE` datetime default NULL,  `CREATEDBY` int(8) NOT NULL default '0',  `FULL` int(2) NOT NULL default '0',  `NTERPS` int(3) NOT NULL default '0',  `AUDIENCE_SIZE` varchar(50) NOT NULL default '0',  `ATTACHMENTS` varchar(255) default NULL,  `JOBID` varchar(255) default NULL,  `INVOICEID` int(11) NOT NULL default '0',  `INVOICEDATE` datetime default NULL,  `PRAC_NEEDED` int(2) NOT NULL default '2',  `FLAG` int(2) NOT NULL default '0' COMMENT '0: norm, 1:late 2: unfilled 3: timely',  `DIFFERENTIAL` varchar(6) NOT NULL default '0.00',  `MODIFIED` int(11) default NULL,  `MODIFIEDBY` int(11) NOT NULL default '0',  `F_MILEAGE` varchar(6) NOT NULL default '0.00',  `F_PARKING` varchar(6) NOT NULL default '0.00',  `F_AIRFARE` varchar(6) NOT NULL default '0.00',  `F_DIFFERENTIAL` varchar(6) NOT NULL default '0.00',  `F_MISC` varchar(6) NOT NULL default '0.00',  `C_MILEAGE` tinyint(1) NOT NULL default '0',  `C_AIRFARE` tinyint(1) NOT NULL default '0',  `C_PARKING` tinyint(1) NOT NULL default '0',  `C_MISC` tinyint(1) NOT NULL default '0',  `MILEAGE_RATE` varchar(255) NOT NULL default '.3650',  PRIMARY KEY  (`SERVICE_TYPE`,`CREATEDBY`,`LINKID`,`LOCATION`,`MODIFIEDBY`,`ID`,`START_DATE`,`END_DATE`),  UNIQUE KEY `ID` (`ID`),  KEY `s_idx` (`START_DATE`),  KEY `e_idx` (`END_DATE`),  KEY `sv_idx` (`SERVICE_TYPE`),  KEY `l_idx` (`LOCATION`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='holds scheduling information; InnoDB free: 493568 kB'