CREATE TABLE `t1_client_master` (
  `T1CI_Row_ID` int unsigned NOT NULL,
  `T1CI_CLIENT_ID` varchar(18) DEFAULT NULL,
  `T1CI_Sin_Number` int DEFAULT NULL,
  `T1CI_Title_FKC` varchar(20) DEFAULT NULL,
  `T1CI_Name_First` varchar(150) DEFAULT NULL,
  `T1CI_Name_Last` varchar(160) DEFAULT NULL,
  `T1CI_DOB` date DEFAULT NULL,
  `T1CI_ADDR_STREET` varchar(100) DEFAULT NULL,
  `T1CI_ADDR_LOCALITY` varchar(100) DEFAULT NULL,
  `T1CI_ADDR_CITY` varchar(100) DEFAULT NULL,
  `T1CI_ADDR_PROVINCE` varchar(100) DEFAULT NULL,
  `T1CI_ADDR_COUNTRY` varchar(100) DEFAULT NULL,
  `T1CI_ADDR_POSTALCODE` varchar(20) DEFAULT NULL,
  `T1CI_PHONE_HOME` bigint DEFAULT '0',
  `T1CI_PHONE_CELL` int DEFAULT '0',
  `T1CI_EMAIL` varchar(150) DEFAULT NULL,
  `T1CI_DATE_UPDATED` datetime DEFAULT NULL,
  `TICI_DATA_CHANGE_COUNT` int DEFAULT '0',
  PRIMARY KEY (`T1CI_Row_ID`),
  UNIQUE KEY `UK_t1_baseinfo_T1BI_Row_ID` (`T1CI_Row_ID`),
  UNIQUE KEY `T1CI_CLIENT_ID` (`T1CI_CLIENT_ID`),
  KEY `FK_t1_baseinfo_T1BI_Title` (`T1CI_Title_FKC`),
  CONSTRAINT `FK_t1_baseinfo_T1BI_Title` FOREIGN KEY (`T1CI_Title_FKC`) REFERENCES `lkp_title` (`LKP_Title`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='T1CI_ :Contains Basic Information Provided at signup. Short T1BI';