/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50711
Source Host : localhost:3306
Source Database : casic_gan_iris
Target Server Type : MYSQL
Target Server Version : 50711
File Encoding : 65001
Date: 2020-07-27 17:33:49
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `iris_data`
-- ----------------------------
DROP TABLE IF EXISTS `iris_data`;
CREATE TABLE `iris_data` (
`IR_ID` bigint(20) NOT NULL COMMENT '主键',
`S_ID` bigint(20) DEFAULT NULL COMMENT '人员ID',
`IRIS_L` varbinary(1024) DEFAULT NULL COMMENT '虹膜数据信息（左眼）',
`IRIS_R` varbinary(1024) DEFAULT NULL COMMENT '虹膜数据信息（右眼）',
`PATH_VIDEO` varchar(100) DEFAULT NULL COMMENT '人像视频',
`IMAGE_L1` varchar(256) DEFAULT NULL COMMENT '左眼图片1',
`IMAGE_L2` varchar(256) DEFAULT NULL COMMENT '左眼图片2',
`IMAGE_R1` varchar(256) DEFAULT NULL COMMENT '右眼图片1',
`IMAGE_R2` varchar(256) DEFAULT NULL COMMENT '右眼图片2',
`IMAGE_L1_DATA` longtext COMMENT '左眼虹膜图片base64编码',
`IMAGE_R1_DATA` longtext COMMENT '右眼虹膜图片base64编码',
PRIMARY KEY (`IR_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='虹膜数据';
-- ----------------------------
-- Records of iris_data
-- ----------------------------
-- ----------------------------
-- Table structure for `iris_data_coll`
-- ----------------------------
DROP TABLE IF EXISTS `iris_data_coll`;
CREATE TABLE `iris_data_coll` (
`IR_ID` bigint(20) NOT NULL COMMENT '主键',
`S_ID` bigint(20) DEFAULT NULL COMMENT '人员ID',
`TEL1` varchar(20) DEFAULT NULL COMMENT '手机号1',
`TEL2` varchar(20) DEFAULT NULL COMMENT '手机号2',
`DEV_TYPE` varchar(50) DEFAULT NULL COMMENT '设备型号',
`COLL_TIME` datetime DEFAULT NULL COMMENT '采集时间',
`DEV_CODE` varchar(30) DEFAULT NULL COMMENT '设备编号',
`DEV_FIRM` varchar(100) DEFAULT NULL COMMENT '设备厂商',
`FLG_CER` char(1) DEFAULT NULL COMMENT '无证标志',
`COLL_NUM` varchar(50) DEFAULT NULL COMMENT '采集编号',
`FLG_WO` char(1) DEFAULT NULL COMMENT '工作对象',
`ST_ID` bigint(20) DEFAULT NULL COMMENT '采集工作站',
`COLL_NAME` varchar(50) DEFAULT NULL COMMENT '采集人姓名',
`COLL_ID` bigint(20) DEFAULT NULL COMMENT '采集人ID',
`COLL_REASON` char(3) DEFAULT NULL COMMENT '采集原因',
`Q_L` decimal(4,2) DEFAULT NULL COMMENT '左眼质量',
`Q_R` decimal(4,2) DEFAULT NULL COMMENT '有眼质量',
`REASON_COLL_DESC` varchar(500) DEFAULT NULL COMMENT '采集描述',
`PATH_CER` varchar(100) DEFAULT NULL COMMENT '证件相对全路径地址',
`COLL_TYPE` char(1) DEFAULT NULL COMMENT '采集类型（左眼 双眼 右眼）',
`DEF_REASON` varchar(100) DEFAULT NULL COMMENT '缺失原因',
`DEF_TYPE` char(1) DEFAULT NULL COMMENT '缺失类型',
`IS_CER` char(1) DEFAULT NULL COMMENT '是否携带证件',
`FLG_FORCE` char(1) DEFAULT NULL COMMENT '强制采集标志',
`FLG_SYNC` char(1) DEFAULT NULL COMMENT '同步标志',
`FLG_UPLOAD` char(1) DEFAULT '0' COMMENT '上传标志(0未上传，1已上传成功，2上传失败允许继续上传，3上传失败不允许继续上传)',
`UPLOAD_USER` bigint(20) DEFAULT NULL COMMENT '上传操作人',
`UPLOAD_TIME` datetime DEFAULT NULL COMMENT '上传时间',
`RES_UPLOAD` char(1) DEFAULT NULL COMMENT '上传失败原因，中文',
`COLL_STATE` char(1) DEFAULT NULL COMMENT '采集状态',
`COLL_WAY` char(1) DEFAULT NULL COMMENT '采集方式',
`FLG_FOCUS` char(1) DEFAULT NULL COMMENT '关注标志',
`FAIL_REASON` char(3) DEFAULT NULL COMMENT '采集失败原因',
`ST_X` varchar(20) DEFAULT NULL COMMENT '采集坐标，经度',
`ST_Y` varchar(20) DEFAULT NULL COMMENT '采集坐标，纬度',
`PHOTO` varchar(255) DEFAULT NULL COMMENT '证件照',
`COLL_SPEND` varchar(20) DEFAULT NULL COMMENT '采集图片耗时',
`FLG_DEL` char(1) DEFAULT '0' COMMENT '逻辑删除标记：0-未删除；1-已删除',
`IMAGE_L1` varchar(255) DEFAULT NULL COMMENT '左眼图片1',
`IMAGE_L2` varchar(255) DEFAULT NULL COMMENT '左眼图片2',
`IMAGE_R1` varchar(255) DEFAULT NULL COMMENT '右眼图片1',
`IMAGE_R2` varchar(255) DEFAULT NULL COMMENT '右眼图片2',
`COLL_PLACE` varchar(50) DEFAULT NULL COMMENT '采集场地',
`FOCUS_END_DATE` date DEFAULT NULL COMMENT '临时关注结束日期',
`FOCUS_REMARKS` varchar(255) DEFAULT NULL COMMENT '临时关注备注',
`ST_NAME` varchar(255) DEFAULT NULL COMMENT '采集站点名称',
`ST_TYPE` varchar(50) DEFAULT NULL COMMENT '站点类别',
`FLG_FORCE_PERSON` char(1) DEFAULT NULL COMMENT '是否强制采集人员',
PRIMARY KEY (`IR_ID`),
KEY `S_ID` (`S_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='虹膜数据采集信息';
-- ----------------------------
-- Records of iris_data_coll
-- ----------------------------
-- ----------------------------
-- Table structure for `sys_dict`
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE `sys_dict` (
`ID` bigint(21) NOT NULL COMMENT '主键ID',
`NUM` int(11) DEFAULT NULL COMMENT '排序',
`PID` bigint(32) DEFAULT NULL COMMENT '父级字典',
`NAME` varchar(255) DEFAULT NULL COMMENT '名称',
`TIPS` varchar(255) DEFAULT NULL COMMENT '提示',
`CODE` varchar(64) DEFAULT NULL COMMENT '字典值',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='字典表';
-- ----------------------------
-- Records of sys_dict
-- ----------------------------
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');
-- ----------------------------
-- Table structure for `sys_metadata_cloumn`
-- ----------------------------
DROP TABLE IF EXISTS `sys_metadata_cloumn`;
CREATE TABLE `sys_metadata_cloumn` (
`ID` bigint(20) NOT NULL,
`DELFLAG` char(1) DEFAULT '0' COMMENT '状态(0：有效 1：删除）',
`CREATETIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`TABLE_NAME` varchar(32) DEFAULT NULL COMMENT '表名',
`COLUMN_NAME` varchar(255) DEFAULT NULL COMMENT '字段映射名称',
`COLUMN_TITLE` varchar(255) DEFAULT NULL COMMENT '字段映射标题',
`COLUMN_CODE` varchar(64) DEFAULT NULL COMMENT '数据表字段编码',
`COLUMN_SORT` int(11) DEFAULT NULL COMMENT '字段排序',
`COLUMN_TYPE` varchar(32) DEFAULT NULL COMMENT '字段类型',
`IS_LIST` char(1) DEFAULT NULL COMMENT '是否列表字段',
`IS_QUERY` char(1) DEFAULT NULL COMMENT '是否查询',
`IS_SHOW` char(1) DEFAULT NULL COMMENT '是否显示',
`FORMATTER` varchar(64) DEFAULT NULL COMMENT '格式化',
`IS_KEY` char(1) DEFAULT NULL COMMENT '是否主键(0否 1 是)',
`DICT_CODE` varchar(32) DEFAULT NULL COMMENT '是否为字典值',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='动态表单行描述数据SYS_METADATA_CLOUMN';
-- ----------------------------
-- Records of sys_metadata_cloumn
-- ----------------------------
INSERT INTO `sys_metadata_cloumn` VALUES ('1', '0', '1899-00-É5 É5:É5:É5', 'sys_person_ext', 'id', '主键', 'id', '0', 'java.lang.Long', '1', '1', '1', null, '1', null);
INSERT INTO `sys_metadata_cloumn` VALUES ('2', '0', '2006-05-24 12:43:09', 'sys_person_ext', 'sCountry', '国籍', 'COLUMN_1', '1', 'java.lang.String', '1', '1', '1', null, '0', null);
INSERT INTO `sys_metadata_cloumn` VALUES ('4', '0', '1995-12-15 11:02:53', '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', '1995-05-17 20:34:37', 'sys_person_ext', 'cerAuth', '颁发机关', 'COLUMN_2', '2', 'java.lang.String', '1', '1', '1', null, '0', null);
INSERT INTO `sys_metadata_cloumn` VALUES ('6', '0', '2023-07-21 10:28:45', 'sys_person_ext', 'addr1', '户籍地址', 'COLUMN_3', '4', 'java.lang.String', '1', '1', '1', null, '0', null);
INSERT INTO `sys_metadata_cloumn` VALUES ('7', '0', '1990-01-16 00:59:10', 'sys_person_ext', 'addr2', '居住地址', 'COLUMN_4', '5', 'java.lang.String', '1', '1', '1', null, '0', null);
INSERT INTO `sys_metadata_cloumn` VALUES ('9', '0', '1988-03-29 11:09:18', 'sys_person_ext', 'cerValid', '有效期', 'COLUMN_6', '7', 'java.lang.String', '1', '1', '1', null, '0', null);
-- ----------------------------
-- Table structure for `sys_person`
-- ----------------------------
DROP TABLE IF EXISTS `sys_person`;
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' COMMENT '创建时间',
`UPDATETIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
`NAME` varchar(32) DEFAULT NULL COMMENT '姓名',
`SEX` char(1) DEFAULT NULL COMMENT '性别',
`DEPTID` bigint(20) DEFAULT NULL COMMENT '所属部门',
`ID_CARD_NO` varchar(32) DEFAULT NULL COMMENT '身份证号',
`REMARKS` varchar(255) DEFAULT NULL COMMENT '备注信息',
`PERSON_TYPE` varchar(32) DEFAULT NULL COMMENT '人员类别',
`PERSON_CODE` varchar(64) DEFAULT NULL COMMENT '人员编码',
`PHOTO` varchar(255) DEFAULT NULL COMMENT '证件照',
`OPRATION_ID` bigint(20) DEFAULT NULL COMMENT '操作人',
`DUTY` varchar(32) DEFAULT NULL COMMENT '职务',
`NATION` varchar(32) DEFAULT NULL COMMENT '民族',
`BIRTHDAY` date DEFAULT NULL COMMENT '出生日期',
`CARD_TYPE` varchar(255) DEFAULT NULL,
`PHOTO_DATA` longtext COMMENT '证件照片base64',
PRIMARY KEY (`ID`),
UNIQUE KEY `AK_KEY_2` (`PERSON_CODE`) USING BTREE,
UNIQUE KEY `PERSON_CODE_INDEX` (`PERSON_CODE`) USING BTREE,
UNIQUE KEY `ID_CARD_INDEX` (`ID_CARD_NO`,`DELFLAG`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='人员数据表';
-- ----------------------------
-- Records of sys_person
-- ----------------------------
-- ----------------------------
-- Table structure for `sys_person_ext`
-- ----------------------------
DROP TABLE IF EXISTS `sys_person_ext`;
CREATE TABLE `sys_person_ext` (
`ID` bigint(20) NOT NULL,
`TARGET_ID` bigint(21) DEFAULT NULL COMMENT '关联sys_person表主键ID',
`COLUMN_1` char(3) DEFAULT NULL COMMENT '国籍',
`COLUMN_2` varchar(100) DEFAULT NULL COMMENT '颁发机关',
`COLUMN_3` varchar(32) DEFAULT NULL COMMENT '户籍地址',
`COLUMN_4` varchar(100) DEFAULT NULL COMMENT '居住地址',
`COLUMN_5` char(1) DEFAULT NULL COMMENT '关注状态',
`COLUMN_6` varchar(255) DEFAULT NULL COMMENT '有效期限',
`COLUMN_7` longtext COMMENT '证件照base64',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='人员数据表';
-- ----------------------------
-- Records of sys_person_ext
-- ----------------------------
-- ----------------------------
-- Table structure for `sys_user`
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
`user_id` varchar(20) DEFAULT NULL COMMENT '账号',
`name` varchar(20) DEFAULT NULL COMMENT '姓名',
`police_id` varchar(200) DEFAULT NULL COMMENT '警务号',
`user_number` varchar(18) DEFAULT NULL COMMENT '身份证号',
`password` varchar(40) DEFAULT NULL COMMENT '密码',
`user_type` int(11) DEFAULT NULL COMMENT '用户类型',
`creat_time` datetime DEFAULT NULL COMMENT '创建时间',
`IsAdmin` int(11) DEFAULT NULL COMMENT '是否超级管理员(1:是, 0:不是)',
`IsSynch` varchar(11) DEFAULT '1' COMMENT '是否已同步 0：同步成功 其他：同步失败',
`SynchMessage` varchar(100) DEFAULT NULL,
`active` int(1) DEFAULT '0' COMMENT '逻辑删除',
`id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=48 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES ('admin', 'admin', '123456', '123456739', '123456', '1', '2019-11-12 15:39:16', '1', '1', '未同步', '1', '3');
INSERT INTO `sys_user` VALUES ('fkx', 'fkx', '132412341324', '13262419950511806X', '123456', '1', '2020-06-28 14:12:00', '1', '1', '未同步', '1', '46');
INSERT INTO `sys_user` VALUES ('1', 'fangkx', '1', '13262419950511806X', '11', '1', '2020-06-28 14:13:05', '1', '1', '未同步', '1', '47');
-- ----------------------------
-- View structure for `iris_coll_view`
-- ----------------------------
DROP VIEW IF EXISTS `iris_coll_view`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `iris_coll_view` AS select `iris_data_coll`.`IR_ID` AS `IR_ID`,`iris_data_coll`.`S_ID` AS `S_ID`,`iris_data_coll`.`TEL1` AS `TEL1`,`iris_data_coll`.`TEL2` AS `TEL2`,`iris_data_coll`.`DEV_TYPE` AS `DEV_TYPE`,`iris_data_coll`.`COLL_TIME` AS `COLL_TIME`,`iris_data_coll`.`DEV_CODE` AS `DEV_CODE`,`iris_data_coll`.`DEV_FIRM` AS `DEV_FIRM`,`iris_data_coll`.`FLG_CER` AS `FLG_CER`,`iris_data_coll`.`COLL_NUM` AS `COLL_NUM`,`iris_data_coll`.`FLG_WO` AS `FLG_WO`,`iris_data_coll`.`ST_ID` AS `ST_ID`,`iris_data_coll`.`COLL_NAME` AS `COLL_NAME`,`iris_data_coll`.`COLL_ID` AS `COLL_ID`,`iris_data_coll`.`COLL_REASON` AS `COLL_REASON`,`iris_data_coll`.`Q_L` AS `Q_I`,`iris_data_coll`.`Q_R` AS `Q_R`,`iris_data_coll`.`REASON_COLL_DESC` AS `REASON_COLL_DESC`,`iris_data_coll`.`PATH_CER` AS `PATH_CER`,`iris_data_coll`.`COLL_TYPE` AS `COLL_TYPE`,`iris_data_coll`.`DEF_REASON` AS `DEF_REASON`,`iris_data_coll`.`DEF_TYPE` AS `DEF_TYPE`,`iris_data_coll`.`IS_CER` AS `IS_CER`,`iris_data_coll`.`FLG_FORCE` AS `FLG_FORCE`,`iris_data_coll`.`FLG_SYNC` AS `FLG_SYNC`,`iris_data_coll`.`FLG_UPLOAD` AS `FLG_UPLOAD`,`iris_data_coll`.`UPLOAD_USER` AS `UPLOAD_USER`,`iris_data_coll`.`UPLOAD_TIME` AS `UPLOAD_TIME`,`iris_data_coll`.`RES_UPLOAD` AS `RES_UPLOAD`,`iris_data_coll`.`COLL_STATE` AS `COLL_STATE`,`iris_data_coll`.`COLL_WAY` AS `COLL_WAY`,`iris_data_coll`.`FLG_FOCUS` AS `FLG_FOCUS`,`iris_data_coll`.`FAIL_REASON` AS `FALL_REASON`,`iris_data_coll`.`PHOTO` AS `PHOTOD`,`iris_data_coll`.`COLL_SPEND` AS `COLL_SPEND`,`iris_data_coll`.`FLG_DEL` AS `FLG_DEL`,`iris_data_coll`.`COLL_PLACE` AS `COLL_PLACE`,`iris_data_coll`.`FOCUS_END_DATE` AS `FOCUS_END_DATE`,`iris_data_coll`.`FOCUS_REMARKS` AS `FOCUS_REMARKS`,`iris_data_coll`.`ST_NAME` AS `ST_NAME`,`iris_data_coll`.`ST_TYPE` AS `ST_TYPE`,`iris_data_coll`.`FLG_FORCE_PERSON` AS `FLG_FORCE_PERSON`,`sys_person`.`ID` AS `ID`,`sys_person`.`DELFLAG` AS `DELFLAG`,`sys_person`.`CREATETIME` AS `CREATETIME`,`sys_person`.`UPDATETIME` AS `UPDATETIME`,`sys_person`.`NAME` AS `NAME`,`sys_person`.`SEX` AS `SEX`,`sys_person`.`DEPTID` AS `DEPTID`,`sys_person`.`ID_CARD_NO` AS `ID_CARD_NO`,`sys_person`.`REMARKS` AS `REMARKS`,`sys_person`.`PERSON_TYPE` AS `PERSON_TYPE`,`sys_person`.`PERSON_CODE` AS `PERSON_CODE`,`sys_person`.`PHOTO` AS `PHOTOP`,`sys_person`.`OPRATION_ID` AS `OPRATION_ID`,`sys_person`.`DUTY` AS `DUTY`,`sys_person`.`NATION` AS `NATION`,`sys_person`.`BIRTHDAY` AS `BIRTHDAY`,`sys_person`.`CARD_TYPE` AS `CARD_TYPE`,`sys_person`.`PHOTO_DATA` AS `PHOTO_DATA`,`sys_person_ext`.`ID` AS `IDE`,`sys_person_ext`.`TARGET_ID` AS `TARGET_ID`,`sys_person_ext`.`COLUMN_1` AS `COLUMN_1`,`sys_person_ext`.`COLUMN_2` AS `COLUMN_2`,`sys_person_ext`.`COLUMN_3` AS `COLUMN_3`,`sys_person_ext`.`COLUMN_4` AS `COLUMN_4`,`sys_person_ext`.`COLUMN_5` AS `COLUMN_5`,`sys_person_ext`.`COLUMN_6` AS `COLUMN_6`,`sys_person_ext`.`COLUMN_7` AS `COLUMN_7`,`iris_data_coll`.`ST_X` AS `ST_X`,`iris_data_coll`.`ST_Y` AS `ST_Y`,`iris_data`.`IMAGE_L1_DATA` AS `IMAGE_L1_DATA`,`iris_data`.`IMAGE_R1_DATA` AS `IMAGE_R1_DATA`,`iris_data`.`IR_ID` AS `IR_ID_DT`,`iris_data`.`S_ID` AS `S_ID_DT`,`iris_data`.`IMAGE_L1` AS `IMAGE_L1`,`iris_data`.`IMAGE_L2` AS `IMAGE_L2`,`iris_data`.`IMAGE_R1` AS `IMAGE_R1`,`iris_data`.`IMAGE_R2` AS `IMAGE_R2` from (((`iris_data_coll` join `sys_person`) join `sys_person_ext`) join `iris_data`) where ((`sys_person`.`ID` = `iris_data_coll`.`S_ID`) and (`sys_person_ext`.`TARGET_ID` = `sys_person`.`ID`) and (`iris_data`.`S_ID` = `sys_person`.`ID`)) ;
