IRIS_COLLECT/IOM_cs/bin/Release/sqlite/data/数据库初始化脚本.txt at eddcec5d673015bb34c3df2b1f8e02ceedf5a69a

Fork: 0
codedev / IRIS_COLLECT
Find file
Newer
Older
IRIS_COLLECT / IOM_cs / bin / Release / sqlite / data / 数据库初始化脚本.txt
yangqianqian on 29 Dec 2020 22 KB first
Raw Blame History

CREATE TABLE `iris_data` (
  `IR_ID` bigint(20) NOT NULL,
  `S_ID` bigint(20) DEFAULT NULL,
  `IRIS_L` varbinary(1024) DEFAULT NULL,
  `IRIS_R` varbinary(1024) DEFAULT NULL,
  `PATH_VIDEO` varchar(100) DEFAULT NULL,
  `IMAGE_L1` varchar(256) DEFAULT NULL,
  `IMAGE_L2` varchar(256) DEFAULT NULL,
  `IMAGE_R1` varchar(256) DEFAULT NULL,
  `IMAGE_R2` varchar(256) DEFAULT NULL,
  `IMAGE_L1_DATA` longtext COMMENT,
  `IMAGE_R1_DATA` longtext COMMENT
)


CREATE TABLE `iris_data_coll` (
  `IR_ID` bigint(20) NOT NULL,
  `S_ID` bigint(20) DEFAULT NULL,
  `TEL1` varchar(20) DEFAULT NULL,
  `TEL2` varchar(20) DEFAULT NULL,
  `DEV_TYPE` varchar(50) DEFAULT NULL,
  `COLL_TIME` datetime DEFAULT NULL,
  `DEV_CODE` varchar(30) DEFAULT NULL,
  `DEV_FIRM` varchar(100) DEFAULT NULL,
  `FLG_CER` char(1) DEFAULT NULL,
  `COLL_NUM` varchar(50) DEFAULT NULL,
  `FLG_WO` char(1) DEFAULT NULL,
  `ST_ID` bigint(20) DEFAULT NULL,
  `COLL_NAME` varchar(50) DEFAULT NULL,
  `COLL_ID` bigint(20) DEFAULT NULL,
  `COLL_REASON` char(3) DEFAULT NULL,
  `Q_L` decimal(4,2) DEFAULT NULL,
  `Q_R` decimal(4,2) DEFAULT NULL,
  `REASON_COLL_DESC` varchar(500) DEFAULT NULL,
  `PATH_CER` varchar(100) DEFAULT NULL,
  `COLL_TYPE` char(1) DEFAULT NULL,
  `DEF_REASON` varchar(100) DEFAULT NULL,
  `DEF_TYPE` char(1) DEFAULT NULL,
  `IS_CER` char(1) DEFAULT NULL,
  `FLG_FORCE` char(1) DEFAULT NULL,
  `FLG_SYNC` char(1) DEFAULT NULL,
  `FLG_UPLOAD` char(1) DEFAULT '0',
  `UPLOAD_USER` bigint(20) DEFAULT NULL,
  `UPLOAD_TIME` datetime DEFAULT NULL,
  `RES_UPLOAD` char(1) DEFAULT NULL,
  `COLL_STATE` char(1) DEFAULT NULL,
  `COLL_WAY` char(1) DEFAULT NULL,
  `FLG_FOCUS` char(1) DEFAULT NULL,
  `FAIL_REASON` char(3) DEFAULT NULL,
  `ST_X` varchar(20) DEFAULT NULL,
  `ST_Y` varchar(20) DEFAULT NULL,
  `PHOTO` varchar(255) DEFAULT NULL,
  `COLL_SPEND` varchar(20) DEFAULT NULL,
  `FLG_DEL` char(1) DEFAULT '0',
  `IMAGE_L1` varchar(255) DEFAULT NULL,
  `IMAGE_L2` varchar(255) DEFAULT NULL,
  `IMAGE_R1` varchar(255) DEFAULT NULL,
  `IMAGE_R2` varchar(255) DEFAULT NULL,
  `COLL_PLACE` varchar(50) DEFAULT NULL,
  `FOCUS_END_DATE` date DEFAULT NULL,
  `FOCUS_REMARKS` varchar(255) DEFAULT NULL,
  `ST_NAME` varchar(255) DEFAULT NULL,
  `ST_TYPE` varchar(50) DEFAULT NULL,
  `FLG_FORCE_PERSON` char(1) DEFAULT NULL
)


CREATE TABLE `sys_dict` (
  `ID` INT PRIMARY KEY     NOT NULL,
  `NUM` int(11) DEFAULT NULL,
  `PID` bigint(32) DEFAULT NULL,
  `NAME` varchar(255) DEFAULT NULL,
  `TIPS` varchar(255) DEFAULT NULL,
  `CODE` varchar(64) DEFAULT NULL
)


INSERT INTO `sys_dict` VALUES ('29', '0', '0', '性别', null, 'sysSex');
INSERT INTO `sys_dict` VALUES ('30', '1', '29', '男', null, '1');
INSERT INTO `sys_dict` VALUES ('31', '2', '29', '女', null, '2');
INSERT INTO `sys_dict` VALUES ('35', '0', '0', '账号状态', null, 'accountStatus');
INSERT INTO `sys_dict` VALUES ('36', '1', '35', '启用', null, '1');
INSERT INTO `sys_dict` VALUES ('37', '2', '35', '已冻结', null, '2');
INSERT INTO `sys_dict` VALUES ('38', '3', '35', '已删除', null, '3');
INSERT INTO `sys_dict` VALUES ('43', '0', '0', '在线状态', null, 'onlineStatus');
INSERT INTO `sys_dict` VALUES ('44', '0', '43', '离线', null, '0');
INSERT INTO `sys_dict` VALUES ('45', '1', '43', '在线', null, '1');
INSERT INTO `sys_dict` VALUES ('51', '0', '0', '布防状态', null, 'bfzt');
INSERT INTO `sys_dict` VALUES ('52', '0', '51', '撤防', null, '0');
INSERT INTO `sys_dict` VALUES ('53', '1', '51', '布防', null, '1');
INSERT INTO `sys_dict` VALUES ('54', '0', '0', '资源类型', null, 'resourceType');
INSERT INTO `sys_dict` VALUES ('55', '0', '54', '菜单', null, '03');
INSERT INTO `sys_dict` VALUES ('56', '1', '54', '按钮', '按钮即操作权限', '04');
INSERT INTO `sys_dict` VALUES ('57', '0', '0', '日志类型', null, 'logType');
INSERT INTO `sys_dict` VALUES ('58', '0', '57', '业务日志', null, '0');
INSERT INTO `sys_dict` VALUES ('59', '1', '57', '异常日志', null, '1');
INSERT INTO `sys_dict` VALUES ('75', '0', '0', '组织类型', '组织类型', 'deptType');
INSERT INTO `sys_dict` VALUES ('76', '1', '75', '公司', null, '03');
INSERT INTO `sys_dict` VALUES ('77', '2', '75', '组/部门', null, '04');
INSERT INTO `sys_dict` VALUES ('88', '0', '0', '数据权限类型', null, 'dataScopeType');
INSERT INTO `sys_dict` VALUES ('89', '0', '88', '所有数据', null, '1');
INSERT INTO `sys_dict` VALUES ('90', '0', '88', '所属及下级部门', null, '2');
INSERT INTO `sys_dict` VALUES ('91', '0', '88', '本部门', null, '3');
INSERT INTO `sys_dict` VALUES ('92', '0', '88', '自定义', null, '4');
INSERT INTO `sys_dict` VALUES ('93', '0', '0', '区域类型', null, 'levelType');
INSERT INTO `sys_dict` VALUES ('94', '0', '93', '省级', null, '1');
INSERT INTO `sys_dict` VALUES ('95', '0', '93', '市级', null, '2');
INSERT INTO `sys_dict` VALUES ('96', '0', '93', '区级', null, '3');
INSERT INTO `sys_dict` VALUES ('97', '0', '93', '街道', null, '4');
INSERT INTO `sys_dict` VALUES ('98', '0', '93', '社区', null, '5');
INSERT INTO `sys_dict` VALUES ('99', '0', '93', '网格', null, '6');
INSERT INTO `sys_dict` VALUES ('100', '0', '93', '责任网格', null, '7');
INSERT INTO `sys_dict` VALUES ('104', '0', '0', '开门状态', '开门状态', 'openStatus');
INSERT INTO `sys_dict` VALUES ('105', '1', '104', '常开', null, '1');
INSERT INTO `sys_dict` VALUES ('106', '2', '104', '常闭', null, '0');
INSERT INTO `sys_dict` VALUES ('107', '0', '0', '策略类型', '策略类型', 'strategyType');
INSERT INTO `sys_dict` VALUES ('108', '1', '107', '日期', null, '1');
INSERT INTO `sys_dict` VALUES ('109', '2', '107', '星期', null, '2');
INSERT INTO `sys_dict` VALUES ('110', '3', '107', '当天', null, '3');
INSERT INTO `sys_dict` VALUES ('111', '0', '0', '星期', null, 'week');
INSERT INTO `sys_dict` VALUES ('112', '1', '111', '星期一', null, '1');
INSERT INTO `sys_dict` VALUES ('113', '2', '111', '星期二', null, '2');
INSERT INTO `sys_dict` VALUES ('114', '3', '111', '星期三', null, '3');
INSERT INTO `sys_dict` VALUES ('115', '4', '111', '星期四', null, '4');
INSERT INTO `sys_dict` VALUES ('116', '5', '111', '星期五', null, '5');
INSERT INTO `sys_dict` VALUES ('117', '6', '111', '星期六', null, '6');
INSERT INTO `sys_dict` VALUES ('118', '7', '111', '星期日', null, '7');
INSERT INTO `sys_dict` VALUES ('119', '0', '0', '策略周期', '策略周期', 'strategyPeriod');
INSERT INTO `sys_dict` VALUES ('120', '1', '119', '永久', null, '1');
INSERT INTO `sys_dict` VALUES ('121', '2', '119', '当次', null, '2');
INSERT INTO `sys_dict` VALUES ('126', '0', '0', '业务类型', '业务类型', 'businessType');
INSERT INTO `sys_dict` VALUES ('127', '1', '126', '门禁', null, '1');
INSERT INTO `sys_dict` VALUES ('128', '2', '126', '考勤', null, '2');
INSERT INTO `sys_dict` VALUES ('129', '3', '126', '识别', null, '3');
INSERT INTO `sys_dict` VALUES ('130', '3', '104', '正常', null, '2');
INSERT INTO `sys_dict` VALUES ('1204221133607391233', '0', '0', '进出类型', '进出类型', 'inoutType');
INSERT INTO `sys_dict` VALUES ('1204221133628362754', '1', '1204221133607391233', '进门', null, '1');
INSERT INTO `sys_dict` VALUES ('1204221133649334273', '2', '1204221133607391233', '出门', null, '0');
INSERT INTO `sys_dict` VALUES ('1207260271883284481', '0', '0', '状态', '', 'sysStatus');
INSERT INTO `sys_dict` VALUES ('1207260271883284482', '1', '1207260271883284481', '启用', null, '1');
INSERT INTO `sys_dict` VALUES ('1207260271883284483', '2', '1207260271883284481', '禁用', null, '2');
INSERT INTO `sys_dict` VALUES ('1209029411679645697', '0', '0', '职务类型', '', 'collectReason');
INSERT INTO `sys_dict` VALUES ('1209029411713200129', '0', '1209029411679645697', '自由职业', null, '0');
INSERT INTO `sys_dict` VALUES ('1209029411746754562', '0', '1209029411679645697', '顾问', null, '1');
INSERT INTO `sys_dict` VALUES ('1209029411792891906', '0', '1209029411679645697', '法务', null, '2');
INSERT INTO `sys_dict` VALUES ('1215101956866875393', '0', '0', '采集状态类型', '', 'collectState');
INSERT INTO `sys_dict` VALUES ('1215101957206614017', '1', '1215101956866875393', '未采集', null, '1');
INSERT INTO `sys_dict` VALUES ('1215101957470855170', '2', '1215101956866875393', '采集成功', null, '2');
INSERT INTO `sys_dict` VALUES ('1215101957806399490', '3', '1215101956866875393', '采集失败', null, '3');
INSERT INTO `sys_dict` VALUES ('1215108789237096450', '0', '0', '人员类型', '人员类型', 'personType');
INSERT INTO `sys_dict` VALUES ('1215108789451005953', '1', '1215108789237096450', '办理护照人员', null, '001');
INSERT INTO `sys_dict` VALUES ('1215108789757190146', '2', '1215108789237096450', '行政处罚人员', null, '002');
INSERT INTO `sys_dict` VALUES ('1215108790088540161', '0', '1215108789237096450', '刑事处罚人员', null, '003');
INSERT INTO `sys_dict` VALUES ('1215108790323421185', '0', '1215108789237096450', '被传唤人员', null, '004');
INSERT INTO `sys_dict` VALUES ('1215108790579273730', '0', '1215108789237096450', '留置盘查', null, '005');
INSERT INTO `sys_dict` VALUES ('1215108790826737665', '0', '1215108789237096450', '重点人口', null, '006');
INSERT INTO `sys_dict` VALUES ('1215108791174864898', '0', '1215108789237096450', '设稳重点人员', null, '007');
INSERT INTO `sys_dict` VALUES ('1215108791413940225', '0', '1215108789237096450', '特殊群体', null, '008');
INSERT INTO `sys_dict` VALUES ('1215108791921451010', '0', '1215108789237096450', '处理违章人员', null, '009');
INSERT INTO `sys_dict` VALUES ('1215108792282161154', '0', '1215108789237096450', '三非人员', null, '010');
INSERT INTO `sys_dict` VALUES ('1215108792672231425', '0', '1215108789237096450', '限制出入境人员', null, '011');
INSERT INTO `sys_dict` VALUES ('1215108793053913089', '0', '1215108789237096450', '涉恐人员', null, '012');
INSERT INTO `sys_dict` VALUES ('1215108793347514370', '0', '1215108789237096450', '涉隐人员', null, '013');
INSERT INTO `sys_dict` VALUES ('1215108793683058689', '0', '1215108789237096450', '在逃人员', null, '014');
INSERT INTO `sys_dict` VALUES ('1215108793930522625', '0', '1215108789237096450', '涉毒人员', null, '015');
INSERT INTO `sys_dict` VALUES ('1215108794261872641', '0', '1215108789237096450', '刑事犯罪前科人员', null, '016');
INSERT INTO `sys_dict` VALUES ('1215108794513530882', '0', '1215108789237096450', '肇事肇祸精神病人', null, '017');
INSERT INTO `sys_dict` VALUES ('1215108794769383426', '0', '1215108789237096450', '重点上访人员', null, '018');
INSERT INTO `sys_dict` VALUES ('1215108795021041665', '0', '1215108789237096450', '违法犯罪人员', null, '019');
INSERT INTO `sys_dict` VALUES ('1215108795314642945', '0', '1215108789237096450', '工作对象', null, '020');
INSERT INTO `sys_dict` VALUES ('1215108795612438530', '0', '1215108789237096450', '刑嫌人员', null, '021');
INSERT INTO `sys_dict` VALUES ('1215108795864096770', '0', '1215108789237096450', '安保人员', null, '022');
INSERT INTO `sys_dict` VALUES ('1215108796191252482', '0', '1215108789237096450', '监管对象', null, '023');
INSERT INTO `sys_dict` VALUES ('1215108796493242370', '0', '1215108789237096450', '被摸底排查人员', null, '024');
INSERT INTO `sys_dict` VALUES ('1215108796786843650', '0', '1215108789237096450', '侦查经营工作对象', null, '025');
INSERT INTO `sys_dict` VALUES ('1215108797080444929', '0', '1215108789237096450', '违法犯罪嫌疑人', null, '026');
INSERT INTO `sys_dict` VALUES ('1215108797290160130', '0', '1215108789237096450', '被剥夺政治权利的罪犯', null, '027');
INSERT INTO `sys_dict` VALUES ('1215108797541818369', '0', '1215108789237096450', '特定地区工作对象', null, '028');
INSERT INTO `sys_dict` VALUES ('1215108797877362689', '0', '1215108789237096450', '自愿采集人员', null, '301');
INSERT INTO `sys_dict` VALUES ('1215108798208712706', '0', '1215108789237096450', '通行人员', null, '302');
INSERT INTO `sys_dict` VALUES ('1215108798544257026', '0', '1215108789237096450', '普通人员', null, '303');
INSERT INTO `sys_dict` VALUES ('1215108798800109570', '0', '1215108789237096450', '其他人员', null, '900');
INSERT INTO `sys_dict` VALUES ('1215112650941177857', '0', '0', '证件类型', '', 'cardType');
INSERT INTO `sys_dict` VALUES ('1215112651230584834', '1', '1215112650941177857', '身份证', null, '111');
INSERT INTO `sys_dict` VALUES ('1215112651566129153', '2', '1215112650941177857', '临时居民身份证', null, '112');
INSERT INTO `sys_dict` VALUES ('1215112651901673474', '3', '1215112650941177857', '户口簿', null, '113');
INSERT INTO `sys_dict` VALUES ('1215112652266577921', '4', '1215112650941177857', '军官证', null, '114');
INSERT INTO `sys_dict` VALUES ('1215112652618899457', '5', '1215112650941177857', '警官证', null, '123');
INSERT INTO `sys_dict` VALUES ('1215112652908306433', '0', '1215112650941177857', '学生证', null, '133');
INSERT INTO `sys_dict` VALUES ('1215112653289988098', '0', '1215112650941177857', '外交护照', null, '411');
INSERT INTO `sys_dict` VALUES ('1215112653495508993', '0', '1215112650941177857', '公务护照', null, '412');
INSERT INTO `sys_dict` VALUES ('1215112653831053314', '0', '1215112650941177857', '因公普通护照', null, '413');
INSERT INTO `sys_dict` VALUES ('1215112654082711554', '0', '1215112650941177857', '普通护照', null, '414');
INSERT INTO `sys_dict` VALUES ('1215112654334369793', '0', '1215112650941177857', '出入境通行证', null, '416');
INSERT INTO `sys_dict` VALUES ('1215112654732828673', '0', '1215112650941177857', '外国人出入境证', null, '417');
INSERT INTO `sys_dict` VALUES ('1215112655005458434', '0', '1215112650941177857', '其他', null, '990');
INSERT INTO `sys_dict` VALUES ('1215112655345197057', '0', '1215112650941177857', '军人证', null, '991');
INSERT INTO `sys_dict` VALUES ('1215112655588466690', '0', '1215112650941177857', '港澳台居住证', null, '992');
INSERT INTO `sys_dict` VALUES ('1215112655924011009', '0', '1215112650941177857', '外国人居住证', null, '993');
INSERT INTO `sys_dict` VALUES ('1215112656179863553', '0', '1215112650941177857', '越南身份证', null, '994');
INSERT INTO `sys_dict` VALUES ('1215112656427327490', '0', '1215112650941177857', '边民证', null, '995');
INSERT INTO `sys_dict` VALUES ('1215112656762871810', '0', '1215112650941177857', '无证件', null, '999');
INSERT INTO `sys_dict` VALUES ('1216619240494018562', '0', '0', '采集失败原因', '', 'failReason');
INSERT INTO `sys_dict` VALUES ('1216619240494018563', '0', '1216619240494018562', '人员已注册', null, '001');
INSERT INTO `sys_dict` VALUES ('1216619240561127426', '1', '1216619240494018562', '该人使用证件前后不一致', null, '002');
INSERT INTO `sys_dict` VALUES ('1216619240561127427', '2', '1216619240494018562', '证件已存在，虹膜不一致', null, '003');
INSERT INTO `sys_dict` VALUES ('1216619240561127428', '3', '1216619240494018562', '无法采集', null, '004');
INSERT INTO `sys_dict` VALUES ('1218087937570099202', '0', '0', '采集报警原因', '', 'collAlarmReason');
INSERT INTO `sys_dict` VALUES ('1218087937570099203', '0', '1218087937570099202', '一人多证', null, '002');
INSERT INTO `sys_dict` VALUES ('1218087937637208065', '0', '1218087937570099202', '一证多人', null, '003');
INSERT INTO `sys_dict` VALUES ('1218095072475467778', '0', '0', '识别报警原因', '', 'recAlarmReason');
INSERT INTO `sys_dict` VALUES ('1218095072475467779', '1', '1218095072475467778', '专题库', null, '1');
INSERT INTO `sys_dict` VALUES ('1218095072538382337', '2', '1218095072475467778', '人证核验不一致', null, '2');
INSERT INTO `sys_dict` VALUES ('1218704949837156353', '0', '0', '民族', '', 'nationType');
INSERT INTO `sys_dict` VALUES ('1218704949837156354', '0', '1218704949837156353', '汉族', null, '01');
INSERT INTO `sys_dict` VALUES ('1218704949837156355', '1', '1218704949837156353', '蒙古族', null, '02');
INSERT INTO `sys_dict` VALUES ('1218704949900070914', '0', '1218704949837156353', '回族', null, '03');
INSERT INTO `sys_dict` VALUES ('1218704949900070915', '0', '1218704949837156353', '藏族', null, '04');
INSERT INTO `sys_dict` VALUES ('1218704949900070916', '0', '1218704949837156353', '维吾尔族', null, '05');
INSERT INTO `sys_dict` VALUES ('1218704949900070917', '0', '1218704949837156353', '苗族', null, '06');
INSERT INTO `sys_dict` VALUES ('1218704949900070918', '0', '1218704949837156353', '彝族', null, '07');
INSERT INTO `sys_dict` VALUES ('1218704949967179778', '0', '1218704949837156353', '壮族', null, '08');
INSERT INTO `sys_dict` VALUES ('1218704949967179779', '0', '1218704949837156353', '布依族', null, '09');
INSERT INTO `sys_dict` VALUES ('1218704949967179780', '0', '1218704949837156353', '朝鲜族', null, '10');
INSERT INTO `sys_dict` VALUES ('1218704949967179781', '0', '1218704949837156353', '满族', null, '11');
INSERT INTO `sys_dict` VALUES ('1237185174281478146', '0', '0', '设备类型', '设备类型', 'deviceType');
INSERT INTO `sys_dict` VALUES ('1237185174327615489', '1', '1237185174281478146', '移动虹膜识别设备', null, '0');
INSERT INTO `sys_dict` VALUES ('1237185174336004097', '2', '1237185174281478146', '虹膜识别一体机', null, '1');
INSERT INTO `sys_dict` VALUES ('1237185174344392706', '3', '1237185174281478146', '二代身份证阅读器', null, '2');
INSERT INTO `sys_dict` VALUES ('1237276609223680002', '0', '0', '虹膜采集方式', '虹膜采集方式', 'collectMode');
INSERT INTO `sys_dict` VALUES ('1237276609223680003', '1', '1237276609223680002', '手动录入', null, '0');
INSERT INTO `sys_dict` VALUES ('1237276609253040130', '2', '1237276609223680002', '读卡录入', null, '1');
INSERT INTO `sys_dict` VALUES ('1239042590195392514', '0', '0', '国籍', '', 'nationalityType');
INSERT INTO `sys_dict` VALUES ('1239042590354776065', '0', '1239042590195392514', '中国', null, '001');
INSERT INTO `sys_dict` VALUES ('1239042590522548226', '0', '1239042590195392514', '韩国', null, '002');
INSERT INTO `sys_dict` VALUES ('1239042590686126081', '0', '1239042590195392514', '意大利', null, '003');
INSERT INTO `sys_dict` VALUES ('1239042748647809025', '0', '0', '采集类型', '', 'collType');
INSERT INTO `sys_dict` VALUES ('1239042748802998273', '0', '1239042748647809025', '双眼', null, '3');
INSERT INTO `sys_dict` VALUES ('1239042748962381826', '0', '1239042748647809025', '左眼', null, '2');
INSERT INTO `sys_dict` VALUES ('1239042749125959681', '0', '1239042748647809025', '右眼', null, '1');



CREATE TABLE `sys_metadata_cloumn` (
  `ID` INT PRIMARY KEY     NOT NULL,
  `DELFLAG` char(1) DEFAULT '0',
  `CREATETIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `TABLE_NAME` varchar(32) DEFAULT NULL,
  `COLUMN_NAME` varchar(255) DEFAULT NULL,
  `COLUMN_TITLE` varchar(255) DEFAULT NULL,
  `COLUMN_CODE` varchar(64) DEFAULT NULL,
  `COLUMN_SORT` int(11) DEFAULT NULL,
  `COLUMN_TYPE` varchar(32) DEFAULT NULL,
  `IS_LIST` char(1) DEFAULT NULL,
  `IS_QUERY` char(1) DEFAULT NULL,
  `IS_SHOW` char(1) DEFAULT NULL,
  `FORMATTER` varchar(64) DEFAULT NULL,
  `IS_KEY` char(1) DEFAULT NULL,
  `DICT_CODE` varchar(32) DEFAULT NULL
)


INSERT INTO `sys_metadata_cloumn` VALUES ('1', '0', '2019-12-02 10:10:50', 'sys_person_ext', 'id', '主键', 'id', '0', 'java.lang.Long', '1', '1', '1', null, '1', null);
INSERT INTO `sys_metadata_cloumn` VALUES ('2', '0', '2019-12-02 10:13:24', 'sys_person_ext', 'sCountry', '国籍', 'COLUMN_1', '1', 'java.lang.String', '1', '1', '1', null, '0', null);
INSERT INTO `sys_metadata_cloumn` VALUES ('4', '0', '2019-12-03 11:02:08', 'sys_person_ext', 'targetId', '人员ID', 'TARGET_ID', '3', 'java.lang.Long', '1', '1', '1', null, '0', null);
INSERT INTO `sys_metadata_cloumn` VALUES ('5', '0', '2019-12-09 11:02:07', 'sys_person_ext', 'cerAuth', '颁发机关', 'COLUMN_2', '2', 'java.lang.String', '1', '1', '1', null, '0', null);
INSERT INTO `sys_metadata_cloumn` VALUES ('6', '0', '2019-12-09 11:03:00', 'sys_person_ext', 'addr1', '户籍地址', 'COLUMN_3', '4', 'java.lang.String', '1', '1', '1', null, '0', null);
INSERT INTO `sys_metadata_cloumn` VALUES ('7', '0', '2019-12-24 14:37:25', 'sys_person_ext', 'addr2', '居住地址', 'COLUMN_4', '5', 'java.lang.String', '1', '1', '1', null, '0', null);
INSERT INTO `sys_metadata_cloumn` VALUES ('9', '0', '2020-01-08 11:40:18', 'sys_person_ext', 'cerValid', '有效期', 'COLUMN_6', '7', 'java.lang.String', '1', '1', '1', null, '0', null);


CREATE TABLE `sys_person` (
  `ID` bigint(20) NOT NULL,
  `DELFLAG` varchar(32) DEFAULT NULL,
  `CREATETIME` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `UPDATETIME` timestamp DEFAULT NULL,
  `NAME` varchar(32) DEFAULT NULL,
  `SEX` char(1) DEFAULT NULL,
  `DEPTID` bigint(20) DEFAULT NULL,
  `ID_CARD_NO` varchar(32) DEFAULT NULL,
  `REMARKS` varchar(255) DEFAULT NULL,
  `PERSON_TYPE` varchar(32) DEFAULT NULL,
  `PERSON_CODE` varchar(64) DEFAULT NULL,
  `PHOTO` varchar(255) DEFAULT NULL,
  `OPRATION_ID` bigint(20) DEFAULT NULL,
  `DUTY` varchar(32) DEFAULT NULL,
  `NATION` varchar(32) DEFAULT NULL,
  `BIRTHDAY` date DEFAULT NULL,
  `CARD_TYPE` varchar(255) DEFAULT NULL,
  `PHOTO_DATA` longtext
)




CREATE TABLE `sys_person_ext` (
  `ID` bigint(20) NOT NULL,
  `TARGET_ID` bigint(21) DEFAULT NULL,
  `COLUMN_1` char(3) DEFAULT NULL,
  `COLUMN_2` varchar(100) DEFAULT NULL,
  `COLUMN_3` varchar(32) DEFAULT NULL,
  `COLUMN_4` varchar(100) DEFAULT NULL,
  `COLUMN_5` char(1) DEFAULT NULL,
  `COLUMN_6` varchar(255) DEFAULT NULL,
  `COLUMN_7` longtext
)



CREATE TABLE `sys_user` (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT,
  `user_id` varchar(20) DEFAULT NULL,
  `name` varchar(20) DEFAULT NULL,
  `police_id` varchar(200) DEFAULT NULL,
  `user_number` varchar(18) DEFAULT NULL,
  `password` varchar(40) DEFAULT NULL,
  `user_type` int(11) DEFAULT NULL,
  `creat_time` datetime DEFAULT NULL,
  `IsAdmin` int(11) DEFAULT NULL,
  `IsSynch` varchar(11) DEFAULT '1',
  `SynchMessage` varchar(100) DEFAULT NULL,
  `active` int(1) DEFAULT '0'
) 

INSERT INTO `sys_user` VALUES ('3','admin', 'admin', '123456', '123456739', '123456', '1', '2019-11-12 15:39:16', '1', '1', '未同步', '1');