CREATE TABLE  `obss`.`csi` (
  `csiid` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID of CSI item',
  `client` int(11) NOT NULL DEFAULT '0' COMMENT 'client id if >0',
  `firstName` varchar(20) DEFAULT '',
  `middleInitial` char(1) DEFAULT '',
  `lastName` varchar(20) DEFAULT '',
  `fundingsource` varchar(10) NOT NULL DEFAULT 'UNKNOWN' COMMENT 'Funding source',
  `prime` varchar(8) DEFAULT '',
  `provider` varchar(20) NOT NULL DEFAULT '' COMMENT 'provider if available',
  `mode` varchar(12) NOT NULL,
  `title` varchar(100) NOT NULL COMMENT 'Title of the csi',
  `status` char(1) NOT NULL DEFAULT 'O' COMMENT 'status of this CSI',
  `servicedate` varchar(8) NOT NULL DEFAULT '' COMMENT 'Date of the service',
  `priority` char(1) NOT NULL DEFAULT 'N' COMMENT 'priority of csi',
  `trip` int(11) DEFAULT NULL COMMENT 'trip if >0',
  `driver` varchar(45) DEFAULT '' COMMENT 'Driver name',
  `vehicle` varchar(45) DEFAULT '' COMMENT 'vehicle',
  `relatedCsi` int(11) DEFAULT NULL COMMENT 'related csi',
  `reportdate` varchar(8) DEFAULT NULL COMMENT 'Report date',
  `creator` varchar(30) DEFAULT NULL COMMENT 'Creator',
  PRIMARY KEY (`csiid`),
  KEY `I2` (`client`),
  KEY `I3` (`status`),
  KEY `I4` (`servicedate`),
  KEY `I6` (`fundingsource`),
  KEY `fk_csi_csistatus1` (`status`),
  KEY `I_creator` (`creator`),
  KEY `I_providerMode` (`provider`,`mode`),
  KEY `I_reportDate` (`reportdate`),
  CONSTRAINT `fk_csi_csistatus1` FOREIGN KEY (`status`) REFERENCES `csistatus` (`status`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=201000253 DEFAULT CHARSET=latin1 COMMENT='Holds CSI information';