/*
 Navicat Premium Data Transfer

 Source Server         : Ali
 Source Server Type    : MySQL
 Source Server Version : 50649
 Source Host           : 47.94.92.138:3306
 Source Schema         : user

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

 Date: 14/01/2021 13:46:00
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for cash
-- ----------------------------
DROP TABLE IF EXISTS `cash`;
CREATE TABLE `cash`  (
  `cashFlowId` int(11) NOT NULL AUTO_INCREMENT COMMENT '现金流ID',
  `charge` decimal(10, 2) NULL DEFAULT NULL COMMENT '当前小车白天收费标准',
  `startTime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '开始时间',
  PRIMARY KEY (`cashFlowId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Compact;

-- ----------------------------
-- Records of cash
-- ----------------------------
INSERT INTO `cash` VALUES (1, 1.00, '2020-10-11 00:00:00');
INSERT INTO `cash` VALUES (2, 2.00, '2020-10-01 23:32:59');
INSERT INTO `cash` VALUES (3, 3.00, '2020-06-15 23:59:59');
INSERT INTO `cash` VALUES (4, 4.00, '2020-10-15 22:39:58');
INSERT INTO `cash` VALUES (7, 7.00, '2020-10-15 22:37:43');

-- ----------------------------
-- Table structure for parking
-- ----------------------------
DROP TABLE IF EXISTS `parking`;
CREATE TABLE `parking`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '停车场ID',
  `num` int(11) NULL DEFAULT NULL COMMENT '停车场容量',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '停车场名字',
  `bigCoefficient` double(5, 2) NOT NULL COMMENT '大车系数，可以由管理员改',
  `newEnergyCoefficient` double(5, 2) NOT NULL COMMENT '新能源系数',
  `coefficient` double(5, 2) NOT NULL DEFAULT 1.00 COMMENT '基础系数，当前停车场关于基数的标准系数',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Compact;

-- ----------------------------
-- Records of parking
-- ----------------------------
INSERT INTO `parking` VALUES (1, 1, '1', 1.00, 1.00, 1.00);
INSERT INTO `parking` VALUES (2, 1, '1', 3.00, 3.00, 1.00);
INSERT INTO `parking` VALUES (3, 3, NULL, 2.00, 3.00, 1.00);

-- ----------------------------
-- Table structure for record
-- ----------------------------
DROP TABLE IF EXISTS `record`;
CREATE TABLE `record`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parkingId` int(11) NOT NULL COMMENT '仓库ID',
  `carType` int(255) NULL DEFAULT NULL COMMENT '车类型：0-大卡车；1-小车',
  `carId` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌号',
  `enterTime` timestamp(0) NULL DEFAULT NULL COMMENT '进入时间',
  `enterImg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '入场图片',
  `leaveTime` timestamp(0) NULL DEFAULT NULL COMMENT '出库时间',
  `leaveTmg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '出库图片',
  `price` double(10, 2) NULL DEFAULT NULL COMMENT '总价',
  `isExist` int(255) NULL DEFAULT NULL COMMENT '是否在库：0-不在库；1-在库',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 33 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Compact;

-- ----------------------------
-- Records of record
-- ----------------------------
INSERT INTO `record` VALUES (2, 1, 1, '201701', '2020-10-06 23:32:59', '1', '2020-10-01 23:32:59', '1', 20.00, 0);
INSERT INTO `record` VALUES (3, 1, 1, '201701', '2020-10-01 23:32:59', '1', '2020-10-01 23:32:59', '1', 12.00, 0);
INSERT INTO `record` VALUES (4, 1, 1, '201702', '2020-10-01 23:32:59', '1', '2020-10-01 23:32:59', '1', 22.00, 0);
INSERT INTO `record` VALUES (5, 1, 1, '201701', '2020-10-01 23:32:59', '1', '2020-10-30 23:32:59', '1', 20.00, 0);
INSERT INTO `record` VALUES (6, 2, 1, '201702', '2020-10-06 23:32:59', '1', '2020-10-01 23:32:59', '1', 33.00, 0);
INSERT INTO `record` VALUES (7, 3, 1, '201701', '2020-10-01 23:32:59', '1', '2020-10-01 23:32:59', '1', 20.00, 0);
INSERT INTO `record` VALUES (8, 4, 1, '201701', '2020-10-01 23:32:59', '1', '2020-10-31 23:32:59', '1', 50.00, 0);
INSERT INTO `record` VALUES (9, 1, 1, '201701', '2020-10-05 23:32:59', '1', '2020-10-01 23:32:59', '1', 20.00, 0);
INSERT INTO `record` VALUES (10, 2, 1, '201702', '2020-10-01 23:32:59', '1', '2020-10-25 23:32:59', '1', 44.00, 0);
INSERT INTO `record` VALUES (11, 3, 1, '201701', '2020-10-05 23:32:59', '1', '2020-10-01 23:32:59', '1', 42.00, 0);
INSERT INTO `record` VALUES (12, 4, 1, '201701', '2020-10-01 23:32:59', '1', '2020-10-01 23:32:59', '1', 20.00, 0);
INSERT INTO `record` VALUES (13, 3, 0, '201701', '2020-10-01 23:32:59', '1', '2020-10-01 23:32:59', '1', 20.00, 0);
INSERT INTO `record` VALUES (14, 2, 1, '201702', '2020-10-01 23:32:59', '1', '2020-10-01 23:32:59', '1', 30.00, 0);
INSERT INTO `record` VALUES (15, 1, 0, '201701', '2020-10-01 23:32:59', '1', '2020-10-01 23:32:59', '1', 20.00, 0);
INSERT INTO `record` VALUES (16, 5, 0, '201701', '2020-09-28 23:32:59', '1', '2020-11-11 23:32:59', '1', 44.00, 0);
INSERT INTO `record` VALUES (17, 3, 0, '201701', '2020-09-15 23:32:59', '1', '2020-10-01 23:32:59', '1', 22.00, 0);
INSERT INTO `record` VALUES (18, 2, 1, '201702', '2020-10-01 23:32:59', '1', '2020-10-01 23:32:59', '1', 73.00, 0);
INSERT INTO `record` VALUES (19, 1, 0, '201701', '2020-09-22 23:32:59', '1', '2020-11-11 23:32:59', '1', 52.00, 0);
INSERT INTO `record` VALUES (20, 5, 0, '201701', '2020-10-01 23:32:59', '1', '2020-10-01 23:32:59', '1', 12.00, 0);
INSERT INTO `record` VALUES (21, 3, 0, '201701', '2020-10-01 23:32:59', '1', '2020-10-01 23:32:59', '1', 20.00, 0);
INSERT INTO `record` VALUES (22, 2, 1, '201702', '2020-10-01 23:32:59', '1', '2020-10-01 23:32:59', '1', 30.00, 0);
INSERT INTO `record` VALUES (23, 1, 0, '201701', '2020-10-01 23:32:59', '1', '2020-10-01 23:32:59', '1', 20.00, 0);
INSERT INTO `record` VALUES (24, 5, 0, '201701', '2020-10-01 23:32:59', '1', '2020-10-01 23:32:59', '1', 20.00, 0);
INSERT INTO `record` VALUES (25, 3, 0, '201701', '2020-10-01 23:32:59', '1', '2020-10-01 23:32:59', '1', 20.00, 0);
INSERT INTO `record` VALUES (26, 2, 1, '201702', '2020-10-01 23:32:59', '1', '2020-10-01 23:32:59', '1', 30.00, 0);
INSERT INTO `record` VALUES (27, 1, 0, '201701', '2020-10-01 23:32:59', '1', '2020-10-01 23:32:59', '1', 20.00, 0);
INSERT INTO `record` VALUES (28, 5, 0, '201701', '2020-10-01 23:32:59', '1', '2020-10-01 23:32:59', '1', 20.00, 0);
INSERT INTO `record` VALUES (29, 3, 0, '201701', '2020-10-01 23:32:59', '1', '2020-10-01 23:32:59', '1', 20.00, 0);
INSERT INTO `record` VALUES (30, 2, 1, '201702', '2020-10-01 23:32:59', '1', '2020-10-01 23:32:59', '1', 30.00, 0);
INSERT INTO `record` VALUES (31, 1, 0, '201701', '2020-10-01 23:32:59', '1', '2020-10-01 23:32:59', '1', 20.00, 0);
INSERT INTO `record` VALUES (32, 5, 0, '201701', '2020-10-01 23:32:59', '1', '2020-10-01 23:32:59', '1', 20.00, 0);

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `userName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户名',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '密码',
  `userType` int(11) NULL DEFAULT NULL COMMENT '用户类型: 0-管理员；1-门卫',
  `parkingId` int(11) NULL DEFAULT NULL COMMENT '门卫的仓库ID'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Compact;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('11', '11', 1, 1);
INSERT INTO `user` VALUES ('22', '22', 2, 2);
INSERT INTO `user` VALUES ('对方付费', '方法', 3, 3);
INSERT INTO `user` VALUES ('李四', '33', 1, 4);
INSERT INTO `user` VALUES ('王五', '44', 1, 5);
INSERT INTO `user` VALUES ('管理员', '00', 0, NULL);

SET FOREIGN_KEY_CHECKS = 1;