tuon-config/sql/archives_utilization.sql

/*
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
-- ----------------------------