`tid` varchar(16) NOT NULL,
  `lastmod` char(16) NOT NULL,
  `editable` char(1) NOT NULL DEFAULT '1',
  `title` varchar(128) NOT NULL,
  `city` varchar(64) DEFAULT NULL,
  `oType` varchar(32) DEFAULT NULL,
  `protectron` varchar(16) DEFAULT NULL,
  `jobNo` varchar(32) DEFAULT NULL,
  `startDate` varchar(64) NOT NULL, (Unix time stamp)
  `endDate` varchar(64) DEFAULT NULL, (Unix time stamp)
  `color` varchar(32) DEFAULT NULL,
  `empNo` varchar(255) DEFAULT NULL,