/* Navicat MariaDB Data Transfer Source Server : archives Source Server Version : 100032 Source Host : 192.168.1.92:3307 Source Database : archives_utilization Target Server Type : MariaDB Target Server Version : 100032 File Encoding : 65001 Date: 2018-04-13 10:56:54 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for utilization_borrow -- ---------------------------- DROP TABLE IF EXISTS `utilization_borrow`; CREATE TABLE `utilization_borrow` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `enable` bit(1) NOT NULL DEFAULT b'1' COMMENT '逻辑删表示，0表示删除', `remark` varchar(1024) DEFAULT NULL COMMENT '备注', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `create_by` varchar(20) DEFAULT NULL COMMENT '创建人', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `update_by` varchar(20) DEFAULT NULL COMMENT '更新人', `duration` varchar(50) DEFAULT NULL COMMENT '借阅期限', `deadline` datetime DEFAULT NULL COMMENT '应归还时间', `status` varchar(50) DEFAULT NULL COMMENT '归还状态', `return_time` datetime DEFAULT NULL COMMENT '实际归还时间', `company` varchar(50) DEFAULT NULL COMMENT '单位名', `name` varchar(50) DEFAULT NULL COMMENT '姓名', `phone` varchar(20) DEFAULT NULL COMMENT '电话', `archives_name` varchar(255) DEFAULT NULL COMMENT '档案名', `credential` varchar(20) DEFAULT NULL COMMENT '凭证', `comment` varchar(255) DEFAULT NULL COMMENT '备注', `fondsId` bigint(20) DEFAULT NULL COMMENT '全宗号', `catalogId` varchar(50) DEFAULT NULL COMMENT '目录号', `filesId` varchar(50) DEFAULT NULL COMMENT '案卷号', `serialNo` varchar(50) DEFAULT NULL COMMENT '序号', `organization` varchar(50) DEFAULT NULL COMMENT '机构', `boxNo` varchar(50) DEFAULT NULL COMMENT '盒号', `pieceNo` varchar(50) DEFAULT NULL COMMENT '件号', `years` varchar(20) DEFAULT NULL COMMENT '年度', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of utilization_borrow -- ---------------------------- INSERT INTO `utilization_borrow` VALUES ('1', '', null, '2018-03-22 09:20:19', 'admin', '2018-03-24 10:02:05', 'admin', '11', null, null, null, null, '1', '2', '4564', null, null, '3', '4', '5', '6', '7', '8', '9', '10'); INSERT INTO `utilization_borrow` VALUES ('2', '', null, '2018-03-24 08:17:19', 'admin', '2018-03-24 09:11:30', 'admin', '12', null, null, null, null, 'why', '2', '3', null, null, '4', '5', '6', '7', '8', '9', '10', '11'); INSERT INTO `utilization_borrow` VALUES ('3', '', null, '2018-03-26 09:18:16', 'admin', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null); INSERT INTO `utilization_borrow` VALUES ('4', '', null, '2018-03-26 09:23:25', 'admin', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null); INSERT INTO `utilization_borrow` VALUES ('5', '', null, '2018-03-26 09:28:18', 'admin', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null); INSERT INTO `utilization_borrow` VALUES ('6', '', null, '2018-03-26 09:31:23', 'admin', null, null, '8', null, null, null, null, '19', '18', '17', null, null, '116', '15', '14', '13', '12', '11', '10', '9'); INSERT INTO `utilization_borrow` VALUES ('7', '', null, '2018-03-26 09:31:32', 'admin', null, null, '8', null, null, null, null, '19', '18', '17', null, null, '116', '15', '14', '13', '12', '11', '10', '9'); INSERT INTO `utilization_borrow` VALUES ('8', '', null, '2018-03-26 09:31:35', 'admin', null, null, '8', null, null, null, null, '19', '18', '17', null, null, '116', '15', '14', '13', '12', '11', '10', '9'); INSERT INTO `utilization_borrow` VALUES ('9', '', null, '2018-03-26 09:31:39', 'admin', null, null, '8', null, null, null, null, '19', '18', '17', null, null, '116', '15', '14', '13', '12', '11', '10', '9'); INSERT INTO `utilization_borrow` VALUES ('10', '', null, '2018-03-26 09:31:42', 'admin', null, null, '8', null, null, null, null, '19', '18', '17', null, null, '116', '15', '14', '13', '12', '11', '10', '9'); INSERT INTO `utilization_borrow` VALUES ('11', '', null, '2018-03-26 09:31:44', 'admin', null, null, '8', null, null, null, null, '19', '18', '17', null, null, '116', '15', '14', '13', '12', '11', '10', '9'); INSERT INTO `utilization_borrow` VALUES ('12', '', null, '2018-03-26 09:31:46', 'admin', null, null, '8', null, null, null, null, '19', '18', '17', null, null, '116', '15', '14', '13', '12', '11', '10', '9'); INSERT INTO `utilization_borrow` VALUES ('13', '', null, '2018-03-26 09:31:48', 'admin', null, null, '8', null, null, null, null, '19', '18', '17', null, null, '116', '15', '14', '13', '12', '11', '10', '9'); INSERT INTO `utilization_borrow` VALUES ('14', '', null, '2018-03-26 09:32:03', 'admin', null, null, '8', null, null, null, null, '19', '18', '17', null, null, '116', '15', '14', '13', '12', '11', '10', '9'); INSERT INTO `utilization_borrow` VALUES ('15', '', null, '2018-03-26 09:32:05', 'admin', null, null, '8', null, null, null, null, '19', '18', '17', null, null, '116', '15', '14', '13', '12', '11', '10', '9'); INSERT INTO `utilization_borrow` VALUES ('16', '', null, '2018-03-26 09:32:07', 'admin', null, null, '8', null, null, null, null, '19', '18', '17', null, null, '116', '15', '14', '13', '12', '11', '10', '9'); INSERT INTO `utilization_borrow` VALUES ('17', '', null, '2018-03-26 09:32:07', 'admin', null, null, '8', null, null, null, null, '19', '18', '17', null, null, '116', '15', '14', '13', '12', '11', '10', '9'); INSERT INTO `utilization_borrow` VALUES ('18', '', null, '2018-03-26 09:32:10', 'admin', null, null, '8', null, null, null, null, '19', '18', '17', null, null, '116', '15', '14', '13', '12', '11', '10', '9'); INSERT INTO `utilization_borrow` VALUES ('19', '', null, '2018-03-26 09:32:10', 'admin', null, null, '8', null, null, null, null, '19', '18', '17', null, null, '116', '15', '14', '13', '12', '11', '10', '9'); INSERT INTO `utilization_borrow` VALUES ('20', '', null, '2018-03-26 09:32:21', 'admin', null, null, '8', null, null, null, null, '19', '18', '17', null, null, '116', '15', '14', '13', '12', '11', '10', '9'); INSERT INTO `utilization_borrow` VALUES ('21', '', null, '2018-03-26 09:32:21', 'admin', null, null, '8', null, null, null, null, '19', '18', '17', null, null, '116', '15', '14', '13', '12', '11', '10', '9'); INSERT INTO `utilization_borrow` VALUES ('22', '', null, '2018-03-26 09:32:21', 'admin', null, null, '8', null, null, null, null, '19', '18', '17', null, null, '116', '15', '14', '13', '12', '11', '10', '9'); INSERT INTO `utilization_borrow` VALUES ('23', '', null, '2018-03-26 09:32:22', 'admin', null, null, '8', null, null, null, null, '19', '18', '17', null, null, '116', '15', '14', '13', '12', '11', '10', '9'); INSERT INTO `utilization_borrow` VALUES ('24', '', null, '2018-03-26 09:32:22', 'admin', null, null, '8', null, null, null, null, '19', '18', '17', null, null, '116', '15', '14', '13', '12', '11', '10', '9'); INSERT INTO `utilization_borrow` VALUES ('25', '', null, '2018-04-11 08:16:58', 'admin', null, null, '64', null, null, null, null, '', '', '', null, null, null, '', '', '', '', '', '', ''); -- ---------------------------- -- Table structure for utilization_cachet -- ---------------------------- DROP TABLE IF EXISTS `utilization_cachet`; CREATE TABLE `utilization_cachet` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `enable` bit(1) NOT NULL DEFAULT b'1' COMMENT '逻辑删表示，0表示删除', `remark` varchar(1024) DEFAULT NULL COMMENT '备注', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `create_by` varchar(20) DEFAULT NULL COMMENT '创建人', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `update_by` varchar(20) DEFAULT NULL COMMENT '更新人', `company` varchar(50) DEFAULT NULL COMMENT '单位', `content` varchar(255) DEFAULT NULL COMMENT '补盖内容', `cachet_id` varchar(50) DEFAULT NULL COMMENT '印章编号', `amount` int(4) DEFAULT NULL COMMENT '补盖件数', `name` varchar(20) DEFAULT NULL COMMENT '补盖章人', `credential` varchar(20) DEFAULT NULL COMMENT '是否有介绍信', `comment` varchar(255) DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of utilization_cachet -- ---------------------------- INSERT INTO `utilization_cachet` VALUES ('1', '', null, '2018-03-20 09:23:58', 'admin', null, null, '1', '2', '3', '4', '5', '6', '7'); INSERT INTO `utilization_cachet` VALUES ('2', '', null, '2018-03-20 09:24:13', 'admin', null, null, '1', '2', '3', '4', '5', '6', '7'); INSERT INTO `utilization_cachet` VALUES ('3', '', null, '2018-03-20 09:26:17', 'admin', '2018-03-27 02:00:21', 'admin', '77777', '6666', '5', '4', '3', '2', '1'); -- ---------------------------- -- Table structure for utilization_evaluation -- ---------------------------- DROP TABLE IF EXISTS `utilization_evaluation`; CREATE TABLE `utilization_evaluation` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `enable` bit(1) NOT NULL DEFAULT b'1' COMMENT '逻辑删表示，0表示删除', `remark` varchar(1024) DEFAULT NULL COMMENT '备注', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `create_by` varchar(20) DEFAULT NULL COMMENT '创建人', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `update_by` varchar(20) DEFAULT NULL COMMENT '更新人', `evaluate_score` varchar(10) NOT NULL COMMENT '评分', `evaluate_content` varchar(255) DEFAULT NULL COMMENT '评价内容', `evaluate_time` datetime NOT NULL COMMENT '评价时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of utilization_evaluation -- ---------------------------- -- ---------------------------- -- Table structure for utilization_id_card -- ---------------------------- DROP TABLE IF EXISTS `utilization_id_card`; CREATE TABLE `utilization_id_card` ( `id` bigint(20) NOT NULL COMMENT '主键', `enable` bit(1) NOT NULL DEFAULT b'1' COMMENT '逻辑删表示，0表示删除', `remark` varchar(1024) DEFAULT NULL COMMENT '备注', `create_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间', `create_by` varchar(20) DEFAULT NULL COMMENT '创建人', `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `update_by` varchar(20) DEFAULT NULL COMMENT '更新人', `name` varchar(50) DEFAULT NULL COMMENT '姓名', `gender` tinyint(4) DEFAULT '-1' COMMENT '性别', `ethnic` varchar(255) DEFAULT NULL COMMENT '民族', `birthday` varchar(255) DEFAULT NULL COMMENT '出生日期', `address` varchar(255) DEFAULT NULL COMMENT '地址', `id_card_no` int(11) DEFAULT NULL COMMENT '身份证号', `issuing_authority` varchar(255) DEFAULT NULL COMMENT '发卡机关', `issuing_date` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '发卡日期', `valid_date` varchar(255) DEFAULT NULL COMMENT '卡有效期', `photo` blob COMMENT '照片' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of utilization_id_card -- ---------------------------- -- ---------------------------- -- Table structure for utilization_register -- ---------------------------- DROP TABLE IF EXISTS `utilization_register`; CREATE TABLE `utilization_register` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `enable` bit(1) NOT NULL DEFAULT b'1' COMMENT '逻辑删表示，0表示删除', `remark` varchar(1024) DEFAULT NULL COMMENT '备注', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `create_by` varchar(20) DEFAULT NULL COMMENT '创建人', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `update_by` varchar(20) DEFAULT NULL COMMENT '更新人', `property` varchar(50) DEFAULT NULL COMMENT '证件类型', `name` varchar(50) DEFAULT NULL COMMENT '姓名', `phone` varchar(20) DEFAULT NULL COMMENT '电话', `idcard_number` varchar(50) DEFAULT NULL COMMENT '身份证号', `credentials_file` varchar(255) DEFAULT NULL COMMENT '身份证明文件', `company_name` varchar(255) DEFAULT NULL COMMENT '单位名', `archives_name` varchar(255) DEFAULT NULL COMMENT '档案名', `apply_purpose` varchar(255) DEFAULT NULL COMMENT '申请目的', `fondsId` bigint(20) DEFAULT NULL COMMENT '全宗号', `catalogId` varchar(50) DEFAULT NULL COMMENT '目录号', `filesId` varchar(50) DEFAULT NULL COMMENT '案卷号', `serialNo` varchar(50) DEFAULT NULL COMMENT '序号', `organization` varchar(50) DEFAULT NULL COMMENT '机构', `boxNo` varchar(50) DEFAULT NULL COMMENT '盒号', `pieceNo` varchar(50) DEFAULT NULL COMMENT '件号', `years` varchar(20) DEFAULT NULL COMMENT '年度', `excerpt` bigint(10) DEFAULT NULL COMMENT '摘抄', `copy` bigint(10) DEFAULT NULL COMMENT '复印', `take_photo` bigint(10) DEFAULT NULL COMMENT '拍照', `scan` bigint(10) DEFAULT NULL COMMENT '扫描', `effect` varchar(100) DEFAULT NULL COMMENT '利用效果', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of utilization_register -- ---------------------------- INSERT INTO `utilization_register` VALUES ('1', '', null, null, null, null, null, '', '', '133333333', '66666', '', null, '', '', '9888', null, null, null, null, null, null, null, null, null, null, null, null); INSERT INTO `utilization_register` VALUES ('2', '', null, null, null, null, null, '', '', '133333333', '66666', '', null, '', '', '9888', null, null, null, null, null, null, null, null, null, null, null, null); INSERT INTO `utilization_register` VALUES ('3', '', null, '2018-03-16 03:52:08', 'admin', null, null, null, null, null, null, null, null, null, 'reer', null, null, null, null, null, null, null, null, null, null, null, null, null); INSERT INTO `utilization_register` VALUES ('4', '', null, '2018-03-19 07:39:52', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null); INSERT INTO `utilization_register` VALUES ('5', '', null, '2018-03-19 07:40:46', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null); INSERT INTO `utilization_register` VALUES ('6', '', null, '2018-03-19 09:51:29', 'admin', null, null, '4', '2', '3', '5', null, '1', '6', '7', '8', '9', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', null); INSERT INTO `utilization_register` VALUES ('7', '', null, '2018-03-19 09:52:25', 'admin', null, null, '4', '2', '3', '5', null, '1', '6', '7', '8', '9', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', null); INSERT INTO `utilization_register` VALUES ('8', '', null, '2018-03-19 09:55:36', 'admin', null, null, '16', '18', '17', '15', null, '19', '14', '13', '12', '11', '10', '9', '8', '7', '6', '5', '4', '3', '2', '1', null); INSERT INTO `utilization_register` VALUES ('9', '', null, '2018-03-19 09:56:21', 'admin', null, null, '16', '18', '17', '15', null, '19', '14', '13', '12', '11', '10', '9', '8', '7', '6', '5', '4', '3', '2', '1', null); INSERT INTO `utilization_register` VALUES ('10', '', null, '2018-03-19 09:56:21', 'admin', null, null, '16', '18', '17', '15', null, '19', '14', '13', '12', '11', '10', '9', '8', '7', '6', '5', '4', '3', '2', '1', null); INSERT INTO `utilization_register` VALUES ('11', '', null, '2018-03-19 09:56:21', 'admin', null, null, '16', '18', '17', '15', null, '19', '14', '13', '12', '11', '10', '9', '8', '7', '6', '5', '4', '3', '2', '1', null); INSERT INTO `utilization_register` VALUES ('12', '', null, '2018-03-19 09:56:21', 'admin', null, null, '16', '18', '17', '15', null, '19', '14', '13', '12', '11', '10', '9', '8', '7', '6', '5', '4', '3', '2', '1', null); INSERT INTO `utilization_register` VALUES ('13', '', null, '2018-03-19 09:56:21', 'admin', null, null, '16', '18', '17', '15', null, '19', '14', '13', '12', '11', '10', '9', '8', '7', '6', '5', '4', '3', '2', '1', null); INSERT INTO `utilization_register` VALUES ('14', '', null, '2018-03-19 09:56:21', 'admin', null, null, '16', '18', '17', '15', null, '19', '14', '13', '12', '11', '10', '9', '8', '7', '6', '5', '4', '3', '2', '1', null); INSERT INTO `utilization_register` VALUES ('15', '', null, '2018-03-19 09:56:23', 'admin', null, null, '16', '18', '17', '15', null, '19', '14', '13', '12', '11', '10', '9', '8', '7', '6', '5', '4', '3', '2', '1', null); INSERT INTO `utilization_register` VALUES ('16', '', null, '2018-03-19 09:56:25', 'admin', null, null, '16', '18', '17', '15', null, '19', '14', '13', '12', '11', '10', '9', '8', '7', '6', '5', '4', '3', '2', '1', null); INSERT INTO `utilization_register` VALUES ('17', '', null, '2018-03-19 09:56:26', 'admin', null, null, '16', '18', '17', '15', null, '19', '14', '13', '12', '11', '10', '9', '8', '7', '6', '5', '4', '3', '2', '1', null); INSERT INTO `utilization_register` VALUES ('18', '', null, '2018-04-03 02:54:16', 'admin', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null); INSERT INTO `utilization_register` VALUES ('19', '', null, '2018-04-03 03:36:48', 'admin', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null); INSERT INTO `utilization_register` VALUES ('20', '', null, '2018-04-03 03:40:03', 'admin', null, null, null, 'www', '666', 'eee', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null); INSERT INTO `utilization_register` VALUES ('21', '', null, '2018-04-03 03:46:41', 'admin', null, null, null, '666', '888', '777', null, null, '999', null, null, null, null, null, null, null, null, null, null, null, null, null, null); INSERT INTO `utilization_register` VALUES ('22', '', null, '2018-04-10 09:35:32', 'admin', null, null, null, '', '', '', null, null, '', null, null, null, null, null, null, null, null, null, null, null, null, null, null); -- ---------------------------- -- Table structure for utilization_statistics -- ---------------------------- DROP TABLE IF EXISTS `utilization_statistics`; CREATE TABLE `utilization_statistics` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `enable` bit(1) NOT NULL DEFAULT b'1' COMMENT '逻辑删表示，0表示删除', `remark` varchar(1024) DEFAULT NULL COMMENT '备注', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `create_by` varchar(20) DEFAULT NULL COMMENT '创建人', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `update_by` varchar(20) DEFAULT NULL COMMENT '更新人', `years` varchar(50) DEFAULT NULL COMMENT '年度', `fonds` varchar(50) DEFAULT NULL COMMENT '全宗号', `times` bigint(20) DEFAULT NULL COMMENT '次', `person_time` bigint(20) DEFAULT NULL COMMENT '人次', `volume` bigint(20) DEFAULT NULL COMMENT '卷', `piece` bigint(20) DEFAULT NULL COMMENT '件', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of utilization_statistics -- ----------------------------