/*
 Navicat Premium Data Transfer

 Source Server         : my
 Source Server Type    : MySQL
 Source Server Version : 80016
 Source Host           : localhost:3306
 Source Schema         : zcdatabase2

 Target Server Type    : MySQL
 Target Server Version : 80016
 File Encoding         : 65001

 Date: 16/10/2019 11:28:07
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for customer
-- ----------------------------
DROP TABLE IF EXISTS `customer`;
CREATE TABLE `customer`  (
  `cusId` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `cusName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `corpoRepresentative` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `regiAddress` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `isDelete` smallint(6) NULL DEFAULT NULL,
  PRIMARY KEY (`cusId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of customer
-- ----------------------------
INSERT INTO `customer` VALUES ('2019010877', 'CHENG ZHANG', 'AAAA', '湖北省武汉市江汉区红旗渠路', '6666@qq.com', 0);
INSERT INTO `customer` VALUES ('2019011235', 'zry', 'zc', '中国', '6873094@qq.com', 0);
INSERT INTO `customer` VALUES ('2019011237', 'zc', 'zry', '中国', '2268874211@qq.com', 0);
INSERT INTO `customer` VALUES ('2019013363', 'CHENG ZHANG', 'RENYING ZHANG', '湖北省襄阳市南漳县aaaa', '6873094@qq.com', 0);
INSERT INTO `customer` VALUES ('2019015051', 'CHENG ZHANG', 'SSSS', '湖北省黄石市西塞山区红旗渠路', '66@qq.com', 0);
INSERT INTO `customer` VALUES ('2019015463', 'zry', 'zc', '中国', '6873094@qq.com', 0);
INSERT INTO `customer` VALUES ('2019016915', 'CHENG ZHANG', 'JUNYI HU', '湖北省武汉市江汉区红旗渠路', '6873094@qq.com', 0);
INSERT INTO `customer` VALUES ('2019019326', 'CHENG ZHANG', 'ZZZ', '湖北省武汉市江汉区红旗渠路', '666@qq.com', 0);

-- ----------------------------
-- Table structure for customercreditlevel
-- ----------------------------
DROP TABLE IF EXISTS `customercreditlevel`;
CREATE TABLE `customercreditlevel`  (
  `creditlevelId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `cusId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `creditLevel` int(11) NULL DEFAULT NULL,
  `thisLevelBeginDate` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `thisLevelEndDate` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `isDelete` smallint(6) NULL DEFAULT NULL,
  PRIMARY KEY (`creditlevelId`) USING BTREE,
  INDEX `cusId`(`cusId`) USING BTREE,
  CONSTRAINT `customercreditlevel_ibfk_1` FOREIGN KEY (`cusId`) REFERENCES `customer` (`cusId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of customercreditlevel
-- ----------------------------
INSERT INTO `customercreditlevel` VALUES ('20190927123', '2019011237', 4, '2019-09-27', '2019-09-30', 0);

-- ----------------------------
-- Table structure for customercreditlevelhistory
-- ----------------------------
DROP TABLE IF EXISTS `customercreditlevelhistory`;
CREATE TABLE `customercreditlevelhistory`  (
  `levelHisId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `cusId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `creditLevel` int(11) NULL DEFAULT NULL,
  `thisLevelBeginDate` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `thisLevelEndDate` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `isDelete` smallint(6) NULL DEFAULT NULL,
  PRIMARY KEY (`levelHisId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of customercreditlevelhistory
-- ----------------------------
INSERT INTO `customercreditlevelhistory` VALUES ('20190827123', '2019011235', 15, '2019-08-27', '2019-09-26', 0);

-- ----------------------------
-- Table structure for customercreditloan
-- ----------------------------
DROP TABLE IF EXISTS `customercreditloan`;
CREATE TABLE `customercreditloan`  (
  `creditLoanId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `cusId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `loanMoney` decimal(10, 0) NULL DEFAULT NULL,
  `beginDate` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `isDelete` smallint(6) NULL DEFAULT NULL,
  PRIMARY KEY (`creditLoanId`) USING BTREE,
  INDEX `cusId`(`cusId`) USING BTREE,
  CONSTRAINT `customercreditloan_ibfk_1` FOREIGN KEY (`cusId`) REFERENCES `customer` (`cusId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of customercreditloan
-- ----------------------------
INSERT INTO `customercreditloan` VALUES ('0', '2019011235', 12, '2019-09-27', 0);
INSERT INTO `customercreditloan` VALUES ('201909271235000', '2019011235', 5000, '2019-09-27', 1);

-- ----------------------------
-- Table structure for depositdetails
-- ----------------------------
DROP TABLE IF EXISTS `depositdetails`;
CREATE TABLE `depositdetails`  (
  `depositId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `cusId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `manId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `depName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `depNum` int(11) NULL DEFAULT NULL,
  `depGuessPrice` decimal(10, 0) NULL DEFAULT NULL,
  `depEnsurePrice` decimal(10, 0) NULL DEFAULT NULL,
  `okDate` date NULL DEFAULT NULL,
  `isDelete` smallint(6) NULL DEFAULT NULL,
  PRIMARY KEY (`depositId`) USING BTREE,
  INDEX `cusId`(`cusId`) USING BTREE,
  INDEX `manId`(`manId`) USING BTREE,
  CONSTRAINT `depositdetails_ibfk_1` FOREIGN KEY (`cusId`) REFERENCES `customer` (`cusId`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `depositdetails_ibfk_2` FOREIGN KEY (`manId`) REFERENCES `manager` (`manId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of depositdetails
-- ----------------------------
INSERT INTO `depositdetails` VALUES ('2019092412310394843585', '2019011235', '2019099971', 'qwewqe', 2, 1232, 1000, '2019-09-24', 1);
INSERT INTO `depositdetails` VALUES ('2019092712318433845673', '2019011235', '2019099971', '123', 123, 123, 0, '2019-09-27', 0);
INSERT INTO `depositdetails` VALUES ('2019092712318475977797', '2019011235', '2019099971', 'asd', 123, 123, 0, '2019-09-27', 0);
INSERT INTO `depositdetails` VALUES ('2019092712318480709109', '2019011235', '2019099971', '123', 123, 123, 0, '2019-09-27', 0);
INSERT INTO `depositdetails` VALUES ('2019092712318523044611', '2019011235', '2019099971', '12', 12, 12, 0, '2019-09-27', 0);
INSERT INTO `depositdetails` VALUES ('cDepD2019093012310035081064', '2019011235', '2019099971', '123', 123, 123, 0, '2019-09-30', 0);
INSERT INTO `depositdetails` VALUES ('cDepD2019093012310043163765', '2019011235', '2019099971', '324', 12, 23, 0, '2019-09-30', 0);
INSERT INTO `depositdetails` VALUES ('cDepD2019093012311130315229', '2019011235', '2019099971', '6546', 234, 342, 0, '2019-09-30', 0);
INSERT INTO `depositdetails` VALUES ('cDepD20191014201901123715043713727', '2019011237', '2019091997', 'QWE', 123, 123, 0, '2019-10-14', 0);

-- ----------------------------
-- Table structure for emailverify
-- ----------------------------
DROP TABLE IF EXISTS `emailverify`;
CREATE TABLE `emailverify`  (
  `peoId` int(11) NOT NULL,
  `peoVerCode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `overDueDate` datetime(0) NULL DEFAULT NULL,
  `isDelete` tinyint(255) NULL DEFAULT NULL,
  PRIMARY KEY (`peoId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of emailverify
-- ----------------------------
INSERT INTO `emailverify` VALUES (2019011235, '295243', '2019-09-29 17:42:17', 0);
INSERT INTO `emailverify` VALUES (2019011237, '086012', '2019-10-16 10:35:14', 0);
INSERT INTO `emailverify` VALUES (2019015463, '885223', '2019-10-09 10:24:02', 0);

-- ----------------------------
-- Table structure for goods
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods`  (
  `id` int(11) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `price` decimal(10, 2) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of goods
-- ----------------------------
INSERT INTO `goods` VALUES (1, '苹果', 49.90);
INSERT INTO `goods` VALUES (2, '香蕉', 29.90);
INSERT INTO `goods` VALUES (3, '梨子', 50.00);

-- ----------------------------
-- Table structure for manager
-- ----------------------------
DROP TABLE IF EXISTS `manager`;
CREATE TABLE `manager`  (
  `manId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `manName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `manLevel` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `manWorkPhone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `isDelete` smallint(6) NULL DEFAULT NULL,
  PRIMARY KEY (`manId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of manager
-- ----------------------------
INSERT INTO `manager` VALUES ('2019091997', 'zc', '2', '12222222222', '6873094@qq.com', 0);
INSERT INTO `manager` VALUES ('2019091998', 'zcc', '2', '11111111111', '6873094@qq.com', 0);
INSERT INTO `manager` VALUES ('2019099971', 'zccc', '2', '12121212121', '6873094@qq.com', 0);

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `userId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `peoId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `pwd` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `userType` int(11) NULL DEFAULT NULL,
  `isDelete` smallint(6) NULL DEFAULT NULL,
  PRIMARY KEY (`userId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('123', '2019011237', '121212', 0, 0);
INSERT INTO `user` VALUES ('124', '2019011235', '1', 0, 0);
INSERT INTO `user` VALUES ('125', '2019015463', '123456789', 0, 0);
INSERT INTO `user` VALUES ('666', '666', '123', 2, 0);
INSERT INTO `user` VALUES ('997', '2019091997', '1', 1, 0);
INSERT INTO `user` VALUES ('998', '2019091998', '1', 1, 0);

SET FOREIGN_KEY_CHECKS = 1;