登录 注册
开源 企业版 高校版 私有云 Gitee AI NEW
扫描微信二维码支付
取消
支付完成
Watch
不关注 关注所有动态 仅关注版本发行动态 关注但不提醒动态
1 Star 0 Fork 118

CONFL1C7/loan

forked from 冷橘/loan 
代码 Issues 0 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
该仓库未声明开源许可证文件（LICENSE），使用请关注具体项目描述及其代码上游依赖。
项目仓库所选许可证以仓库主分支所使用许可证为准
克隆/下载
srb_core.sql 31.53 KB
一键复制 编辑 原始数据 按行查看 历史
冷橘 提交于 2021-03-31 17:53 . 环境搭建
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485
/*

 Navicat Premium Data Transfer



 Source Server         : localhost

 Source Server Type    : MySQL

 Source Server Version : 50721

 Source Host           : localhost:3306

 Source Schema         : srb_core



 Target Server Type    : MySQL

 Target Server Version : 50721

 File Encoding         : 65001



 Date: 21/03/2021 22:39:29

*/



SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;



-- ----------------------------

-- Table structure for borrow_info

-- ----------------------------

DROP TABLE IF EXISTS `borrow_info`;

CREATE TABLE `borrow_info`  (

  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `user_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '借款用户id',

  `amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '借款金额',

  `period` int(11) NULL DEFAULT NULL COMMENT '借款期限',

  `borrow_year_rate` decimal(10, 2) NULL DEFAULT NULL COMMENT '年化利率',

  `return_method` tinyint(3) NULL DEFAULT NULL COMMENT '还款方式 1-等额本息 2-等额本金 3-每月还息一次还本 4-一次还本',

  `money_use` tinyint(3) NULL DEFAULT NULL COMMENT '资金用途',

  `status` tinyint(3) NOT NULL DEFAULT 0 COMMENT '状态（0：未提交，1：审核中， 2：审核通过， -1：审核不通过）',

  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',

  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

  `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除(1:已删除，0:未删除)',

  PRIMARY KEY (`id`) USING BTREE,

  INDEX `idx_user_id`(`user_id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '借款信息表' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of borrow_info

-- ----------------------------



-- ----------------------------

-- Table structure for borrower

-- ----------------------------

DROP TABLE IF EXISTS `borrower`;

CREATE TABLE `borrower`  (

  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `user_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '用户id',

  `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',

  `id_card` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '身份证号',

  `mobile` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机',

  `sex` tinyint(3) NULL DEFAULT NULL COMMENT '性别（1：男 0：女）',

  `age` tinyint(3) NULL DEFAULT NULL COMMENT '年龄',

  `education` tinyint(3) NULL DEFAULT NULL COMMENT '学历',

  `is_marry` tinyint(1) NULL DEFAULT NULL COMMENT '是否结婚（1：是 0：否）',

  `industry` tinyint(3) NULL DEFAULT NULL COMMENT '行业',

  `income` tinyint(3) NULL DEFAULT NULL COMMENT '月收入',

  `return_source` tinyint(3) NULL DEFAULT NULL COMMENT '还款来源',

  `contacts_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系人名称',

  `contacts_mobile` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系人手机',

  `contacts_relation` tinyint(3) NULL DEFAULT NULL COMMENT '联系人关系',

  `status` tinyint(3) NOT NULL DEFAULT 0 COMMENT '状态（0：未认证，1：认证中， 2：认证通过， -1：认证失败）',

  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',

  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

  `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除(1:已删除，0:未删除)',

  PRIMARY KEY (`id`) USING BTREE,

  UNIQUE INDEX `uk_user_id`(`user_id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '借款人' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of borrower

-- ----------------------------



-- ----------------------------

-- Table structure for borrower_attach

-- ----------------------------

DROP TABLE IF EXISTS `borrower_attach`;

CREATE TABLE `borrower_attach`  (

  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `borrower_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '借款人id',

  `image_type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片类型（idCard1：身份证正面，idCard2：身份证反面，house：房产证，car：车）',

  `image_url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片路径',

  `image_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片名称',

  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',

  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

  `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除(1:已删除，0:未删除)',

  PRIMARY KEY (`id`) USING BTREE,

  INDEX `idx_borrower_id`(`borrower_id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '借款人上传资源表' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of borrower_attach

-- ----------------------------



-- ----------------------------

-- Table structure for dict

-- ----------------------------

DROP TABLE IF EXISTS `dict`;

CREATE TABLE `dict`  (

  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',

  `parent_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '上级id',

  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '名称',

  `value` int(11) NULL DEFAULT NULL COMMENT '值',

  `dict_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编码',

  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',

  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

  `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '删除标记（0:不可用 1:可用）',

  PRIMARY KEY (`id`) USING BTREE,

  UNIQUE INDEX `uk_parent_id_value`(`parent_id`, `value`) USING BTREE,

  INDEX `idx_parent_id`(`parent_id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 82008 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '数据字典' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of dict

-- ----------------------------

INSERT INTO `dict` VALUES (1, 0, '全部分类', NULL, 'ROOT', '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (20000, 1, '行业', NULL, 'industry', '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (20001, 20000, 'IT', 1, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (20002, 20000, '医生', 2, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (20003, 20000, '教师', 3, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (20004, 20000, '导游', 4, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (20005, 20000, '律师', 5, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (20006, 20000, '其他', 6, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (30000, 1, '学历', NULL, 'education', '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (30001, 30000, '高中', 1, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (30002, 30000, '大专', 2, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (30003, 30000, '本科', 3, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (30004, 30000, '研究生', 4, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (30005, 30000, '其他', 5, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (40000, 1, '收入', NULL, 'income', '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (40001, 40000, '0-3000', 1, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (40002, 40000, '3000-5000', 2, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (40003, 40000, '5000-10000', 3, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (40004, 40000, '10000以上', 4, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (50000, 1, '收入来源', NULL, 'returnSource', '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (50001, 50000, '工资', 1, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (50002, 50000, '股票', 2, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (50003, 50000, '兼职', 3, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (60000, 1, '关系', NULL, 'relation', '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (60001, 60000, '夫妻', 1, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (60002, 60000, '兄妹', 2, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (60003, 60000, '父母', 3, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (60004, 60000, '其他', 4, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (70000, 1, '还款方式', NULL, 'returnMethod', '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (70001, 70000, '等额本息', 1, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (70002, 70000, '等额本金', 2, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (70003, 70000, '每月还息一次还本', 3, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (70004, 70000, '一次还本还息', 4, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (80000, 1, '资金用途', NULL, 'moneyUse', '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (80001, 80000, '旅游', 1, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (80002, 80000, '买房', 2, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (80003, 80000, '装修', 3, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (80004, 80000, '医疗', 4, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (80005, 80000, '美容', 5, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (80006, 80000, '其他', 6, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (81000, 1, '借款状态', NULL, 'borrowStatus', '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (81001, 81000, '待审核', 0, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (81002, 81000, '审批通过', 1, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (81003, 81000, '还款中', 2, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (81004, 81000, '结束', 3, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (81005, 81000, '审批不通过', -1, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (82000, 1, '学校性质', NULL, 'SchoolStatus', '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (82001, 82000, '211/985', NULL, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (82002, 82000, '一本', NULL, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (82003, 82000, '二本', NULL, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (82004, 82000, '三本', NULL, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (82005, 82000, '高职高专', NULL, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (82006, 82000, '中职中专', NULL, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);

INSERT INTO `dict` VALUES (82007, 82000, '高中及以下', NULL, NULL, '2021-02-20 00:26:22', '2021-02-20 00:26:22', 0);



-- ----------------------------

-- Table structure for integral_grade

-- ----------------------------

DROP TABLE IF EXISTS `integral_grade`;

CREATE TABLE `integral_grade`  (

  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `integral_start` int(11) NULL DEFAULT NULL COMMENT '积分区间开始',

  `integral_end` int(11) NULL DEFAULT NULL COMMENT '积分区间结束',

  `borrow_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '借款额度',

  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',

  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

  `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除(1:已删除，0:未删除)',

  PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '积分等级表' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of integral_grade

-- ----------------------------

INSERT INTO `integral_grade` VALUES (1, 10, 50, 10000.00, '2020-12-08 17:02:29', '2021-02-19 17:58:10', 0);

INSERT INTO `integral_grade` VALUES (2, 51, 100, 30000.00, '2020-12-08 17:02:42', '2021-02-19 18:00:25', 0);

INSERT INTO `integral_grade` VALUES (3, 101, 2000, 100000.00, '2020-12-08 17:02:57', '2021-02-23 21:03:03', 0);



-- ----------------------------

-- Table structure for lend

-- ----------------------------

DROP TABLE IF EXISTS `lend`;

CREATE TABLE `lend`  (

  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '借款用户id',

  `borrow_info_id` bigint(20) NULL DEFAULT NULL COMMENT '借款信息id',

  `lend_no` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标的编号',

  `title` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题',

  `amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '标的金额',

  `period` int(11) NULL DEFAULT NULL COMMENT '投资期数',

  `lend_year_rate` decimal(10, 2) NULL DEFAULT NULL COMMENT '年化利率',

  `service_rate` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台服务费率',

  `return_method` tinyint(3) NULL DEFAULT NULL COMMENT '还款方式',

  `lowest_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '最低投资金额',

  `invest_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '已投金额',

  `invest_num` int(11) NULL DEFAULT NULL COMMENT '投资人数',

  `publish_date` datetime(0) NULL DEFAULT NULL COMMENT '发布日期',

  `lend_start_date` date NULL DEFAULT NULL COMMENT '开始日期',

  `lend_end_date` date NULL DEFAULT NULL COMMENT '结束日期',

  `lend_info` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '说明',

  `expect_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '平台预期收益',

  `real_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际收益',

  `status` tinyint(3) NOT NULL DEFAULT 0 COMMENT '状态',

  `check_time` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',

  `check_admin_id` bigint(1) NULL DEFAULT NULL COMMENT '审核用户id',

  `payment_time` datetime(0) NULL DEFAULT NULL COMMENT '放款时间',

  `payment_admin_id` datetime(0) NULL DEFAULT NULL COMMENT '放款人id',

  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',

  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

  `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除(1:已删除，0:未删除)',

  PRIMARY KEY (`id`) USING BTREE,

  UNIQUE INDEX `uk_lend_no`(`lend_no`) USING BTREE,

  INDEX `idx_user_id`(`user_id`) USING BTREE,

  INDEX `idx_borrow_info_id`(`borrow_info_id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '标的准备表' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of lend

-- ----------------------------



-- ----------------------------

-- Table structure for lend_item

-- ----------------------------

DROP TABLE IF EXISTS `lend_item`;

CREATE TABLE `lend_item`  (

  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `lend_item_no` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '投资编号',

  `lend_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '标的id',

  `invest_user_id` bigint(20) NULL DEFAULT NULL COMMENT '投资用户id',

  `invest_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '投资人名称',

  `invest_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '投资金额',

  `lend_year_rate` decimal(10, 2) NULL DEFAULT NULL COMMENT '年化利率',

  `invest_time` datetime(0) NULL DEFAULT NULL COMMENT '投资时间',

  `lend_start_date` date NULL DEFAULT NULL COMMENT '开始日期',

  `lend_end_date` date NULL DEFAULT NULL COMMENT '结束日期',

  `expect_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '预期收益',

  `real_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '实际收益',

  `status` tinyint(3) NULL DEFAULT NULL COMMENT '状态（0：默认 1：已支付 2：已还款）',

  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',

  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

  `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除(1:已删除，0:未删除)',

  PRIMARY KEY (`id`) USING BTREE,

  UNIQUE INDEX `uk_lend_item_no`(`lend_item_no`) USING BTREE,

  INDEX `idx_lend_id`(`lend_id`) USING BTREE,

  INDEX `idx_invest_user_id`(`invest_user_id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '标的出借记录表' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of lend_item

-- ----------------------------



-- ----------------------------

-- Table structure for lend_item_return

-- ----------------------------

DROP TABLE IF EXISTS `lend_item_return`;

CREATE TABLE `lend_item_return`  (

  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `lend_return_id` bigint(20) NULL DEFAULT NULL COMMENT '标的还款id',

  `lend_item_id` bigint(20) NULL DEFAULT NULL COMMENT '标的项id',

  `lend_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '标的id',

  `invest_user_id` bigint(1) NULL DEFAULT NULL COMMENT '出借用户id',

  `invest_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '出借金额',

  `current_period` int(11) NULL DEFAULT NULL COMMENT '当前的期数',

  `lend_year_rate` decimal(10, 2) NULL DEFAULT NULL COMMENT '年化利率',

  `return_method` tinyint(3) NULL DEFAULT NULL COMMENT '还款方式 1-等额本息 2-等额本金 3-每月还息一次还本 4-一次还本',

  `principal` decimal(10, 2) NULL DEFAULT NULL COMMENT '本金',

  `interest` decimal(10, 2) NULL DEFAULT NULL COMMENT '利息',

  `total` decimal(10, 2) NULL DEFAULT NULL COMMENT '本息',

  `fee` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '手续费',

  `return_date` date NULL DEFAULT NULL COMMENT '还款时指定的还款日期',

  `real_return_time` datetime(0) NULL DEFAULT NULL COMMENT '实际发生的还款时间',

  `is_overdue` tinyint(1) NULL DEFAULT NULL COMMENT '是否逾期',

  `overdue_total` decimal(10, 2) NULL DEFAULT NULL COMMENT '逾期金额',

  `status` tinyint(3) NULL DEFAULT NULL COMMENT '状态（0-未归还 1-已归还）',

  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',

  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

  `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除(1:已删除，0:未删除)',

  PRIMARY KEY (`id`) USING BTREE,

  INDEX `idx_lend_return_id`(`lend_return_id`) USING BTREE,

  INDEX `idx_lend_item_id`(`lend_item_id`) USING BTREE,

  INDEX `idx_lend_id`(`lend_id`) USING BTREE,

  INDEX `idx_invest_user_id`(`invest_user_id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '标的出借回款记录表' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of lend_item_return

-- ----------------------------



-- ----------------------------

-- Table structure for lend_return

-- ----------------------------

DROP TABLE IF EXISTS `lend_return`;

CREATE TABLE `lend_return`  (

  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `lend_id` bigint(20) NULL DEFAULT NULL COMMENT '标的id',

  `borrow_info_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '借款信息id',

  `return_no` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '还款批次号',

  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '借款人用户id',

  `amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '借款金额',

  `base_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '计息本金额',

  `current_period` int(11) NULL DEFAULT NULL COMMENT '当前的期数',

  `lend_year_rate` decimal(10, 2) NULL DEFAULT NULL COMMENT '年化利率',

  `return_method` tinyint(3) NULL DEFAULT NULL COMMENT '还款方式 1-等额本息 2-等额本金 3-每月还息一次还本 4-一次还本',

  `principal` decimal(10, 2) NULL DEFAULT NULL COMMENT '本金',

  `interest` decimal(10, 2) NULL DEFAULT NULL COMMENT '利息',

  `total` decimal(10, 2) NULL DEFAULT NULL COMMENT '本息',

  `fee` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '手续费',

  `return_date` date NULL DEFAULT NULL COMMENT '还款时指定的还款日期',

  `real_return_time` datetime(0) NULL DEFAULT NULL COMMENT '实际发生的还款时间',

  `is_overdue` tinyint(1) NULL DEFAULT NULL COMMENT '是否逾期',

  `overdue_total` decimal(10, 2) NULL DEFAULT NULL COMMENT '逾期金额',

  `is_last` tinyint(1) NULL DEFAULT NULL COMMENT '是否最后一次还款',

  `status` tinyint(3) NULL DEFAULT NULL COMMENT '状态（0-未归还 1-已归还）',

  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',

  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

  `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除(1:已删除，0:未删除)',

  PRIMARY KEY (`id`) USING BTREE,

  UNIQUE INDEX `uk_return_no`(`return_no`) USING BTREE,

  INDEX `idx_lend_id`(`lend_id`) USING BTREE,

  INDEX `idx_borrow_info_id`(`borrow_info_id`) USING BTREE,

  INDEX `idx_user_id`(`user_id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '还款记录表' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of lend_return

-- ----------------------------



-- ----------------------------

-- Table structure for trans_flow

-- ----------------------------

DROP TABLE IF EXISTS `trans_flow`;

CREATE TABLE `trans_flow`  (

  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `user_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '用户id',

  `user_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名称',

  `trans_no` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '交易单号',

  `trans_type` tinyint(3) NOT NULL DEFAULT 0 COMMENT '交易类型（1：充值 2：提现 3：投标 4：投资回款 ...）',

  `trans_type_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '交易类型名称',

  `trans_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '交易金额',

  `memo` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',

  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',

  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

  `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除(1:已删除，0:未删除)',

  PRIMARY KEY (`id`) USING BTREE,

  UNIQUE INDEX `uk_trans_no`(`trans_no`) USING BTREE,

  INDEX `idx_user_id`(`user_id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 57 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '交易流水表' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of trans_flow

-- ----------------------------



-- ----------------------------

-- Table structure for user_account

-- ----------------------------

DROP TABLE IF EXISTS `user_account`;

CREATE TABLE `user_account`  (

  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `user_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '用户id',

  `amount` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '帐户可用余额',

  `freeze_amount` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '冻结金额',

  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',

  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

  `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除(1:已删除，0:未删除)',

  `version` int(11) NOT NULL DEFAULT 0 COMMENT '版本号',

  PRIMARY KEY (`id`) USING BTREE,

  UNIQUE INDEX `uk_user_id`(`user_id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户账户' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of user_account

-- ----------------------------



-- ----------------------------

-- Table structure for user_bind

-- ----------------------------

DROP TABLE IF EXISTS `user_bind`;

CREATE TABLE `user_bind`  (

  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `user_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '用户id',

  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户姓名',

  `id_card` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '身份证号',

  `bank_no` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '银行卡号',

  `bank_type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '银行类型',

  `mobile` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '手机号',

  `bind_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '绑定账户协议号',

  `status` tinyint(3) NULL DEFAULT NULL COMMENT '状态',

  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',

  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

  `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除(1:已删除，0:未删除)',

  PRIMARY KEY (`id`) USING BTREE,

  UNIQUE INDEX `uk_user_id`(`user_id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户绑定表' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of user_bind

-- ----------------------------



-- ----------------------------

-- Table structure for user_info

-- ----------------------------

DROP TABLE IF EXISTS `user_info`;

CREATE TABLE `user_info`  (

  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `user_type` tinyint(3) NOT NULL DEFAULT 0 COMMENT '1：出借人 2：借款人',

  `mobile` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '手机号',

  `password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户密码',

  `nick_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户昵称',

  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户姓名',

  `id_card` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身份证号',

  `email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',

  `openid` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微信用户标识openid',

  `head_img` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像',

  `bind_status` tinyint(3) NOT NULL DEFAULT 0 COMMENT '绑定状态（0：未绑定，1：绑定成功 -1：绑定失败）',

  `borrow_auth_status` tinyint(3) NOT NULL DEFAULT 0 COMMENT '借款人认证状态（0：未认证 1：认证中 2：认证通过 -1：认证失败）',

  `bind_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '绑定账户协议号',

  `integral` int(11) NOT NULL DEFAULT 0 COMMENT '用户积分',

  `status` tinyint(3) NOT NULL DEFAULT 1 COMMENT '状态（0：锁定 1：正常）',

  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',

  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

  `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除(1:已删除，0:未删除)',

  PRIMARY KEY (`id`) USING BTREE,

  INDEX `uk_mobile`(`mobile`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户基本信息' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of user_info

-- ----------------------------



-- ----------------------------

-- Table structure for user_integral

-- ----------------------------

DROP TABLE IF EXISTS `user_integral`;

CREATE TABLE `user_integral`  (

  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户id',

  `integral` int(11) NULL DEFAULT NULL COMMENT '积分',

  `content` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '获取积分说明',

  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',

  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

  `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除(1:已删除，0:未删除)',

  PRIMARY KEY (`id`) USING BTREE,

  INDEX `idx_user_id`(`user_id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户积分记录表' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of user_integral

-- ----------------------------



-- ----------------------------

-- Table structure for user_login_record

-- ----------------------------

DROP TABLE IF EXISTS `user_login_record`;

CREATE TABLE `user_login_record`  (

  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',

  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户id',

  `ip` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'ip',

  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',

  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',

  `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除(1:已删除，0:未删除)',

  PRIMARY KEY (`id`) USING BTREE,

  INDEX `idx_user_id`(`user_id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 29 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户登录记录表' ROW_FORMAT = DYNAMIC;



-- ----------------------------

-- Records of user_login_record

-- ----------------------------



SET FOREIGN_KEY_CHECKS = 1;
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
Java
1
https://gitee.com/foryly/loan.git
git@gitee.com:foryly/loan.git
foryly
loan
loan
master
点此查找更多帮助

搜索帮助

Git 命令在线学习 如何在 Gitee 导入 GitHub 仓库
Git 仓库基础操作
企业版和社区版功能对比
SSH 公钥设置
如何处理代码冲突
仓库体积过大，如何减小？
如何找回被删除的仓库数据
Gitee 产品配额说明
GitHub仓库快速导入Gitee及同步更新
什么是 Release（发行版）
将 PHP 项目自动发布到 packagist.org
评论
仓库举报
回到顶部