/*
Navicat MySQL Data Transfer
Source Server : xing
Source Server Type : MySQL
Source Server Version : 80031
Source Host : localhost:3306
Source Schema : finance
Target Server Type : MySQL
Target Server Version : 80031
File Encoding : 65001
Date: 08/12/2022 15:40:31
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`id` int(0) NOT NULL AUTO_INCREMENT COMMENT '管理员账户 主键id',
`username` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '管理员用户名',
`password` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '登录密码',
`status` int(0) NULL DEFAULT NULL COMMENT '登录状态(0:离线 1:在线)',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES (1, 'admin', 'e10adc3949ba59abbe56e057f20f883e', 1);
-- ----------------------------
-- Table structure for admin_permissions
-- ----------------------------
DROP TABLE IF EXISTS `admin_permissions`;
CREATE TABLE `admin_permissions` (
`id` int(0) NOT NULL AUTO_INCREMENT COMMENT '管理员权限表 主键自增',
`adminId` int(0) NULL DEFAULT NULL COMMENT '管理员id',
`permissionId` int(0) NULL DEFAULT NULL COMMENT '权限id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 79 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of admin_permissions
-- ----------------------------
INSERT INTO `admin_permissions` VALUES (64, 1, 10);
INSERT INTO `admin_permissions` VALUES (65, 1, 11);
INSERT INTO `admin_permissions` VALUES (66, 1, 12);
INSERT INTO `admin_permissions` VALUES (67, 1, 13);
INSERT INTO `admin_permissions` VALUES (68, 1, 14);
INSERT INTO `admin_permissions` VALUES (69, 1, 15);
INSERT INTO `admin_permissions` VALUES (70, 1, 16);
INSERT INTO `admin_permissions` VALUES (71, 1, 17);
INSERT INTO `admin_permissions` VALUES (72, 1, 18);
INSERT INTO `admin_permissions` VALUES (73, 1, 19);
INSERT INTO `admin_permissions` VALUES (74, 1, 20);
INSERT INTO `admin_permissions` VALUES (75, 1, 21);
INSERT INTO `admin_permissions` VALUES (76, 1, 22);
INSERT INTO `admin_permissions` VALUES (77, 1, 23);
INSERT INTO `admin_permissions` VALUES (78, 1, 24);
INSERT INTO `admin_permissions` VALUES (79, 1, 25);
-- ----------------------------
-- Table structure for bank
-- ----------------------------
DROP TABLE IF EXISTS `bank`;
CREATE TABLE `bank` (
`id` int(0) NOT NULL AUTO_INCREMENT COMMENT '银行 主键id',
`name` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '银行名称',
`type` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '银行类型',
`assets` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '资产',
`bankDesc` varchar(20000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '银行描述',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of bank
-- ----------------------------
INSERT INTO `bank` VALUES (1, '中国工商银行', '商业银行', '2,076.14亿美元', ' <span style=\"font-weight: bold;\">中国工商银行(INDUSTRIAL AND COMMERCIAL BANK OF CHINA,简称ICBC ,工行)成立于1984年1月1日。 总行位于北京复兴门内大街55号,是中央管理的大型国有银行, 国家副部级单位。 </span><div><span style=\"font-weight: bold;\"> 中国工商银行的基本任务是依据国家的法律和法规,通过国内外开展融资活动筹集社会资金,加强信贷资金管理,支持企业生产和技术改造,为我国经济建设服务。</span><p><br></p></div>');
INSERT INTO `bank` VALUES (2, '中国建设银行', '商业银行', '2,941.12亿美元', ' <span style=\"font-style: italic;\">中国建设银行(China Construction Bank)成立于1954年10月1日。总行位于北京金融大街25号,是中央管理的大型国有</span>银行, 国家副部级单位。 <div> <span style=\"font-weight: bold;\">中国建设银行主要经营领域包括公司银行业务、个人银行业务和资金业务,在29个国家和地区设有分支机构及子公司,拥有基金、租赁、信托、人寿、财险、投行、期货、养老金等多个行业的子公司。</span><p><br></p></div>');
INSERT INTO `bank` VALUES (3, '中国民生银行11', '股份制商业银行', '7,685.66亿美元', '<h1><span style=\"font-weight: bold; font-style: italic;\">民生银行</span></h1>');
-- ----------------------------
-- Table structure for bankcard
-- ----------------------------
DROP TABLE IF EXISTS `bankcard`;
CREATE TABLE `bankcard` (
`id` int(0) NOT NULL AUTO_INCREMENT COMMENT '银行卡编号 主键自增',
`cardBank` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '银行卡所属银行',
`type` int(0) NULL DEFAULT NULL COMMENT '银行卡类型(1:借记卡 2:信用卡)',
`cardNum` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '银行卡号',
`userId` int(0) NULL DEFAULT NULL COMMENT '银行卡所属用户',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of bankcard
-- ----------------------------
INSERT INTO `bankcard` VALUES (1, '中国建设银行', 1, '12345678945213124', 1);
INSERT INTO `bankcard` VALUES (6, '中国民生银行', 1, '12345678998765432', 1);
INSERT INTO `bankcard` VALUES (7, '中国邮政储蓄银行', 2, '1234567891234567', 6);
-- ----------------------------
-- Table structure for change_money
-- ----------------------------
DROP TABLE IF EXISTS `change_money`;
CREATE TABLE `change_money` (
`id` int(0) NOT NULL AUTO_INCREMENT COMMENT '零钱理财产品 主键id',
`name` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '理财产品名称',
`annualIncome` decimal(10, 8) NULL DEFAULT NULL COMMENT '七日年化收益率',
`peiIncome` decimal(10, 2) NULL DEFAULT NULL COMMENT '每万元收益',
`invesTerm` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '投资期限',
`invesMoney` decimal(10, 2) NULL DEFAULT NULL COMMENT '起投金额',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of change_money
-- ----------------------------
INSERT INTO `change_money` VALUES (1, '支付宝零钱理财', 0.03435000, 0.99, '30天', 100.00);
INSERT INTO `change_money` VALUES (2, '微信零钱理财', 0.03236000, 0.98, '30天', 100.00);
INSERT INTO `change_money` VALUES (3, '理财通零钱理财', 0.03222000, 0.97, '30天', 300.00);
INSERT INTO `change_money` VALUES (4, '云闪付理财', 0.03233000, 0.88, '三个月', 200.00);
-- ----------------------------
-- Table structure for flow_of_funds
-- ----------------------------
DROP TABLE IF EXISTS `flow_of_funds`;
CREA