/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50536
Source Host           : localhost:3306
Source Database       : p2p-loan

Target Server Type    : MYSQL
Target Server Version : 50536
File Encoding         : 65001

Date: 2018-03-01 10:50:27
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for account
-- ----------------------------
DROP TABLE IF EXISTS `account`;
CREATE TABLE `account` (
  `account_id` bigint(20) NOT NULL COMMENT '账户信息ID',
  `mem_id` bigint(20) NOT NULL COMMENT '会员用户ID',
  `trade_password` varchar(15) NOT NULL COMMENT '支付密码',
  `usable_amount` decimal(18,4) NOT NULL COMMENT '可用金额',
  `freezed_amount` decimal(18,4) NOT NULL COMMENT '冻结金额',
  `version` int(11) DEFAULT NULL,
  `unreceive_interest` decimal(18,4) NOT NULL COMMENT '账户待收利息',
  `unreceive_principal` decimal(18,4) NOT NULL COMMENT '账户待收本金',
  `unreturn_amount` decimal(18,4) NOT NULL COMMENT '账户待还金额',
  `remain_borrow_limit` decimal(18,4) NOT NULL COMMENT '账户剩余授信额度',
  `borrow_limit` decimal(18,4) NOT NULL COMMENT '授信额度（当前还可以信用借款额度）',
  PRIMARY KEY (`account_id`),
  KEY `fk_ac_mid` (`mem_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of account
-- ----------------------------

-- ----------------------------
-- Table structure for account_flow
-- ----------------------------
DROP TABLE IF EXISTS `account_flow`;
CREATE TABLE `account_flow` (
  `accflow_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '账户流水ID',
  `trade_time` datetime NOT NULL COMMENT '产生流水的时间',
  `action_type` tinyint(4) NOT NULL COMMENT '流水的类型',
  `amount` decimal(18,4) NOT NULL COMMENT '业务金额',
  `account_id` bigint(20) NOT NULL COMMENT '流水发生的账户',
  `usable_amount` decimal(18,4) NOT NULL COMMENT '操作后的账户金额',
  `freezed_amount` decimal(18,4) NOT NULL COMMENT '操作后的冻结金额',
  `note` varchar(255) DEFAULT NULL COMMENT '流水说明',
  PRIMARY KEY (`accflow_id`)
) ENGINE=MyISAM AUTO_INCREMENT=48 DEFAULT CHARSET=utf8 COMMENT='账户流水记录表';

-- ----------------------------
-- Records of account_flow
-- ----------------------------

-- ----------------------------
-- Table structure for advert
-- ----------------------------
DROP TABLE IF EXISTS `advert`;
CREATE TABLE `advert` (
  `advert_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '广告位ID',
  `name` varchar(64) DEFAULT NULL COMMENT '名称',
  `width` int(11) DEFAULT NULL COMMENT '宽度',
  `height` int(11) DEFAULT NULL COMMENT '高度',
  `description` varchar(255) DEFAULT NULL COMMENT '描述',
  `code` varchar(64) DEFAULT NULL COMMENT '代码简称',
  `template` text COMMENT '模版内容',
  `defult_number` int(11) DEFAULT '0' COMMENT '默认显示个数',
  `number` int(11) DEFAULT '0' COMMENT '广告数量',
  `status` tinyint(2) DEFAULT '0' COMMENT '状态 1=显示/0=隐藏',
  `type` tinyint(4) DEFAULT NULL COMMENT '广告位类型 1=图片/0=文本',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` varchar(64) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '创建者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '更新者',
  PRIMARY KEY (`advert_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='广告位表';

-- ----------------------------
-- Records of advert
-- ----------------------------

-- ----------------------------
-- Table structure for advert_detail
-- ----------------------------
DROP TABLE IF EXISTS `advert_detail`;
CREATE TABLE `advert_detail` (
  `advert_detail_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '广告详情ID',
  `advert_id` bigint(20) DEFAULT NULL COMMENT '广告位ID',
  `title` varchar(64) DEFAULT NULL COMMENT '标题',
  `sort` int(9) DEFAULT NULL COMMENT '排序',
  `href` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '链接地址',
  `status` tinyint(2) DEFAULT NULL COMMENT '状态 1=显示/0=隐藏',
  `pic_img` varchar(255) DEFAULT NULL COMMENT '展示图片',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` varchar(64) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '创建者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '更新者',
  `remarks` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '备注信息',
  `begin_time` datetime DEFAULT NULL COMMENT '广告起始时间',
  `end_time` datetime DEFAULT NULL COMMENT '广告结束时间',
  `content` varchar(255) DEFAULT NULL COMMENT '广告内容',
  PRIMARY KEY (`advert_detail_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='广告位管理表';

-- ----------------------------
-- Records of advert_detail
-- ----------------------------

-- ----------------------------
-- Table structure for base_information
-- ----------------------------
DROP TABLE IF EXISTS `base_information`;
CREATE TABLE `base_information` (
  `base_info_id` bigint(20) NOT NULL COMMENT '基本信息ID',
  `mem_id` bigint(20) NOT NULL COMMENT '会员用户ID',
  `version` int(11) NOT NULL,
  `bit_state` bigint(20) NOT NULL COMMENT '位状态',
  `real_name` varchar(30) DEFAULT NULL COMMENT '真实姓名',
  `sex` int(1) DEFAULT NULL COMMENT '性别 0=女/1=男',
  `email` varchar(50) DEFAULT NULL COMMENT '电子邮箱',
  `score` int(11) NOT NULL COMMENT '用户当前的认证分数',
  `real_auth_id` bigint(20) DEFAULT NULL COMMENT '用户有效的实名认证id',
  `id_number` varchar(30) DEFAULT NULL COMMENT '身份证号',
  `phone_number` varchar(30) DEFAULT NULL COMMENT '手机号',
  `income_grade_id` bigint(20) DEFAULT NULL COMMENT '数据字典中的月收入id',
  `marriage_id` bigint(20) DEFAULT NULL COMMENT '数据字典中的婚烟情况id',
  `kid_count_id` bigint(20) DEFAULT NULL COMMENT '数据字典中的子女情况id',
  `education_id` bigint(20) DEFAULT NULL COMMENT '数据字典中的学历id',
  `house_condition_id` bigint(20) DEFAULT NULL COMMENT '数据字典中的住房条件id',
  PRIMARY KEY (`base_info_id`),
  KEY `fk_mem_id` (`mem_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of base_information
-- ----------------------------

-- ----------------------------
-- Table structure for bid
-- ----------------------------
DROP TABLE IF EXISTS `bid`;
CREATE TABLE `bid` (
  `bid_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '投标的id',
  `actual_rate` decimal(8,4) NOT NULL COMMENT '实际年利率',
  `available_amount` decimal(18,4) NOT NULL COMMENT '投标有效金额',
  `bid_request_id` bigint(20) NOT NULL COMMENT '借款标ID',
  `bid_user_id` bigint(20) NOT NULL COMMENT '投标人ID',
  `bid_time` datetime NOT NULL COMMENT '投标时间',
  `bid_request_title` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`bid_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='投标记录表';

-- ----------------------------
-- Records of bid
-- ----------------------------
INSERT INTO `bid` VALUES ('1', '8.0000', '4000.0000', '1', '3', '2017-04-30 18:42:09', '我要娶媳妇');
INSERT INTO `bid` VALUES ('2', '8.0000', '1000.0000', '1', '3', '2017-04-30 18:42:44', '我要娶媳妇');
INSERT INTO `bid` VALUES ('3', '19.0000', '2500.0000', '2', '1', '2017-05-01 15:51:31', '借钱去相亲');
INSERT INTO `bid` VALUES ('4', '19.0000', '2500.0000', '2', '3', '2017-05-01 15:52:21', '借钱去相亲');
INSERT INTO `bid` VALUES ('5', '5.0000', '1000.0000', '4', '1', '2017-05-03 21:12:45', '借款标测试');
INSERT INTO `bid` VALUES ('6', '5.0000', '2000.0000', '5', '1', '2017-05-03 22:10:56', '借款测试7');

-- ----------------------------
-- Table structure for bid_request
-- ----------------------------
DROP TABLE IF EXISTS `bid_request`;
CREATE TABLE `bid_request` (
  `bid_request_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '借款标ID',
  `version` int(11) NOT NULL COMMENT '版本',
  `return_type` int(11) NOT NULL COMMENT '还款方式',
  `bid_request_type` tinyint(4) NOT NULL COMMENT '标的类型',
  `bid_request_state` tinyint(4) NOT NULL COMMENT '标的状态',
  `bid_request_amount` decimal(18,4) NOT NULL COMMENT '借款金额',
  `current_rate` decimal(8,4) NOT NULL COMMENT '借款利率',
  `monthes2_return` tinyint(4) NOT NULL COMMENT '借款期限(1-12）',
  `bid_count` int(11) NOT NULL COMMENT '已有投标数量',
  `total_reward_amount` decimal(18,4) NOT NULL COMMENT '总利息',
  `current_sum` decimal(18,4) NOT NULL COMMENT '当前收到的投资总额',
  `title` varchar(255) NOT NULL COMMENT '借款标题',
  `description` varchar(255) NOT NULL COMMENT '借款描述',
  `note` varchar(255) DEFAULT NULL COMMENT '贷款风控信息',
  `disable_date` datetime DEFAULT NULL COMMENT '投标截止日期',
  `createuser_id` bigint(20) NOT NULL,
  `disable_days` tinyint(4) NOT NULL COMMENT '发标时间天数',
  `min_did_amount` decimal(18,4) NOT NULL COMMENT '最小投标金额',
  `apply_time` datetime DEFAULT NULL COMMENT '申请时间',
  `publish_time` datetime DEFAULT NULL COMMENT '发布时间',
  PRIMARY KEY (`bid_request_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='借款标表';

-- ----------------------------
-- Records of bid_request
-- ----------------------------
INSERT INTO `bid_request` VALUES ('1', '6', '1', '0', '8', '5000.0000', '8.0000', '1', '2', '33.3334', '5000.0000', '我要娶媳妇', '借钱娶媳妇', '通过', '2017-05-05 16:10:54', '1', '5', '100.0000', '2017-04-30 16:05:16', '2017-04-30 16:10:54');
INSERT INTO `bid_request` VALUES ('2', '6', '0', '0', '8', '5000.0000', '19.0000', '1', '2', '79.1667', '5000.0000', '借钱去相亲', '的点点滴滴', '发布', '2017-05-02 15:49:18', '4', '1', '100.0000', '2017-05-01 15:42:58', '2017-05-01 15:49:18');
INSERT INTO `bid_request` VALUES ('3', '1', '0', '0', '1', '5000.0000', '5.0000', '1', '0', '20.8334', '0.0000', '借款测试', '借款测试借款测试借款测试借款测试借款测试', '挺好的', '2017-05-05 18:46:36', '4', '2', '100.0000', '2017-05-03 18:46:05', '2017-05-03 18:46:36');
INSERT INTO `bid_request` VALUES ('4', '4', '1', '0', '7', '1000.0000', '5.0000', '4', '1', '16.6668', '1000.0000', '借款标测试', '借款标测试描述。借款标测试描述', '', '2017-05-04 21:11:06', '4', '1', '100.0000', '2017-05-03 21:07:14', '2017-05-03 21:11:06');
INSERT INTO `bid_request` VALUES ('5', '5', '1', '0', '8', '2000.0000', '5.0000', '2', '1', '16.6666', '2000.0000', '借款测试7', '借款测试7', '', '2017-05-04 22:06:14', '8', '1', '100.0000', '2017-05-03 21:59:17', '2017-05-03 22:06:14');

-- ----------------------------
-- Table structure for bid_request_audit_history
-- ----------------------------
DROP TABLE IF EXISTS `bid_request_audit_history`;
CREATE TABLE `bid_request_audit_history` (
  `bid_request_audit_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '标审核记录ID',
  `state` tinyint(4) NOT NULL COMMENT '状态 0=审请状态/1=审核通过/2=审核拒绝',
  `remark` varchar(255) DEFAULT NULL COMMENT '审核备注',
  `apply_time` datetime NOT NULL COMMENT '申请时间',
  `audit_time` datetime DEFAULT NULL COMMENT '审核时间',
  `applier_id` bigint(20) NOT NULL COMMENT '申请人ID',
  `auditor_id` bigint(20) DEFAULT NULL COMMENT '审核人ID',
  `bid_request_id` bigint(20) NOT NULL COMMENT '审核标ID',
  `audit_type` tinyint(4) NOT NULL COMMENT '审核的类型 0=发标前审核/1=满标一审/2=满标二审',
  PRIMARY KEY (`bid_request_audit_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='标审核记录表';

-- ----------------------------
-- Records of bid_request_audit_history
-- ----------------------------
INSERT INTO `bid_request_audit_history` VALUES ('1', '1', '通过', '2017-04-30 16:05:16', '2017-04-30 16:10:54', '1', '2', '1', '0');
INSERT INTO `bid_request_audit_history` VALUES ('2', '1', '通过', '2017-04-30 18:43:27', '2017-04-30 18:43:27', '1', '2', '1', '1');
INSERT INTO `bid_request_audit_history` VALUES ('5', '1', '的点点滴滴多多多多多多多多多', '2017-04-30 18:52:40', '2017-04-30 18:52:40', '1', '2', '1', '2');
INSERT INTO `bid_request_audit_history` VALUES ('6', '1', '发布', '2017-05-01 15:42:58', '2017-05-01 15:49:18', '4', '2', '2', '0');
INSERT INTO `bid_request_audit_history` VALUES ('7', '1', '', '2017-05-01 15:52:48', '2017-05-01 15:52:48', '4', '2', '2', '1');
INSERT INTO `bid_request_audit_history` VALUES ('8', '1', '', '2017-05-01 15:52:59', '2017-05-01 15:52:59', '4', '2', '2', '2');
INSERT INTO `bid_request_audit_history` VALUES ('9', '1', '挺好的', '2017-05-03 18:46:05', '2017-05-03 18:46:36', '4', '2', '3', '0');
INSERT INTO `bid_request_audit_history` VALUES ('10', '1', '', '2017-05-03 21:07:14', '2017-05-03 21:11:06', '4', '2', '4', '0');
INSERT INTO `bid_request_audit_history` VALUES ('11', '1', '的点点滴滴订单', '2017-05-03 21:15:47', '2017-05-03 21:15:47', '4', '2', '4', '1');
INSERT INTO `bid_request_audit_history` VALUES ('12', '1', '', '2017-05-03 21:16:40', '2017-05-03 21:16:40', '4', '2', '4', '2');
INSERT INTO `bid_request_audit_history` VALUES ('13', '1', '', '2017-05-03 21:59:17', '2017-05-03 22:06:14', '8', '2', '5', '0');
INSERT INTO `bid_request_audit_history` VALUES ('14', '1', '', '2017-05-03 22:13:46', '2017-05-03 22:13:46', '8', '2', '5', '1');
INSERT INTO `bid_request_audit_history` VALUES ('15', '1', '', '2017-05-03 22:13:52', '2017-05-03 22:13:52', '8', '2', '5', '2');

-- ----------------------------
-- Table structure for email
-- ----------------------------
DROP TABLE IF EXISTS `email`;
CREATE TABLE `email` (
  `email_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '邮箱ID',
  `email_sign` bigint(20) unsigned DEFAULT NULL COMMENT '邮箱标识号',
  `user_email` varchar(50) DEFAULT NULL COMMENT '用户邮箱',
  `email_type` tinyint(4) DEFAULT NULL COMMENT '邮件类型：0.找回密码；1.注册；2.改变邮箱；3.通知',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `start_time` datetime DEFAULT NULL COMMENT '有效开始时间',
  `end_time` datetime DEFAULT NULL COMMENT '有效结束时间',
  `new_email` varchar(50) DEFAULT NULL COMMENT '新电子邮箱',
  `status` tinyint(1) DEFAULT '1' COMMENT '链接是否已失效：0.失效；1.未失效；',
  `send_status` tinyint(1) DEFAULT NULL COMMENT '发送状态：0.发送失败；1.发送成功；',
  `captcha` varchar(10) DEFAULT NULL COMMENT '验证码',
  `email_subject` varchar(255) DEFAULT NULL COMMENT '邮件主题',
  `email_content` text COMMENT '邮件正文',
  PRIMARY KEY (`email_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='邮箱记录表';

-- ----------------------------
-- Records of email
-- ----------------------------

-- ----------------------------
-- Table structure for email_active
-- ----------------------------
DROP TABLE IF EXISTS `email_active`;
CREATE TABLE `email_active` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `mem_id` bigint(20) NOT NULL COMMENT '会员ID',
  `send_time` datetime NOT NULL COMMENT '发送时间',
  `captcha` varchar(255) NOT NULL COMMENT '发送的激活url的验证码',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='邮箱认证表';

-- ----------------------------
-- Records of email_active
-- ----------------------------

-- ----------------------------
-- Table structure for member
-- ----------------------------
DROP TABLE IF EXISTS `member`;
CREATE TABLE `member` (
  `mem_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(50) DEFAULT NULL COMMENT '用户名',
  `password` varchar(32) DEFAULT NULL COMMENT '密码',
  `salt` varchar(20) DEFAULT NULL COMMENT '加密的盐',
  `status` int(1) DEFAULT '1' COMMENT '状态 0=冻结/1=正常',
  `regist_time` datetime DEFAULT NULL COMMENT '注册时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `last_login_time` datetime DEFAULT NULL COMMENT '上次登录时间',
  `last_login_ip` varchar(20) DEFAULT NULL COMMENT '上次登录IP',
  `phone_number` varchar(30) DEFAULT NULL COMMENT '手机号',
  PRIMARY KEY (`mem_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='会员用户表';

-- ----------------------------
-- Records of member
-- ----------------------------

-- ----------------------------
-- Table structure for member_login_log
-- ----------------------------
DROP TABLE IF EXISTS `member_login_log`;
CREATE TABLE `member_login_log` (
  `log_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '登录日志ID',
  `login_time` datetime DEFAULT NULL COMMENT '登录时间',
  `mem_ip` varchar(20) DEFAULT NULL COMMENT '登录IP',
  `mem_id` bigint(20) DEFAULT NULL COMMENT '用户ID',
  `member_status` int(1) DEFAULT NULL COMMENT '用户登录状态 0=冻结/1=正常',
  `operating_system` varchar(50) DEFAULT NULL COMMENT '操作系统',
  `browser` varchar(50) DEFAULT NULL COMMENT '浏览器',
  PRIMARY KEY (`log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户登录日志表';

-- ----------------------------
-- Records of member_login_log
-- ----------------------------

-- ----------------------------
-- Table structure for money_withdraw
-- ----------------------------
DROP TABLE IF EXISTS `money_withdraw`;
CREATE TABLE `money_withdraw` (
  `mw_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '提现记录ID',
  `state` tinyint(4) NOT NULL COMMENT '状态 0=审请状态/1=审核通过/2=审核拒绝',
  `remark` varchar(255) DEFAULT NULL COMMENT '审核备注',
  `applyTime` datetime NOT NULL COMMENT '申请时间',
  `audit_time` datetime DEFAULT NULL COMMENT '审核时间',
  `applier_id` bigint(20) NOT NULL COMMENT '申请人ID',
  `auditor_id` bigint(20) DEFAULT NULL COMMENT '审核人ID',
  `amount` decimal(18,4) DEFAULT NULL COMMENT '真实提现金额',
  `fee` decimal(18,4) DEFAULT NULL COMMENT '手续费',
  `bank_name` varchar(50) DEFAULT NULL COMMENT '银行名称',
  `account_name` varchar(50) DEFAULT NULL COMMENT '开户人姓名',
  `account_number` varchar(50) DEFAULT NULL COMMENT '开户人姓名',
  `fork_name` varchar(50) DEFAULT NULL COMMENT '开户支行',
  PRIMARY KEY (`mw_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='提现记录表';

-- ----------------------------
-- Records of money_withdraw
-- ----------------------------
INSERT INTO `money_withdraw` VALUES ('1', '1', '', '2017-04-30 19:24:35', '2017-04-30 19:24:44', '3', '2', '12000.0000', '2.0000', '1', '张思', '2017-04-30 19:24:35', '方法');

-- ----------------------------
-- Table structure for navigation
-- ----------------------------
DROP TABLE IF EXISTS `navigation`;
CREATE TABLE `navigation` (
  `navigation_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '导航ID',
  `code` varchar(64) DEFAULT NULL COMMENT '代码简称',
  `name` varchar(64) DEFAULT NULL COMMENT '名称',
  `status` tinyint(2) DEFAULT '1' COMMENT '状态 1=显示/0=隐藏',
  `number` int(11) DEFAULT NULL COMMENT '数量',
  `show_number` int(11) DEFAULT NULL COMMENT '显示数量',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` varchar(64) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '创建者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '更新者',
  `remarks` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '备注信息',
  PRIMARY KEY (`navigation_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='导航表';

-- ----------------------------
-- Records of navigation
-- ----------------------------

-- ----------------------------
-- Table structure for navigation_bar
-- ----------------------------
DROP TABLE IF EXISTS `navigation_bar`;
CREATE TABLE `navigation_bar` (
  `navigation_bar_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '导航栏ID',
  `navigation_id` bigint(20) unsigned DEFAULT NULL COMMENT '导航ID',
  `name` varchar(64) DEFAULT NULL COMMENT '名称',
  `target` varchar(64) DEFAULT '_blank' COMMENT '打开方式：_blank；_parent；_self；_top',
  `sort` int(9) DEFAULT NULL COMMENT '排序',
  `href` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '链接地址',
  `status` tinyint(2) DEFAULT '1' COMMENT '状态 1=显示/0=隐藏',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` varchar(64) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '创建者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '更新者',
  `remarks` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '备注信息',
  PRIMARY KEY (`navigation_bar_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='导航栏表';

-- ----------------------------
-- Records of navigation_bar
-- ----------------------------

-- ----------------------------
-- Table structure for payment_schedule
-- ----------------------------
DROP TABLE IF EXISTS `payment_schedule`;
CREATE TABLE `payment_schedule` (
  `ps_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `dead_line` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '本期还款截止期限',
  `pay_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '还款时间',
  `total_amount` decimal(18,4) DEFAULT NULL COMMENT '本期还款总金额',
  `principal` decimal(18,4) DEFAULT NULL COMMENT '本期还款本金',
  `interest` decimal(18,4) DEFAULT NULL COMMENT '本期还款总利息',
  `month_index` decimal(18,4) DEFAULT NULL COMMENT '第几期 (即第几个月)',
  `state` int(11) DEFAULT NULL COMMENT '本期还款状态（默认正常待还）',
  `bid_request_type` int(11) DEFAULT NULL COMMENT '借款类型',
  `return_type` int(11) DEFAULT NULL COMMENT '还款方式，等同借款(BidRequest)中的还款方式',
  `bid_request_title` varchar(255) DEFAULT NULL COMMENT '借款标题',
  `borrow_user_id` bigint(20) DEFAULT NULL COMMENT '还款人ID',
  `bid_request_id` bigint(20) DEFAULT NULL COMMENT '借款标ID',
  PRIMARY KEY (`ps_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='还款计划表';

-- ----------------------------
-- Records of payment_schedule
-- ----------------------------
INSERT INTO `payment_schedule` VALUES ('3', '2017-05-30 16:05:16', '2017-04-30 19:07:29', '5033.3334', '5000.0000', '33.3334', '1.0000', '1', '0', '1', '我要娶媳妇', '1', '1');
INSERT INTO `payment_schedule` VALUES ('4', '2017-06-01 15:42:58', '2017-05-03 18:44:39', '5079.1667', '5000.0000', '79.1667', '1.0000', '1', '0', '0', '借钱去相亲', '4', '2');
INSERT INTO `payment_schedule` VALUES ('5', '2017-06-03 21:07:14', '2017-05-03 21:16:40', '4.1667', '0.0000', '4.1667', '1.0000', '0', '0', '1', '借款标测试', '4', '4');
INSERT INTO `payment_schedule` VALUES ('6', '2017-07-03 21:07:14', '2017-05-03 21:16:40', '4.1667', '0.0000', '4.1667', '2.0000', '0', '0', '1', '借款标测试', '4', '4');
INSERT INTO `payment_schedule` VALUES ('7', '2017-08-03 21:07:14', '2017-05-03 21:16:40', '4.1667', '0.0000', '4.1667', '3.0000', '0', '0', '1', '借款标测试', '4', '4');
INSERT INTO `payment_schedule` VALUES ('8', '2017-09-03 21:07:14', '2017-05-03 21:16:40', '1016.6668', '1000.0000', '16.6668', '4.0000', '0', '0', '1', '借款标测试', '4', '4');
INSERT INTO `payment_schedule` VALUES ('9', '2017-06-03 21:59:17', '2017-05-03 22:18:18', '8.3333', '0.0000', '8.3333', '1.0000', '1', '0', '1', '借款测试7', '8', '5');
INSERT INTO `payment_schedule` VALUES ('10', '2017-07-03 21:59:17', '2017-05-03 22:19:14', '2016.6666', '2000.0000', '16.6666', '2.0000', '1', '0', '1', '借款测试7', '8', '5');

-- ----------------------------
-- Table structure for payment_schedule_detail
-- ----------------------------
DROP TABLE IF EXISTS `payment_schedule_detail`;
CREATE TABLE `payment_schedule_detail` (
  `psd_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '投资人的回款明细ID',
  `bid_amount` decimal(18,4) DEFAULT NULL COMMENT '投标人总共投标金额',
  `bid_id` bigint(20) DEFAULT NULL COMMENT '投标的ID',
  `total_amount` decimal(18,4) DEFAULT NULL COMMENT '本期还款总金额(=本金+利息)',
  `principal` decimal(18,4) DEFAULT NULL COMMENT '本期应还款本金',
  `interest` decimal(18,4) DEFAULT NULL COMMENT '本期应还款利息',
  `month_index` int(11) DEFAULT NULL COMMENT '第几期（即第几个月）',
  `dead_line` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '本期还款截止时间',
  `bidrequest_id` bigint(20) NOT NULL COMMENT '借款标ID',
  `pay_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '实际付款日期',
  `return_type` int(11) DEFAULT NULL COMMENT '还款方式',
  `payment_schedule_id` bigint(20) NOT NULL COMMENT '所属还款计划ID',
  `fromMember_id` bigint(20) NOT NULL COMMENT '还款人(即发标人)ID',
  `toMember_id` bigint(20) NOT NULL COMMENT '收款人(即投标人)',
  PRIMARY KEY (`psd_id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='投资人的回款明细表';

-- ----------------------------
-- Records of payment_schedule_detail
-- ----------------------------
INSERT INTO `payment_schedule_detail` VALUES ('1', '4000.0000', '1', '4026.6667', '4000.0000', '26.6667', '1', '2017-05-30 16:05:16', '1', '2017-04-30 19:07:29', '1', '3', '1', '3');
INSERT INTO `payment_schedule_detail` VALUES ('2', '1000.0000', '2', '1006.6667', '1000.0000', '6.6667', '1', '2017-05-30 16:05:16', '1', '2017-04-30 19:07:29', '1', '3', '1', '3');
INSERT INTO `payment_schedule_detail` VALUES ('3', '2500.0000', '3', '2539.5834', '2500.0000', '39.5834', '1', '2017-06-01 15:42:58', '2', '2017-05-03 18:44:39', '0', '4', '4', '1');
INSERT INTO `payment_schedule_detail` VALUES ('4', '2500.0000', '4', '2539.5833', '2500.0000', '39.5833', '1', '2017-06-01 15:42:58', '2', '2017-05-03 18:44:39', '0', '4', '4', '3');
INSERT INTO `payment_schedule_detail` VALUES ('5', '1000.0000', '5', '4.1667', '0.0000', '4.1667', '1', '2017-06-03 21:07:14', '4', '2017-05-03 21:16:40', '1', '5', '4', '1');
INSERT INTO `payment_schedule_detail` VALUES ('6', '1000.0000', '5', '4.1667', '0.0000', '4.1667', '2', '2017-07-03 21:07:14', '4', '2017-05-03 21:16:40', '1', '6', '4', '1');
INSERT INTO `payment_schedule_detail` VALUES ('7', '1000.0000', '5', '4.1667', '0.0000', '4.1667', '3', '2017-08-03 21:07:14', '4', '2017-05-03 21:16:40', '1', '7', '4', '1');
INSERT INTO `payment_schedule_detail` VALUES ('8', '1000.0000', '5', '1016.6668', '1000.0000', '16.6668', '4', '2017-09-03 21:07:14', '4', '2017-05-03 21:16:40', '1', '8', '4', '1');
INSERT INTO `payment_schedule_detail` VALUES ('9', '2000.0000', '6', '8.3333', '0.0000', '8.3333', '1', '2017-06-03 21:59:17', '5', '2017-05-03 22:18:18', '1', '9', '8', '1');
INSERT INTO `payment_schedule_detail` VALUES ('10', '2000.0000', '6', '2016.6666', '2000.0000', '16.6666', '2', '2017-07-03 21:59:17', '5', '2017-05-03 22:19:14', '1', '10', '8', '1');

-- ----------------------------
-- Table structure for platform_account
-- ----------------------------
DROP TABLE IF EXISTS `platform_account`;
CREATE TABLE `platform_account` (
  `sys_account_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '平台账户ID',
  `version` int(11) DEFAULT NULL COMMENT '版本',
  `usable_amount` decimal(18,4) DEFAULT NULL COMMENT '平台账户剩余金额',
  `freezed_amount` decimal(18,4) DEFAULT NULL COMMENT '平台账户冻结金额',
  PRIMARY KEY (`sys_account_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='平台账户';

-- ----------------------------
-- Records of platform_account
-- ----------------------------
INSERT INTO `platform_account` VALUES ('1', '13', '0.8333', '0.0000');

-- ----------------------------
-- Table structure for platform_account_flow
-- ----------------------------
DROP TABLE IF EXISTS `platform_account_flow`;
CREATE TABLE `platform_account_flow` (
  `saf_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '平台账户流水ID',
  `trade_time` datetime NOT NULL COMMENT '产生流水的时间',
  `action_type` tinyint(4) NOT NULL COMMENT '流水的类型',
  `amount` decimal(18,4) NOT NULL COMMENT '业务金额',
  `usable_amount` decimal(18,4) NOT NULL COMMENT '操作后的账户金额',
  `freezed_amount` decimal(18,4) NOT NULL COMMENT '操作后的冻结金额',
  `note` varchar(200) DEFAULT NULL COMMENT '流水说明',
  PRIMARY KEY (`saf_id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='平台账户流水表';

-- ----------------------------
-- Records of platform_account_flow
-- ----------------------------
INSERT INTO `platform_account_flow` VALUES ('1', '2017-04-30 18:43:38', '1', '250.0000', '250.0000', '0.0000', '贷款:我要娶媳妇成功,收取手续费250.00000000');
INSERT INTO `platform_account_flow` VALUES ('2', '2017-04-30 18:44:45', '1', '250.0000', '500.0000', '0.0000', '贷款:我要娶媳妇成功,收取手续费250.00000000');
INSERT INTO `platform_account_flow` VALUES ('3', '2017-04-30 18:52:40', '1', '250.0000', '750.0000', '0.0000', '贷款:我要娶媳妇成功,收取手续费250.00000000');
INSERT INTO `platform_account_flow` VALUES ('4', '2017-04-30 19:07:29', '2', '1.3333', '1.3333', '0.0000', '获得利息管理费1.3333');
INSERT INTO `platform_account_flow` VALUES ('5', '2017-04-30 19:07:29', '2', '0.3333', '0.3333', '0.0000', '获得利息管理费0.3333');
INSERT INTO `platform_account_flow` VALUES ('6', '2017-04-30 19:24:44', '3', '2.0000', '2.3333', '0.0000', '收取提现手续费2.0000');
INSERT INTO `platform_account_flow` VALUES ('7', '2017-05-01 15:52:59', '1', '250.0000', '252.3333', '0.0000', '贷款:借钱去相亲成功,收取手续费250.00000000');
INSERT INTO `platform_account_flow` VALUES ('8', '2017-05-03 18:44:39', '2', '1.9792', '1.9792', '0.0000', '获得利息管理费1.9792');
INSERT INTO `platform_account_flow` VALUES ('9', '2017-05-03 18:44:39', '2', '1.9792', '1.9792', '0.0000', '获得利息管理费1.9792');
INSERT INTO `platform_account_flow` VALUES ('10', '2017-05-03 21:16:40', '1', '50.0000', '51.9792', '0.0000', '贷款:借款标测试成功,收取手续费50.00000000');
INSERT INTO `platform_account_flow` VALUES ('11', '2017-05-03 22:13:52', '1', '100.0000', '151.9792', '0.0000', '贷款:借款测试7成功,收取手续费100.00000000');
INSERT INTO `platform_account_flow` VALUES ('12', '2017-05-03 22:18:18', '2', '0.4167', '0.4167', '0.0000', '获得利息管理费0.4167');
INSERT INTO `platform_account_flow` VALUES ('13', '2017-05-03 22:19:14', '2', '0.8333', '0.8333', '0.0000', '获得利息管理费0.8333');

-- ----------------------------
-- Table structure for platform_bank_info
-- ----------------------------
DROP TABLE IF EXISTS `platform_bank_info`;
CREATE TABLE `platform_bank_info` (
  `pbi_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '平台银行账户ID',
  `bank_name` varchar(255) NOT NULL COMMENT '开户银行名称',
  `account_name` varchar(255) NOT NULL COMMENT '开户人姓名',
  `account_number` varchar(255) NOT NULL COMMENT '银行账号',
  `bank_fork_name` varchar(255) DEFAULT NULL COMMENT '开户支行名称',
  `iconCls` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`pbi_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='平台银行账户信息';

-- ----------------------------
-- Records of platform_bank_info
-- ----------------------------

-- ----------------------------
-- Table structure for real_auth
-- ----------------------------
DROP TABLE IF EXISTS `real_auth`;
CREATE TABLE `real_auth` (
  `real_auth_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '实名认证ID',
  `mem_id` bigint(20) NOT NULL COMMENT '会员用户ID',
  `real_name` varchar(50) NOT NULL COMMENT '真实姓名',
  `sex` tinyint(4) NOT NULL COMMENT '性别 0=女/1=男',
  `born_date` varchar(50) DEFAULT NULL COMMENT '出生日期',
  `id_number` varchar(50) NOT NULL COMMENT '身份证号',
  `address` varchar(255) NOT NULL COMMENT '证件住址',
  `state` tinyint(4) NOT NULL COMMENT '状态 0=审请状态/1=审核通过/2=审核拒绝',
  `image1` varchar(255) NOT NULL COMMENT '身份证正面照片',
  `image2` varchar(255) NOT NULL COMMENT '身份证反面照片',
  `remark` varchar(255) DEFAULT NULL COMMENT '审核备注',
  `apply_time` datetime NOT NULL COMMENT '申请时间',
  `audit_time` datetime DEFAULT NULL COMMENT '审核时间',
  `applier_id` bigint(20) NOT NULL COMMENT '申请人ID',
  `auditor_id` bigint(20) DEFAULT NULL COMMENT '审核人ID',
  PRIMARY KEY (`real_auth_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='实名认证表';

-- ----------------------------
-- Records of real_auth
-- ----------------------------
INSERT INTO `real_auth` VALUES ('1', '0', '张三', '0', '2013-10-10', '340824199310105419', '安徽省潜山县五庙乡', '1', '/upload/408a3d5431224b35a2603573cfb58541.jpg', '/upload/d9de0b1dce4e4b8ab20ec67055bb4405.jpg', '通过', '2017-04-30 15:10:07', '2017-04-30 15:25:02', '1', '2');
INSERT INTO `real_auth` VALUES ('2', '0', '张思', '0', '1993-04-30', '340824199310105429', '安徽省潜山县五庙乡', '1', '/upload/d97f29a0110f4d3bb2d5b842da42d1cb.jpg', '/upload/0393319f49c042a6a321dac48951b3e2.jpg', '通过', '2017-04-30 18:25:10', '2017-04-30 18:38:01', '3', '2');
INSERT INTO `real_auth` VALUES ('3', '0', '方玉慧', '1', '1992-05-01', '11000002313123131', '上海师范大学', '1', '/upload/0635df524d3844ddb9f5ae0dce24e164.jpg', '/upload/92b1cdafe432434d86fb3fdb965ec383.jpg', '通过', '2017-05-01 14:17:09', '2017-05-01 14:17:50', '4', '2');
INSERT INTO `real_auth` VALUES ('4', '0', '张三', '0', '2017-05-02', '3444444444', '21111111111111111', '1', '/upload/a0e20a5244bb42ed8d3e198b7115fd18.jpg', '/upload/eedb0656b976416f8d63d127ef700a49.jpg', '', '2017-05-02 13:52:34', '2017-05-02 13:53:03', '5', '2');
INSERT INTO `real_auth` VALUES ('5', '0', '张鼎', '0', '2017-05-03', '34233333333333', '大大大纷纷而非', '2', '/upload/5dae60f23bec4cb8a95cd50383efe13d.jpg', '/upload/e71914a40f1046b6b2bc2ef01d9924b6.jpg', '拒绝！！！', '2017-05-03 19:38:52', '2017-05-03 19:44:19', '6', '2');
INSERT INTO `real_auth` VALUES ('6', '0', '张鼎', '0', '2017-05-03', '23232323232323232323', '3333333333', '1', '/upload/3f5564a15ae9453497e05383e4a28660.jpg', '/upload/4168f20b2ec14bf58e33753554b41b6d.jpg', '', '2017-05-03 20:06:20', '2017-05-03 20:06:35', '6', '2');
INSERT INTO `real_auth` VALUES ('7', '0', '实名', '0', '2005-01-03', '3400000000000000123', '地址地址地址地址地址地址地址', '1', '/upload/b62263c093b645439c3cb7e635f548e6.jpg', '/upload/a1bc32a4cfa342d8a568f6d3005eba61.jpg', '', '2017-05-03 20:26:46', '2017-05-03 21:35:22', '7', '2');
INSERT INTO `real_auth` VALUES ('8', '0', '张定水', '1', '2012-05-02', '3444444444', '安徽省潜山县五庙乡', '1', '/upload/f9101e413be642459712c0990d494d80.jpg', '/upload/5de97c6f339e48d2a90a5335476b6a7f.jpg', '', '2017-05-03 21:35:10', '2017-05-03 21:35:26', '8', '2');

-- ----------------------------
-- Table structure for recharge_money
-- ----------------------------
DROP TABLE IF EXISTS `recharge_money`;
CREATE TABLE `recharge_money` (
  `rm_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '充值ID',
  `state` tinyint(4) NOT NULL COMMENT '状态 0=审请状态/1=审核通过/2=审核拒绝',
  `remark` varchar(255) DEFAULT NULL COMMENT '审核备注',
  `audit_time` datetime DEFAULT NULL COMMENT '审核时间',
  `apply_time` datetime NOT NULL COMMENT '申请时间',
  `auditor_id` bigint(20) DEFAULT NULL COMMENT '审核人ID',
  `applier_id` bigint(20) NOT NULL COMMENT '申请人ID',
  `trade_code` varchar(255) NOT NULL COMMENT '交易码',
  `trade_time` datetime NOT NULL COMMENT '交易时间',
  `amount` decimal(18,4) NOT NULL COMMENT '交易金额',
  `bankinfo_id` bigint(20) NOT NULL COMMENT '平台银行账户',
  PRIMARY KEY (`rm_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='充值表';

-- ----------------------------
-- Records of recharge_money
-- ----------------------------
INSERT INTO `recharge_money` VALUES ('1', '1', '到账', '2017-04-30 15:27:30', '2017-04-30 15:27:09', '2', '1', '20170430213333333', '2017-04-30 00:00:00', '1000000.0000', '1');
INSERT INTO `recharge_money` VALUES ('2', '1', '的点点滴滴', '2017-04-30 18:39:02', '2017-04-30 18:38:48', '2', '3', '6222222222222', '2017-04-30 00:00:00', '12333333.0000', '1');
INSERT INTO `recharge_money` VALUES ('3', '1', '', '2017-05-03 18:44:26', '2017-05-03 18:44:03', '2', '4', '1233333333333', '2017-05-03 00:00:00', '100000.0000', '1');
INSERT INTO `recharge_money` VALUES ('4', '1', 'dd', '2017-05-03 22:18:54', '2017-05-03 22:18:39', '2', '8', '123131313123', '2017-05-03 00:00:00', '1000.0000', '1');

-- ----------------------------
-- Table structure for sys_dictionary
-- ----------------------------
DROP TABLE IF EXISTS `sys_dictionary`;
CREATE TABLE `sys_dictionary` (
  `sys_dict_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据字典ID',
  `sn` varchar(50) NOT NULL COMMENT '编码',
  `title` varchar(50) NOT NULL COMMENT '名称',
  `intro` varchar(255) DEFAULT NULL COMMENT '简介',
  PRIMARY KEY (`sys_dict_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='数据字典表';

-- ----------------------------
-- Records of sys_dictionary
-- ----------------------------
INSERT INTO `sys_dictionary` VALUES ('1', 'test01', '测试', null);
INSERT INTO `sys_dictionary` VALUES ('2', 'houseCondition', '住房条件', 'houseCondition');
INSERT INTO `sys_dictionary` VALUES ('3', 'kidCount', '子女情况', 'kidCount');
INSERT INTO `sys_dictionary` VALUES ('4', 'marriage', '婚姻情况', null);
INSERT INTO `sys_dictionary` VALUES ('5', 'incomeGrade', '月收入', null);
INSERT INTO `sys_dictionary` VALUES ('6', 'educationBackground', '个人学历', null);
INSERT INTO `sys_dictionary` VALUES ('7', 'fileType', '文件类型', null);

-- ----------------------------
-- Table structure for sys_dictionary_item
-- ----------------------------
DROP TABLE IF EXISTS `sys_dictionary_item`;
CREATE TABLE `sys_dictionary_item` (
  `sys_dict_item_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据字典项ID',
  `parent_id` bigint(20) NOT NULL COMMENT '数据字典ID',
  `title` varchar(50) NOT NULL COMMENT '名称',
  `tvalue` varchar(50) DEFAULT NULL COMMENT '值',
  `sequence` tinyint(4) NOT NULL COMMENT '序列',
  `intro` varchar(255) DEFAULT NULL COMMENT '说明',
  PRIMARY KEY (`sys_dict_item_id`)
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COMMENT='数据字典项表';

-- ----------------------------
-- Records of sys_dictionary_item
-- ----------------------------
INSERT INTO `sys_dictionary_item` VALUES ('1', '1', '1', null, '1', null);
INSERT INTO `sys_dictionary_item` VALUES ('2', '1', '123', null, '2', null);
INSERT INTO `sys_dictionary_item` VALUES ('3', '6', '本科以下', null, '1', null);
INSERT INTO `sys_dictionary_item` VALUES ('4', '6', '本科', null, '2', null);
INSERT INTO `sys_dictionary_item` VALUES ('5', '6', '硕士', null, '3', null);
INSERT INTO `sys_dictionary_item` VALUES ('6', '6', '博士', null, '4', null);
INSERT INTO `sys_dictionary_item` VALUES ('7', '6', '其他', null, '5', null);
INSERT INTO `sys_dictionary_item` VALUES ('8', '5', '1000以下', null, '1', null);
INSERT INTO `sys_dictionary_item` VALUES ('9', '5', '1000-3000', null, '2', null);
INSERT INTO `sys_dictionary_item` VALUES ('10', '5', '3001-5000', null, '3', null);
INSERT INTO `sys_dictionary_item` VALUES ('11', '5', '5001-7000', null, '4', null);
INSERT INTO `sys_dictionary_item` VALUES ('12', '5', '7000以上', null, '5', null);
INSERT INTO `sys_dictionary_item` VALUES ('13', '4', '未婚', null, '1', null);
INSERT INTO `sys_dictionary_item` VALUES ('14', '4', '已婚', null, '2', null);
INSERT INTO `sys_dictionary_item` VALUES ('15', '3', '未生育', null, '1', null);
INSERT INTO `sys_dictionary_item` VALUES ('16', '3', '一孩', null, '2', null);
INSERT INTO `sys_dictionary_item` VALUES ('17', '3', '二孩', null, '3', null);
INSERT INTO `sys_dictionary_item` VALUES ('18', '3', '三孩', null, '4', null);
INSERT INTO `sys_dictionary_item` VALUES ('19', '3', '三孩以上', null, '5', null);
INSERT INTO `sys_dictionary_item` VALUES ('20', '2', '无房产', null, '1', null);
INSERT INTO `sys_dictionary_item` VALUES ('21', '2', '一套房产', null, '2', null);
INSERT INTO `sys_dictionary_item` VALUES ('22', '2', '两套房产', null, '3', null);
INSERT INTO `sys_dictionary_item` VALUES ('23', '2', '三套及以上', null, '4', null);
INSERT INTO `sys_dictionary_item` VALUES ('24', '2', '--请选择--', null, '0', null);
INSERT INTO `sys_dictionary_item` VALUES ('25', '3', '--请选择--', null, '0', null);
INSERT INTO `sys_dictionary_item` VALUES ('26', '4', '--请选择--', null, '0', null);
INSERT INTO `sys_dictionary_item` VALUES ('27', '5', '--请选择--', null, '0', null);
INSERT INTO `sys_dictionary_item` VALUES ('28', '6', '--请选择--', null, '0', null);
INSERT INTO `sys_dictionary_item` VALUES ('29', '7', '证件类', null, '1', null);
INSERT INTO `sys_dictionary_item` VALUES ('30', '7', '实物图', null, '2', null);

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
  `log_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  `user_id` bigint(20) unsigned DEFAULT NULL COMMENT '管理员ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `spend_time` int(11) DEFAULT NULL COMMENT '耗时',
  `method` varchar(64) DEFAULT NULL COMMENT '请求类型',
  `user_agent` varchar(255) DEFAULT NULL COMMENT '用户标识',
  `user_ip` varchar(64) DEFAULT NULL COMMENT '用户IP',
  `opt_content` text COMMENT '请求内容',
  `url` varchar(255) DEFAULT NULL COMMENT '请求路径',
  PRIMARY KEY (`log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='日志记录表';

-- ----------------------------
-- Records of sys_log
-- ----------------------------

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `menu_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '权限ID',
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父级编号',
  `menu_type` tinyint(2) DEFAULT NULL COMMENT '权限类型 1=菜单/2=功能/3=子功能/0=操作',
  `menu_code` varchar(64) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '权限代码',
  `menu_name` varchar(64) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '权限名称',
  `sort` int(9) DEFAULT NULL COMMENT '排序',
  `href` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '链接地址',
  `icon` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '图标名称',
  `status` tinyint(2) DEFAULT NULL COMMENT '状态 0=隐藏/1=显示',
  `permission` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '权限标识',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` varchar(64) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '创建者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '更新者',
  `remarks` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '备注信息',
  PRIMARY KEY (`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='权限表';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------

-- ----------------------------
-- Table structure for sys_organization
-- ----------------------------
DROP TABLE IF EXISTS `sys_organization`;
CREATE TABLE `sys_organization` (
  `organization_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '组织ID',
  `organization_name` varchar(64) DEFAULT NULL COMMENT '组织名称',
  `is_system` tinyint(2) DEFAULT '1' COMMENT '系统数据 1=是,只有超级管理员能修改/0=否,拥有角色修改人员的权限能都修改',
  `status` tinyint(2) DEFAULT '1' COMMENT '状态 0=冻结/1=正常',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` varchar(64) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '创建者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '更新者',
  `remarks` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '备注信息',
  PRIMARY KEY (`organization_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='组织表';

-- ----------------------------
-- Records of sys_organization
-- ----------------------------

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `role_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `role_name` varchar(64) DEFAULT NULL COMMENT '角色名称',
  `role_sign` varchar(64) DEFAULT NULL COMMENT '角色标志',
  `is_system` tinyint(2) DEFAULT '1' COMMENT '系统数据 1=是,只有超级管理员能修改/0=否,拥有角色修改人员的权限能都修改',
  `status` tinyint(2) DEFAULT '1' COMMENT '状态 0=冻结/1=正常',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` varchar(64) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '创建者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '更新者',
  `remarks` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '备注信息',
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `role_menu_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '角色权限编号',
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色编号',
  `menu_id` bigint(20) DEFAULT NULL COMMENT '权限编号',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` varchar(64) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '创建者',
  PRIMARY KEY (`role_menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色权限关联表';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `user_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '管理员ID',
  `organization_id` bigint(20) DEFAULT NULL COMMENT '组织ID',
  `user_name` varchar(20) DEFAULT '' COMMENT '管理员账号',
  `login_password` varchar(32) DEFAULT '' COMMENT '管理员密码',
  `salt` varchar(20) DEFAULT NULL COMMENT '加密密码的盐',
  `real_name` varchar(64) DEFAULT NULL COMMENT '真实姓名',
  `sex` int(1) DEFAULT '0' COMMENT '性别 0=保密/1=男/2=女',
  `age` tinyint(4) DEFAULT '0' COMMENT '年龄',
  `pic_img` varchar(255) DEFAULT NULL COMMENT '用户头像',
  `status` int(1) DEFAULT '1' COMMENT '状态 0=冻结/1=正常',
  `email` varchar(50) DEFAULT NULL COMMENT '电子邮箱',
  `telephone` varchar(11) DEFAULT NULL COMMENT '手机号码',
  `last_login_time` datetime DEFAULT NULL COMMENT '最后登录时间',
  `last_login_ip` varchar(20) DEFAULT NULL COMMENT '最后登录IP',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` varchar(64) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '创建者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '更新者',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='管理员表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------

-- ----------------------------
-- Table structure for sys_user_login_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_login_log`;
CREATE TABLE `sys_user_login_log` (
  `log_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '登录日志ID',
  `login_time` datetime DEFAULT NULL COMMENT '登录时间',
  `user_status` int(1) DEFAULT '1' COMMENT '用户登录状态 0=冻结/1=正常',
  `user_ip` varchar(20) DEFAULT NULL COMMENT '登录IP',
  `user_name` varchar(20) DEFAULT NULL COMMENT '用户名',
  `operating_system` varchar(50) DEFAULT NULL COMMENT '操作系统',
  `browser` varchar(50) DEFAULT NULL COMMENT '浏览器',
  PRIMARY KEY (`log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='管理员登陆日志表';

-- ----------------------------
-- Records of sys_user_login_log
-- ----------------------------

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `user_role_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户角色ID',
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_by` varchar(64) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '创建者',
  PRIMARY KEY (`user_role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户角色关联表';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------

-- ----------------------------
-- Table structure for user_bank_info
-- ----------------------------
DROP TABLE IF EXISTS `user_bank_info`;
CREATE TABLE `user_bank_info` (
  `ubi_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '会员银行卡ID',
  `bank_name` varchar(255) NOT NULL COMMENT '银行名称',
  `account_name` varchar(255) NOT NULL COMMENT '开户人姓名',
  `account_number` varchar(255) NOT NULL COMMENT '银行账号',
  `bank_fork_name` varchar(255) DEFAULT NULL COMMENT '开户支行',
  `mem_id` bigint(20) NOT NULL COMMENT '会员用户ID',
  PRIMARY KEY (`ubi_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='会员银行卡表';

-- ----------------------------
-- Records of user_bank_info
-- ----------------------------
INSERT INTO `user_bank_info` VALUES ('1', '4', '张三', '6222222222222', '三峡大学支行', '1');
INSERT INTO `user_bank_info` VALUES ('2', '1', '张思', '6222222222222222', '方法', '3');
INSERT INTO `user_bank_info` VALUES ('3', '1', '张鼎', '1233333333333', '测试题hi', '6');

-- ----------------------------
-- Table structure for user_file
-- ----------------------------
DROP TABLE IF EXISTS `user_file`;
CREATE TABLE `user_file` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `state` tinyint(4) NOT NULL COMMENT '状态 0=审请状态/1=审核通过/2=审核拒绝',
  `remark` varchar(255) DEFAULT NULL COMMENT '审核备注',
  `audit_time` datetime DEFAULT NULL COMMENT '审核时间',
  `apply_time` datetime DEFAULT NULL COMMENT '申请时间',
  `auditor_id` bigint(20) DEFAULT NULL COMMENT '审核人ID',
  `applier_id` bigint(20) DEFAULT NULL COMMENT '申请人ID',
  `score` tinyint(4) DEFAULT NULL COMMENT '材料分数',
  `file` varchar(255) DEFAULT NULL COMMENT '材料文件地址',
  `filetype_id` bigint(20) DEFAULT NULL COMMENT '文件类型',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COMMENT='风控材料表';

-- ----------------------------
-- Records of user_file
-- ----------------------------
INSERT INTO `user_file` VALUES ('1', '1', '通过', '2017-04-30 00:00:00', '2017-04-30 00:00:00', '2', '1', '5', null, '29');
INSERT INTO `user_file` VALUES ('2', '1', '', '2017-04-30 00:00:00', '2017-04-30 00:00:00', '2', '1', '5', null, '29');
INSERT INTO `user_file` VALUES ('3', '1', '', '2017-04-30 00:00:00', '2017-04-30 00:00:00', '2', '1', '5', null, '29');
INSERT INTO `user_file` VALUES ('4', '1', '', '2017-04-30 00:00:00', '2017-04-30 00:00:00', '2', '1', '5', null, '29');
INSERT INTO `user_file` VALUES ('5', '1', '', '2017-04-30 00:00:00', '2017-04-30 00:00:00', '2', '1', '5', null, '29');
INSERT INTO `user_file` VALUES ('6', '1', '', '2017-04-30 00:00:00', '2017-04-30 00:00:00', '2', '1', '5', null, '29');
INSERT INTO `user_file` VALUES ('7', '1', '', '2017-05-01 00:00:00', '2017-05-01 00:00:00', '2', '4', '1', null, '30');
INSERT INTO `user_file` VALUES ('8', '1', '', '2017-05-01 00:00:00', '2017-05-01 00:00:00', '2', '4', '1', null, '30');
INSERT INTO `user_file` VALUES ('9', '1', 'd', '2017-05-01 00:00:00', '2017-05-01 00:00:00', '2', '4', '1', null, '29');
INSERT INTO `user_file` VALUES ('10', '1', '的', '2017-05-01 00:00:00', '2017-05-01 00:00:00', '2', '4', '1', null, '29');
INSERT INTO `user_file` VALUES ('11', '1', '的', '2017-05-01 00:00:00', '2017-05-01 00:00:00', '2', '4', '1', null, '29');
INSERT INTO `user_file` VALUES ('12', '1', '', '2017-05-01 00:00:00', '2017-05-01 00:00:00', '2', '4', '1', null, '29');
INSERT INTO `user_file` VALUES ('13', '1', 'a', '2017-05-01 00:00:00', '2017-05-01 00:00:00', '2', '4', '30', null, '29');
INSERT INTO `user_file` VALUES ('14', '1', '', '2017-05-01 00:00:00', '2017-05-01 00:00:00', '2', '4', '30', null, '29');
INSERT INTO `user_file` VALUES ('15', '1', '', '2017-05-01 00:00:00', '2017-05-01 00:00:00', '2', '4', '5', null, '29');
INSERT INTO `user_file` VALUES ('16', '1', '', '2017-05-01 00:00:00', '2017-05-01 00:00:00', '2', '4', '5', null, '29');
INSERT INTO `user_file` VALUES ('17', '1', '', '2017-05-01 00:00:00', '2017-05-01 00:00:00', '2', '4', '5', null, '29');
INSERT INTO `user_file` VALUES ('18', '0', null, null, '2017-05-01 00:00:00', null, '3', '0', null, '29');
INSERT INTO `user_file` VALUES ('19', '0', null, null, null, null, '5', '0', null, null);
INSERT INTO `user_file` VALUES ('20', '1', '通过', '2017-05-03 00:00:00', '2017-05-03 00:00:00', '2', '6', '30', null, '30');
INSERT INTO `user_file` VALUES ('21', '1', '', '2017-05-03 00:00:00', '2017-05-03 00:00:00', '2', '6', '30', null, '29');
INSERT INTO `user_file` VALUES ('22', '1', '', '2017-05-03 00:00:00', '2017-05-03 00:00:00', '2', '6', '30', null, '29');
INSERT INTO `user_file` VALUES ('23', '1', '', '2017-05-03 00:00:00', '2017-05-03 00:00:00', '2', '6', '30', null, '30');
INSERT INTO `user_file` VALUES ('24', '0', null, null, '2017-05-03 00:00:00', null, '7', '0', null, '30');
INSERT INTO `user_file` VALUES ('25', '1', '', '2017-05-03 00:00:00', '2017-05-03 00:00:00', '2', '8', '30', null, '30');

-- ----------------------------
-- Table structure for video_auth
-- ----------------------------
DROP TABLE IF EXISTS `video_auth`;
CREATE TABLE `video_auth` (
  `video_auth_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '视频审核ID',
  `state` tinyint(4) NOT NULL COMMENT '状态 0=审请状态/1=审核通过/2=审核拒绝',
  `remark` varchar(255) DEFAULT NULL COMMENT '审核备注',
  `audit_time` datetime DEFAULT NULL COMMENT '审核时间',
  `apply_time` datetime NOT NULL COMMENT '申请时间',
  `auditor_id` bigint(20) DEFAULT NULL COMMENT '审核人ID',
  `applier_id` bigint(20) NOT NULL COMMENT '申请人ID',
  PRIMARY KEY (`video_auth_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='视频审核标';

-- ----------------------------
-- Records of video_auth
-- ----------------------------
INSERT INTO `video_auth` VALUES ('1', '1', '12313131', '2017-05-01 00:00:00', '2017-05-01 00:00:00', '2', '4');
INSERT INTO `video_auth` VALUES ('2', '1', '', '2017-05-03 00:00:00', '2017-05-03 00:00:00', '2', '1');
INSERT INTO `video_auth` VALUES ('3', '1', '符合', '2017-05-03 00:00:00', '2017-05-03 00:00:00', '2', '8');