CREATE  TABLE IF NOT EXISTS `obss`.`csi` (
  `csiid` INT(11) NOT NULL AUTO_INCREMENT COMMENT '\'ID of CSI ite' ,
  `client` INT(11) NOT NULL DEFAULT '0' COMMENT '\'client id if >' ,
  `firstName` VARCHAR(20) NULL DEFAULT '' ,
  `middleInitial` CHAR(1) NULL DEFAULT '' ,
  `lastName` VARCHAR(20) NULL DEFAULT '' ,
  `fundingsource` VARCHAR(10) NOT NULL DEFAULT 'UNKNOWN' COMMENT '\'Funding sourc' ,
  `prime` VARCHAR(8) NULL DEFAULT '' ,
  `provider` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '\'provider if availabl' ,
  `mode` VARCHAR(12) NOT NULL ,
  `title` VARCHAR(100) NOT NULL COMMENT '\'Title of the cs' ,
  `status` CHAR(1) NOT NULL DEFAULT 'O' COMMENT '\'status of this CS' ,
  `servicedate` VARCHAR(8) NOT NULL DEFAULT '' COMMENT '\'Date of the servic' ,
  `priority` CHAR(1) NOT NULL DEFAULT 'N' COMMENT '\'priority of cs' ,
  `trip` INT(11) NULL DEFAULT NULL COMMENT '\'trip if >' ,
  `driver` VARCHAR(45) NULL DEFAULT '' COMMENT '\'Driver nam' ,
  `vehicle` VARCHAR(45) NULL DEFAULT '' COMMENT '\'vehicl' ,
  `relatedCsi` INT(11) NULL DEFAULT NULL COMMENT '\'related cs' ,
  `reportdate` VARCHAR(8) NULL DEFAULT NULL COMMENT '\'Report dat' ,
  `creator` VARCHAR(30) NULL DEFAULT NULL COMMENT '\'Creato' ,
  PRIMARY KEY (`csiid`) ,
  INDEX `I2` (`client` ASC) ,
  INDEX `I3` (`status` ASC) ,
  INDEX `I4` (`servicedate` ASC) ,
  INDEX `I6` (`fundingsource` ASC) ,
  INDEX `fk_csi_csistatus1` (`status` ASC) ,
  INDEX `I_creator` (`creator` ASC) ,
  INDEX `I_providerMode` (`provider` ASC, `mode` ASC) ,
  INDEX `I_reportDate` (`reportdate` ASC) ,
  CONSTRAINT `fk_csi_csistatus1`
    FOREIGN KEY (`status` )
    REFERENCES `obss`.`csistatus` (`status` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
AUTO_INCREMENT = 201000253
DEFAULT CHARACTER SET = latin1
COLLATE = latin1_swedish_ci
COMMENT = '\'Holds CSI informatio'