

DROP TABLE IF EXISTS `T_KYC`;
CREATE TABLE `T_KYC` (
  `UUID` varchar(32) NOT NULL,
  `PARTY_ID` varchar(32) NOT NULL,
  `IDNUMBER` varchar(128) DEFAULT NULL,
  `IDNAME` varchar(256) DEFAULT NULL,
  `NAME` varchar(128) DEFAULT NULL,
  `IDIMG_1` varchar(64) DEFAULT NULL,
  `IDIMG_2` varchar(64) DEFAULT NULL,
  `STATUS` int(11) DEFAULT NULL,
  `MSG` varchar(256) DEFAULT NULL,
  `NATIONALITY` varchar(64) DEFAULT NULL,
  `APPLY_TIME` datetime DEFAULT NULL,
  PRIMARY KEY (`UUID`),
  KEY `INDEX_KYC_PARTY_ID` (`PARTY_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

create index INDEX_KYC_PARTY_ID on T_KYC (
   PARTY_ID
);



CREATE TABLE `T_KYC_HIGH_LEVEL` (
  `UUID` varchar(32) NOT NULL DEFAULT '',
  `PARTY_ID` varchar(32) DEFAULT NULL,
  `WORK_PLACE` varchar(256) DEFAULT NULL,
  `HOME_PLACE` varchar(256) DEFAULT NULL,
  `RELATIVES_RELATION` varchar(32) DEFAULT NULL,
  `RELATIVES_NAME` varchar(32) DEFAULT NULL,
  `RELATIVES_PLACE` varchar(256) DEFAULT NULL,
  `RELATIVES_PHONE` varchar(32) DEFAULT NULL,
  `APPLY_TIME` datetime DEFAULT NULL,
  `STATUS` int(11) DEFAULT NULL,
  `MSG` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`UUID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

create index INDEX_KYC_PARTY_ID on T_KYC_HIGH_LEVEL (
   PARTY_ID
);

ALTER TABLE SCT_USER ADD `REMARKS` longtext ;