建表语句如下
CREATE TABLE `mdm_xd_user` (
`systemno` varchar(100) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`bus_staffid` varchar(100) DEFAULT NULL,
`bus_depid` varchar(100) DEFAULT NULL,
`usercode` varchar(100) DEFAULT NULL,
`ismajor` tinyint(2) DEFAULT NULL,
`subusercode` varchar(100) DEFAULT NULL,
`infoval` int(11) DEFAULT NULL,
`isused` tinyint(2) DEFAULT NULL,
`idx` int(11) DEFAULT NULL,
`pk_mdm` varchar(64) NOT NULL,
`pkmdm_flow` varchar(64) DEFAULT NULL,
`mdm_code` varchar(50) DEFAULT NULL,
`mdm_parentcode` varchar(50) DEFAULT NULL,
`treeref_foreignkey` varchar(64) DEFAULT NULL,
`treemasterid` varchar(64) DEFAULT NULL,
`treeparentid` varchar(64) DEFAULT NULL,
`link_fieldvalue` varchar(64) DEFAULT NULL,
`mdm_duplicate` int(11) DEFAULT '0',
`mdm_datastatus` int(11) DEFAULT '0',
`mdm_workflow_status` int(11) DEFAULT '0',
`mdm_cleanstatus` varchar(50) DEFAULT 'WAITING',
`mdm_version` int(11) DEFAULT '0',
`creator` varchar(64) DEFAULT NULL,
`createtime` varchar(50) DEFAULT NULL,
`modifier` varchar(64) DEFAULT NULL,
`modifytime` varchar(50) DEFAULT NULL,
`ts` varchar(50) DEFAULT NULL,
`dr` int(11) DEFAULT '0',
`position` varchar(100) DEFAULT NULL,
`positionLevel` varchar(100) DEFAULT NULL,
PRIMARY KEY (`pk_mdm`),
UNIQUE KEY `mdm_xd_user_m_c` (`mdm_code`),
KEY `index_mdm_xd_user_m_c` (`mdm_parentcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8