CREATE TABLE `Contact` (
  `Customer` char(10) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `IEType` char(10) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `Contact` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `Department` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Title` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TelNo` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `FaxNo` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CellNo` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `EMail` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Note` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`Customer`,`IEType`,`Contact`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
