parkMonitor_V2.0/zxpark_local1203.sql

/*
Navicat MySQL Data Transfer

Source Server         : 127.0.0.1
Source Server Version : 50638
Source Host           : 127.0.0.1:20000
Source Database       : zxpark_local

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

Date: 2018-12-03 09:56:33
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for garageproperties
-- ----------------------------
DROP TABLE IF EXISTS `garageproperties`;
CREATE TABLE `garageproperties` (
  `garageID` int(8) NOT NULL AUTO_INCREMENT,
  `paymentSchemeID` int(8) NOT NULL COMMENT '收费策略',
  `totalBookableSpace` int(4) NOT NULL DEFAULT '0' COMMENT '可预约车位总数',
  `currentBookableSpace` int(4) NOT NULL DEFAULT '0' COMMENT '当前可预约车位数',
  `garageCapacity` int(4) NOT NULL DEFAULT '0' COMMENT '车库容量',
  `garageFreeSpace` int(4) NOT NULL DEFAULT '0' COMMENT '当前剩余车位数',
  PRIMARY KEY (`garageID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of garageproperties
-- ----------------------------
INSERT INTO `garageproperties` VALUES ('1', '1', '20', '19', '200', '180');

-- ----------------------------
-- Table structure for manager
-- ----------------------------
DROP TABLE IF EXISTS `manager`;
CREATE TABLE `manager` (
  `managerID` int(10) NOT NULL AUTO_INCREMENT,
  `managerPassword` varchar(50) NOT NULL,
  `managerTel` varchar(11) NOT NULL,
  `managerName` varchar(50) NOT NULL,
  `roleID` int(8) NOT NULL,
  PRIMARY KEY (`managerID`),
  KEY `manager_ibfk_1` (`roleID`),
  CONSTRAINT `manager_ibfk_1` FOREIGN KEY (`roleID`) REFERENCES `role` (`roleID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of manager
-- ----------------------------

-- ----------------------------
-- Table structure for monthcardrecords
-- ----------------------------
DROP TABLE IF EXISTS `monthcardrecords`;
CREATE TABLE `monthcardrecords` (
  `monthCardRecordsID` int(8) NOT NULL AUTO_INCREMENT,
  `monthCardType` int(1) unsigned zerofill NOT NULL COMMENT '月卡类型，0无，1体验，2月，3季度，4半年，5年',
  `numberPlate` char(8) NOT NULL COMMENT '车牌号',
  `garageID` int(4) NOT NULL,
  `monthCardDetail` varchar(50) DEFAULT NULL,
  `startTime` varchar(50) NOT NULL,
  `endTime` varchar(50) NOT NULL,
  PRIMARY KEY (`monthCardRecordsID`),
  KEY `monthCardRecords_ibfk_1` (`numberPlate`),
  KEY `monthCardRecords_ibfk_2` (`garageID`),
  CONSTRAINT `monthcardrecords_ibfk_1` FOREIGN KEY (`numberPlate`) REFERENCES `vehicle` (`numberPlate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of monthcardrecords
-- ----------------------------

-- ----------------------------
-- Table structure for numberplatemapping
-- ----------------------------
DROP TABLE IF EXISTS `numberplatemapping`;
CREATE TABLE `numberplatemapping` (
  `numberPlateHeader` varchar(5) NOT NULL,
  `mappedString` char(2) NOT NULL,
  PRIMARY KEY (`numberPlateHeader`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of numberplatemapping
-- ----------------------------
INSERT INTO `numberplatemapping` VALUES ('云', '07');
INSERT INTO `numberplatemapping` VALUES ('京', '01');
INSERT INTO `numberplatemapping` VALUES ('使', '32');
INSERT INTO `numberplatemapping` VALUES ('冀', '05');
INSERT INTO `numberplatemapping` VALUES ('吉', '23');
INSERT INTO `numberplatemapping` VALUES ('学', '35');
INSERT INTO `numberplatemapping` VALUES ('宁', '30');
INSERT INTO `numberplatemapping` VALUES ('川', '29');
INSERT INTO `numberplatemapping` VALUES ('挂', '34');
INSERT INTO `numberplatemapping` VALUES ('新', '13');
INSERT INTO `numberplatemapping` VALUES ('晋', '21');
INSERT INTO `numberplatemapping` VALUES ('桂', '18');
INSERT INTO `numberplatemapping` VALUES ('沪', '03');
INSERT INTO `numberplatemapping` VALUES ('津', '02');
INSERT INTO `numberplatemapping` VALUES ('浙', '15');
INSERT INTO `numberplatemapping` VALUES ('渝', '04');
INSERT INTO `numberplatemapping` VALUES ('港', '37');
INSERT INTO `numberplatemapping` VALUES ('湘', '10');
INSERT INTO `numberplatemapping` VALUES ('澳', '38');
INSERT INTO `numberplatemapping` VALUES ('琼', '31');
INSERT INTO `numberplatemapping` VALUES ('甘', '19');
INSERT INTO `numberplatemapping` VALUES ('皖', '11');
INSERT INTO `numberplatemapping` VALUES ('粤', '26');
INSERT INTO `numberplatemapping` VALUES ('苏', '14');
INSERT INTO `numberplatemapping` VALUES ('蒙', '20');
INSERT INTO `numberplatemapping` VALUES ('藏', '28');
INSERT INTO `numberplatemapping` VALUES ('警', '36');
INSERT INTO `numberplatemapping` VALUES ('豫', '06');
INSERT INTO `numberplatemapping` VALUES ('贵', '25');
INSERT INTO `numberplatemapping` VALUES ('赣', '16');
INSERT INTO `numberplatemapping` VALUES ('辽', '08');
INSERT INTO `numberplatemapping` VALUES ('鄂', '17');
INSERT INTO `numberplatemapping` VALUES ('闽', '24');
INSERT INTO `numberplatemapping` VALUES ('陕', '22');
INSERT INTO `numberplatemapping` VALUES ('青', '27');
INSERT INTO `numberplatemapping` VALUES ('领', '33');
INSERT INTO `numberplatemapping` VALUES ('鲁', '12');
INSERT INTO `numberplatemapping` VALUES ('黑', '09');

-- ----------------------------
-- Table structure for orderrecords
-- ----------------------------
DROP TABLE IF EXISTS `orderrecords`;
CREATE TABLE `orderrecords` (
  `orderRecordsID` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '预约记录id',
  `userID` int(8) NOT NULL COMMENT '用户id',
  `numberPlate` char(8) NOT NULL COMMENT '车牌号',
  `garageID` int(4) NOT NULL,
  `bookParkTime` varchar(50) DEFAULT NULL COMMENT '预约时间',
  `cancelBookTime` varchar(50) DEFAULT NULL COMMENT '取消预约时间',
  `bookFetchTime` varchar(50) DEFAULT NULL,
  `bookHour` int(2) unsigned DEFAULT NULL COMMENT '预约时长',
  `bookPrice` int(11) unsigned zerofill DEFAULT NULL COMMENT '价格',
  `bookState` int(1) unsigned zerofill NOT NULL COMMENT '是否超过预约时间，默认0预停开始，1预停超时，2预取开始，3预取超时，4订单支付完成',
  PRIMARY KEY (`orderRecordsID`),
  KEY `orderRecords_ibfk_3` (`garageID`),
  KEY `orderRecords_ibfk_1` (`userID`),
  KEY `orderRecords_ibfk_2` (`numberPlate`),
  CONSTRAINT `orderrecords_ibfk_1` FOREIGN KEY (`numberPlate`) REFERENCES `vehicle` (`numberPlate`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of orderrecords
-- ----------------------------
INSERT INTO `orderrecords` VALUES ('1', '1', '鄂A12345', '1', '2018-11-07 16:21:02', null, null, '1', '00000000003', '4');
INSERT INTO `orderrecords` VALUES ('2', '8', '苏B56789', '1', '2018-11-14 23:30:22', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('3', '8', '鄂A12345', '1', '2018-11-14 23:36:19', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('4', '8', '苏B56789', '1', '2018-11-15 00:51:07', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('5', '8', '苏B56789', '1', '2018-11-15 01:08:10', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('6', '8', '苏B56789', '1', '2018-11-13 17:42:49', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('7', '8', '鄂A12345', '1', '2018-11-13 17:59:43', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('8', '8', '苏B56789', '1', '2018-11-13 18:14:30', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('9', '8', '苏B56789', '1', '2018-11-13 18:16:21', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('10', '8', '苏B56789', '1', '2018-11-13 18:21:36', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('11', '8', '苏B56789', '1', '2018-11-15 09:15:08', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('12', '8', '鄂A12345', '1', '2018-11-21 08:46:55', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('13', '8', '桂K88888', '1', '2018-11-21 14:00:52', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('14', '8', '桂K88888', '1', '2018-11-23 14:08:14', null, null, '2', null, '0');
INSERT INTO `orderrecords` VALUES ('15', '8', '桂K88888', '1', '2018-11-23 15:23:22', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('16', '8', '桂K88888', '1', '2018-11-23 16:16:24', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('17', '8', '桂K88888', '1', '2018-11-23 16:19:06', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('18', '8', '桂K88888', '1', '2018-11-23 16:28:13', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('19', '8', '桂K88888', '1', '2018-11-23 16:31:15', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('20', '8', '桂K88888', '1', '2018-11-23 16:40:05', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('21', '8', '桂K88888', '1', '2018-11-23 16:42:51', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('22', '8', '桂K88888', '1', '2018-11-23 16:49:59', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('23', '8', '桂K88888', '1', '2018-11-27 13:51:44', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('24', '8', '苏B56789', '1', '2018-11-27 13:56:21', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('25', '8', '鄂A12345', '1', '2018-11-27 13:57:18', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('30', '8', '鄂A19999', '1', '2018-11-27 14:31:47', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('31', '8', '鄂A19999', '1', '2018-11-27 14:34:30', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('32', '8', '苏B56789', '1', '2018-11-27 14:37:32', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('33', '8', '桂K88888', '1', '2018-11-28 14:56:13', null, null, '2', null, '0');
INSERT INTO `orderrecords` VALUES ('34', '8', '桂K88888', '1', '2018-11-28 15:52:04', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('35', '8', '桂K88888', '1', '2018-11-28 15:57:23', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('36', '8', '桂K88888', '1', '2018-11-28 15:59:19', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('37', '8', '桂K88888', '1', '2018-11-28 16:05:15', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('38', '8', '桂K88888', '1', '2018-11-28 16:08:34', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('39', '8', '桂K88888', '1', '2018-11-28 17:01:32', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('40', '8', '桂K88888', '1', '2018-11-28 17:16:23', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('41', '8', '桂K88888', '1', '2018-11-28 17:32:59', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('42', '8', '桂K88888', '1', '2018-11-28 18:05:59', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('43', '8', '桂K88888', '1', '2018-11-29 10:28:43', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('44', '8', '桂K88888', '1', '2018-11-29 10:42:13', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('45', '8', '桂K88888', '1', '2018-11-29 11:01:50', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('46', '8', '苏B56789', '1', '2018-11-29 11:43:52', null, null, '3', null, '0');
INSERT INTO `orderrecords` VALUES ('47', '28', '桂K88888', '1', '2018-11-29 14:31:49', null, null, '1', null, '0');
INSERT INTO `orderrecords` VALUES ('48', '28', '桂K88888', '1', '2018-11-29 14:55:50', null, null, '1', null, '0');
INSERT INTO `orderrecords` VALUES ('49', '8', '桂K88888', '1', '2018-12-01 16:04:59', null, null, '3', null, '0');

-- ----------------------------
-- Table structure for parkingrecords
-- ----------------------------
DROP TABLE IF EXISTS `parkingrecords`;
CREATE TABLE `parkingrecords` (
  `parkingRecordsID` int(11) NOT NULL AUTO_INCREMENT COMMENT '订单ID',
  `userID` int(8) NOT NULL COMMENT '用户ID',
  `numberPlate` char(8) NOT NULL COMMENT '车牌号',
  `parkingSpaceID` int(4) NOT NULL COMMENT '车位ID',
  `garageID` int(4) NOT NULL COMMENT '车库ID',
  `parkingRecordsState` int(11) NOT NULL COMMENT '订单状态',
  `realParkTime` varchar(50) DEFAULT NULL COMMENT '实际停车时间',
  `realGetTime` varchar(50) DEFAULT NULL COMMENT '实际取车时间',
  `receiptNum` int(8) DEFAULT NULL COMMENT '流水号',
  `parkingPrice` int(11) DEFAULT NULL COMMENT '价格',
  `paymentStatus` int(4) DEFAULT '0' COMMENT '支付状态',
  PRIMARY KEY (`parkingRecordsID`),
  KEY `r_userID` (`userID`) USING BTREE,
  KEY `r_parkingSpaceID` (`parkingSpaceID`) USING BTREE,
  KEY `r_garageID` (`garageID`) USING BTREE,
  KEY `r_numberPlate` (`numberPlate`) USING BTREE,
  CONSTRAINT `parkingrecords_ibfk_1` FOREIGN KEY (`parkingSpaceID`) REFERENCES `parkingspace` (`parkingSpaceID`),
  CONSTRAINT `parkingrecords_ibfk_2` FOREIGN KEY (`numberPlate`) REFERENCES `vehicle` (`numberPlate`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8mb4 COMMENT='停车记录表\r\n订单状态 ：1表示预约，2表示预约订单被取消，3表示正在停车（车已入库），4表示预约取车，5表示付款没有取车，6表示取车并付款';

-- ----------------------------
-- Records of parkingrecords
-- ----------------------------
INSERT INTO `parkingrecords` VALUES ('2', '1', '鄂A12233', '1', '1', '6', '2018-05-18 10:48:22', '2018-09-21 13:58:44', '11221122', '233', '0');
INSERT INTO `parkingrecords` VALUES ('5', '1', '苏B56789', '1', '1', '3', '2018-09-26 11:56:23', null, '1622026', null, '0');
INSERT INTO `parkingrecords` VALUES ('8', '1', '苏B56789', '1', '1', '3', '2018-09-26 12:10:37', null, '1622026', null, '0');
INSERT INTO `parkingrecords` VALUES ('9', '1', '苏B56789', '1', '1', '3', '2018-09-26 13:44:25', null, '1622026', null, '0');
INSERT INTO `parkingrecords` VALUES ('10', '1', '苏B56789', '1', '1', '3', '2018-09-26 13:47:00', null, '1622026', null, '0');
INSERT INTO `parkingrecords` VALUES ('11', '1', '苏B56789', '1', '1', '3', '2018-09-26 14:00:08', null, '1624203', null, '0');
INSERT INTO `parkingrecords` VALUES ('12', '8', '苏B56789', '1', '1', '3', '2018-09-26 14:58:34', null, '1494417', null, '0');
INSERT INTO `parkingrecords` VALUES ('13', '8', '苏B56789', '1', '1', '3', '2018-09-26 16:21:05', null, '1345361', null, '0');
INSERT INTO `parkingrecords` VALUES ('14', '8', '苏B56789', '1', '1', '3', '2018-09-26 16:26:00', null, '1180161', null, '0');
INSERT INTO `parkingrecords` VALUES ('15', '1', '苏B56789', '1', '1', '6', '2018-09-26 16:29:16', '2018-09-27 10:18:59', '1527193', '40', '0');
INSERT INTO `parkingrecords` VALUES ('16', '8', '苏B56789', '1', '1', '6', '2018-09-27 10:44:45', '2018-09-27 11:12:34', '1002214', '5', '0');
INSERT INTO `parkingrecords` VALUES ('17', '8', '苏B56789', '1', '1', '6', '2018-09-27 13:57:59', '2018-09-27 15:02:42', '1472774', '5', '0');
INSERT INTO `parkingrecords` VALUES ('18', '8', '苏B56789', '1', '1', '6', '2018-09-27 16:17:24', '2018-09-27 16:40:34', '1044488', '5', '0');
INSERT INTO `parkingrecords` VALUES ('19', '8', '苏B56789', '1', '1', '6', '2018-09-28 09:36:49', '2018-09-28 09:43:40', '1145362', '5', '0');
INSERT INTO `parkingrecords` VALUES ('20', '8', '苏B56789', '1', '1', '6', '2018-09-28 10:01:09', '2018-09-28 10:17:07', '1732795', '5', '0');
INSERT INTO `parkingrecords` VALUES ('21', '8', '苏B56789', '1', '1', '3', '2018-09-28 13:44:43', null, '1508983', null, '0');
INSERT INTO `parkingrecords` VALUES ('22', '8', '桂K88888', '1', '1', '6', '2018-09-30 10:13:48', '2018-09-30 10:50:41', '1313380', '5', '0');
INSERT INTO `parkingrecords` VALUES ('25', '8', '桂K88888', '1', '1', '3', '2018-09-30 10:59:45', null, '1542033', null, '0');
INSERT INTO `parkingrecords` VALUES ('26', '8', '桂K88888', '1', '1', '6', '2018-09-30 11:10:01', '2018-09-30 11:11:22', '1789265', '5', '0');
INSERT INTO `parkingrecords` VALUES ('27', '8', '桂K88888', '1', '1', '6', '2018-09-30 13:54:21', '2018-09-30 13:56:10', '1303863', '5', '0');
INSERT INTO `parkingrecords` VALUES ('28', '8', '桂K88888', '1', '1', '6', '2018-09-30 14:09:12', '2018-09-30 14:10:11', '1791456', '5', '0');
INSERT INTO `parkingrecords` VALUES ('29', '8', '桂K88888', '1', '1', '6', '2018-09-30 15:03:59', '2018-09-30 15:04:54', '1363018', '5', '0');
INSERT INTO `parkingrecords` VALUES ('30', '8', '桂K88888', '1', '1', '6', '2018-09-30 15:15:41', '2018-09-30 15:16:19', '1713154', '5', '0');
INSERT INTO `parkingrecords` VALUES ('31', '8', '桂K88888', '1', '1', '6', '2018-09-30 15:23:53', '2018-09-30 15:24:34', '1073471', '5', '0');
INSERT INTO `parkingrecords` VALUES ('32', '8', '桂K88888', '1', '1', '6', '2018-09-30 15:29:57', '2018-09-30 15:30:30', '1787452', '5', '0');
INSERT INTO `parkingrecords` VALUES ('33', '8', '桂K88888', '1', '1', '6', '2018-09-30 15:40:31', '2018-09-30 15:41:13', '1905061', '5', '0');
INSERT INTO `parkingrecords` VALUES ('34', '8', '桂K88888', '1', '1', '6', '2018-09-30 16:02:56', '2018-09-30 16:06:32', '1615494', '5', '0');
INSERT INTO `parkingrecords` VALUES ('35', '1', '桂K88888', '1', '1', '3', '2018-09-30 16:09:23', null, '1195242', null, '0');
INSERT INTO `parkingrecords` VALUES ('36', '8', '桂K88888', '1', '1', '6', '2018-09-30 17:48:30', '2018-09-30 17:49:34', '1266260', '5', '0');
INSERT INTO `parkingrecords` VALUES ('37', '8', '苏B56789', '1', '1', '6', '2018-10-18 18:10:04', '2018-10-18 18:12:07', '1112262', '3', '0');
INSERT INTO `parkingrecords` VALUES ('38', '1', '苏B56789', '1', '1', '3', '2018-10-24 15:23:58', null, '1228329', null, '0');
INSERT INTO `parkingrecords` VALUES ('39', '1', '桂K88888', '1', '1', '3', '2018-10-26 19:18:14', null, '1742459', null, '0');
INSERT INTO `parkingrecords` VALUES ('40', '1', '冀E5942Z', '1', '1', '6', '2018-10-29 16:27:45', '2018-10-29 16:59:21', '1203521', '3', '0');
INSERT INTO `parkingrecords` VALUES ('41', '28', '冀E5942Z', '1', '1', '3', '2018-10-29 17:44:41', null, '0', null, '0');
INSERT INTO `parkingrecords` VALUES ('42', '28', '冀E5942Z', '1', '1', '6', '2018-10-29 18:03:01', '2018-10-29 18:09:18', '1128960', '3', '0');
INSERT INTO `parkingrecords` VALUES ('43', '1', '桂K88888', '1', '1', '6', '2018-10-30 09:54:11', '2018-10-30 10:04:06', '1841507', '3', '2');
INSERT INTO `parkingrecords` VALUES ('44', '1', '桂K88888', '1', '1', '3', '2018-10-30 10:55:06', null, '0', null, '0');
INSERT INTO `parkingrecords` VALUES ('45', '1', '桂K88888', '1', '1', '6', '2018-10-30 14:28:56', '2018-10-30 14:34:01', '1403530', '3', '2');
INSERT INTO `parkingrecords` VALUES ('46', '1', '桂K88888', '1', '1', '6', '2018-10-30 15:17:07', '2018-10-30 15:17:34', '1668397', '3', '2');
INSERT INTO `parkingrecords` VALUES ('47', '1', '桂K88888', '1', '1', '6', '2018-10-30 16:45:56', '2018-12-01 15:45:17', '1809574', '1440', '2');
INSERT INTO `parkingrecords` VALUES ('48', '28', '桂K88888', '1', '1', '6', '2018-10-30 16:59:00', '2018-10-31 12:15:34', '1424288', '30', '2');
INSERT INTO `parkingrecords` VALUES ('49', '28', '桂K88888', '1', '1', '6', '2018-10-31 12:22:27', '2018-10-31 14:36:03', '1417303', '9', '0');
INSERT INTO `parkingrecords` VALUES ('50', '28', '桂K88888', '1', '1', '6', '2018-10-31 15:03:34', '2018-10-31 15:04:30', '1908614', '0', '0');
INSERT INTO `parkingrecords` VALUES ('51', '28', '桂K888S8', '1', '1', '6', '2018-10-31 16:36:14', '2018-11-02 14:51:49', '1803570', '30', '2');
INSERT INTO `parkingrecords` VALUES ('52', '28', '桂K88888', '1', '1', '6', '2018-10-31 16:45:57', '2018-10-31 16:48:50', '1403631', '0', '0');
INSERT INTO `parkingrecords` VALUES ('53', '1', '冀E5942Z', '1', '1', '3', '2018-11-01 12:01:37', null, '0', null, '0');
INSERT INTO `parkingrecords` VALUES ('54', '1', '冀E5942Z', '1', '1', '6', '2018-11-01 18:22:49', '2018-11-02 14:43:36', '1357863', '30', '0');
INSERT INTO `parkingrecords` VALUES ('55', '1', '冀E5942Z', '1', '1', '6', '2018-11-02 11:13:44', '2018-11-02 13:53:12', '1542039', '9', '2');
INSERT INTO `parkingrecords` VALUES ('56', '1', '冀E5942Z', '1', '1', '6', '2018-11-02 13:46:50', '2018-11-02 13:51:40', '1512420', '0', '2');
INSERT INTO `parkingrecords` VALUES ('57', '1', '冀E5942Z', '1', '1', '6', '2018-11-02 16:28:57', '2018-12-01 15:45:17', '1809574', '1440', '2');
INSERT INTO `parkingrecords` VALUES ('58', '1', '冀E5942Z', '1', '1', '6', '2018-11-02 17:05:20', '2018-11-02 17:37:32', '1319356', '0', '2');
INSERT INTO `parkingrecords` VALUES ('59', '1', '桂K88888', '1', '1', '3', '2018-11-02 17:05:38', null, '0', null, '0');
INSERT INTO `parkingrecords` VALUES ('60', '1', '桂K88888', '1', '1', '3', '2018-11-02 17:17:05', null, '0', null, '0');
INSERT INTO `parkingrecords` VALUES ('61', '1', '桂K88888', '1', '1', '6', '2018-11-02 17:31:17', '2018-11-02 17:55:24', '1014233', '0', '2');
INSERT INTO `parkingrecords` VALUES ('62', '1', '冀E5942Z', '1', '1', '6', '2018-11-02 17:33:28', '2018-11-02 17:37:32', '1319356', '0', '2');
INSERT INTO `parkingrecords` VALUES ('63', '1', '桂K88888', '1', '1', '6', '2018-11-02 17:33:35', '2018-11-02 17:37:54', '1697756', '0', '2');
INSERT INTO `parkingrecords` VALUES ('64', '1', '桂K88888', '1', '1', '3', '2018-11-06 16:21:23', null, '0', null, '0');
INSERT INTO `parkingrecords` VALUES ('65', '1', '桂K88888', '1', '1', '6', '2018-11-06 16:38:38', '2018-11-06 16:49:22', '1323758', '0', '2');
INSERT INTO `parkingrecords` VALUES ('66', '1', '桂K88888', '1', '1', '3', '2018-11-07 16:21:02', null, '1143459', null, '0');
INSERT INTO `parkingrecords` VALUES ('67', '1', '桂K88888', '1', '1', '6', '2018-11-19 16:44:46', '2018-11-19 16:56:16', '1681655', '0', '2');
INSERT INTO `parkingrecords` VALUES ('68', '1', '桂K88888', '1', '1', '3', '2018-11-20 17:34:10', null, '1875784', null, '0');
INSERT INTO `parkingrecords` VALUES ('69', '1', '桂K88888', '1', '1', '6', '2018-11-20 17:57:53', '2018-11-21 18:05:33', '1934622', '45', '2');
INSERT INTO `parkingrecords` VALUES ('70', '1', '桂K88888', '1', '1', '6', '2018-11-20 18:19:34', '2018-11-22 16:47:29', '1406008', '55', '2');
INSERT INTO `parkingrecords` VALUES ('71', '1', '桂K88888', '1', '1', '3', '2018-11-21 16:31:34', null, '1855999', null, '0');
INSERT INTO `parkingrecords` VALUES ('72', '1', '桂K88888', '1', '1', '6', '2018-11-21 16:54:53', '2018-11-22 17:05:35', '1949669', '40', '2');
INSERT INTO `parkingrecords` VALUES ('73', '1', '桂K88888', '1', '1', '6', '2018-11-21 17:34:32', '2018-11-22 17:16:48', '1460653', '40', '2');
INSERT INTO `parkingrecords` VALUES ('74', '1', '桂K88888', '1', '1', '6', '2018-11-21 17:42:08', '2018-11-22 17:56:27', '1831761', '45', '2');
INSERT INTO `parkingrecords` VALUES ('75', '1', '桂K88888', '1', '1', '3', '2018-11-21 17:43:48', null, '1735393', null, '0');
INSERT INTO `parkingrecords` VALUES ('76', '1', '桂K88888', '1', '1', '3', '2018-11-23 14:24:08', null, '1243846', null, '0');
INSERT INTO `parkingrecords` VALUES ('77', '1', '桂K88888', '1', '1', '6', '2018-11-28 15:02:29', '2018-11-28 15:46:07', '19904197', '0', '2');
INSERT INTO `parkingrecords` VALUES ('78', '8', '桂K88888', '1', '1', '6', '2018-11-28 16:36:06', '2018-11-29 09:25:59', '11693929', '45', '2');
INSERT INTO `parkingrecords` VALUES ('79', '8', '桂K88888', '1', '1', '6', '2018-11-28 17:14:34', '2018-11-29 09:28:05', '13000056', '45', '2');
INSERT INTO `parkingrecords` VALUES ('80', '8', '桂K88888', '1', '1', '6', '2018-11-28 17:29:54', '2018-11-30 17:26:45', '11353354', '90', '2');
INSERT INTO `parkingrecords` VALUES ('81', '1', '桂K88888', '1', '1', '6', '2018-11-28 18:03:08', '2018-11-30 17:26:45', '11353354', '90', '2');
INSERT INTO `parkingrecords` VALUES ('82', '8', '桂K88888', '1', '1', '3', '2018-11-28 18:26:03', null, '13286054', null, '0');
INSERT INTO `parkingrecords` VALUES ('83', '8', '桂K88888', '1', '1', '3', '2018-11-29 11:05:18', null, '11080629', null, '0');
INSERT INTO `parkingrecords` VALUES ('84', '8', '桂K88888', '1', '1', '6', '2018-11-29 11:11:55', '2018-11-29 11:29:02', '18217415', '0', '2');
INSERT INTO `parkingrecords` VALUES ('85', '28', '桂K88888', '1', '1', '3', '2018-11-29 11:33:24', null, '16495655', null, '0');
INSERT INTO `parkingrecords` VALUES ('86', '28', '桂K88888', '1', '1', '3', '2018-11-29 14:36:16', null, '18009734', null, '0');
INSERT INTO `parkingrecords` VALUES ('87', '1', '桂K88888', '1', '1', '3', '2018-11-29 14:45:24', null, '11726712', null, '0');
INSERT INTO `parkingrecords` VALUES ('88', '1', '桂K88888', '1', '1', '3', '2018-11-29 14:47:29', null, '17828365', null, '0');
INSERT INTO `parkingrecords` VALUES ('89', '1', '桂K88888', '1', '1', '3', '2018-11-29 14:49:02', null, '14255689', null, '0');
INSERT INTO `parkingrecords` VALUES ('90', '28', '桂K88888', '1', '1', '3', '2018-11-29 14:53:02', null, '19620689', null, '0');
INSERT INTO `parkingrecords` VALUES ('91', '28', '桂K88888', '1', '1', '3', '2018-11-29 14:58:19', null, '10596443', null, '0');
INSERT INTO `parkingrecords` VALUES ('92', '1', '桂K88888', '1', '1', '6', '2018-11-30 16:43:12', '2018-11-30 17:23:57', '19137507', '0', '2');
INSERT INTO `parkingrecords` VALUES ('93', '1', '桂K88888', '1', '1', '3', '2018-11-30 17:08:29', null, '16495655', null, '0');
INSERT INTO `parkingrecords` VALUES ('94', '1', '桂K88888', '1', '1', '3', '2018-11-30 17:11:20', null, '17211871', null, '0');
INSERT INTO `parkingrecords` VALUES ('95', '1', '桂K88888', '1', '1', '6', '2018-12-01 15:41:59', '2018-12-01 15:45:17', '1809574', '1440', '2');
INSERT INTO `parkingrecords` VALUES ('96', '8', '桂K88888', '1', '1', '6', '2018-12-01 16:07:43', '2018-12-01 16:18:09', '10744640', '0', '2');

-- ----------------------------
-- Table structure for parkingspace
-- ----------------------------
DROP TABLE IF EXISTS `parkingspace`;
CREATE TABLE `parkingspace` (
  `parkingSpaceID` int(4) NOT NULL AUTO_INCREMENT COMMENT '车位ID',
  `parkingSpaceName` varchar(8) DEFAULT NULL COMMENT '车位编号',
  `parkingSpaceX` int(11) NOT NULL COMMENT '车位坐标X',
  `parkingSpaceY` int(11) NOT NULL COMMENT '车位坐标Y',
  `parkingSpaceZ` int(11) NOT NULL COMMENT '车位坐标Z',
  `parkingSpaceState` int(1) NOT NULL COMMENT '车位状态。0空闲，1占用，2已预约',
  PRIMARY KEY (`parkingSpaceID`)
) ENGINE=InnoDB AUTO_INCREMENT=5407 DEFAULT CHARSET=utf8mb4 COMMENT='车位信息表\r\n车位状态0表示空闲，1表示占用';

-- ----------------------------
-- Records of parkingspace
-- ----------------------------
INSERT INTO `parkingspace` VALUES ('1', 'a1', '0', '0', '0', '0');

-- ----------------------------
-- Table structure for paymentscheme
-- ----------------------------
DROP TABLE IF EXISTS `paymentscheme`;
CREATE TABLE `paymentscheme` (
  `paymentSchemeID` int(8) NOT NULL AUTO_INCREMENT,
  `schemeType` int(2) unsigned NOT NULL COMMENT '策略类型。1按时，2按天，3按时间段',
  `freeTime` int(4) NOT NULL COMMENT '单位：分钟',
  `firstChargeTime` int(4) NOT NULL COMMENT '首段收费时间，单位：分钟',
  `firstCharge` int(3) NOT NULL COMMENT '首段费用',
  `chargeInterval` int(4) NOT NULL COMMENT '间隔收费时间，单位：分钟',
  `intervalCharge` int(3) NOT NULL COMMENT '间隔收费单价',
  `upperBound` int(5) NOT NULL COMMENT '每日停车收费上限',
  `eachCharge` int(4) NOT NULL COMMENT '按次收费，每次费用',
  `overnightCharge` int(3) NOT NULL COMMENT '按次收费，加收过夜费',
  `startChargeTime` varchar(30) NOT NULL COMMENT '按时间段收费，起始时间',
  `endChargeTime` varchar(30) NOT NULL COMMENT '按时间段收费，终止时间',
  `chargeStandard` int(4) NOT NULL COMMENT '按时间段收费，每小时费用',
  `monthCardCharge` int(4) NOT NULL COMMENT '月卡办理价格',
  `seasonCardCharge` int(4) NOT NULL COMMENT '季卡办理价格',
  `halfYearCardCharge` int(4) NOT NULL COMMENT '半年卡办理价格',
  `yearCardCharge` int(4) NOT NULL COMMENT '年卡办理价格',
  `bookCharge` int(4) NOT NULL COMMENT '预约小时费用',
  PRIMARY KEY (`paymentSchemeID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of paymentscheme
-- ----------------------------
INSERT INTO `paymentscheme` VALUES ('1', '1', '1', '1', '3', '1', '3', '45', '25', '15', '8:30:00', '23:30:00', '6', '288', '588', '888', '1288', '4');

-- ----------------------------
-- Table structure for permission
-- ----------------------------
DROP TABLE IF EXISTS `permission`;
CREATE TABLE `permission` (
  `permissionID` int(8) NOT NULL AUTO_INCREMENT,
  `permissionName` varchar(50) NOT NULL,
  PRIMARY KEY (`permissionID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of permission
-- ----------------------------

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `roleID` int(8) NOT NULL,
  `roleName` varchar(30) NOT NULL COMMENT '角色名',
  PRIMARY KEY (`roleID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of role
-- ----------------------------

-- ----------------------------
-- Table structure for rolepermissionrelation
-- ----------------------------
DROP TABLE IF EXISTS `rolepermissionrelation`;
CREATE TABLE `rolepermissionrelation` (
  `roleID` int(8) NOT NULL,
  `permissionID` int(8) NOT NULL,
  PRIMARY KEY (`roleID`),
  KEY `rolePermissionRelation` (`permissionID`),
  CONSTRAINT `rolepermissionrelation_ibfk_1` FOREIGN KEY (`permissionID`) REFERENCES `permission` (`permissionID`),
  CONSTRAINT `rolepermissionrelation_ibfk_2` FOREIGN KEY (`roleID`) REFERENCES `role` (`roleID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of rolepermissionrelation
-- ----------------------------

-- ----------------------------
-- Table structure for vehicle
-- ----------------------------
DROP TABLE IF EXISTS `vehicle`;
CREATE TABLE `vehicle` (
  `numberPlate` char(8) NOT NULL COMMENT '车牌号',
  `vehicleTypeID` int(8) DEFAULT '0' COMMENT '车型ID',
  `vehicleTypeConfirm` int(1) NOT NULL DEFAULT '0' COMMENT '车型确认状态',
  `vehicleTypeChange` int(1) NOT NULL DEFAULT '5' COMMENT '车型可修改次数',
  `parkingSpaceID` int(4) DEFAULT NULL COMMENT '车位ID',
  `garageID` int(4) DEFAULT NULL COMMENT '车库ID',
  `vehiclepParkState` int(1) NOT NULL DEFAULT '0' COMMENT '车辆停车状态，0未停入，1停入，2停车中，3取车中，4停车预约，5预约取车',
  `orderRecordsID` int(10) unsigned DEFAULT NULL COMMENT '预约记录id',
  `parkingRecordsID` int(11) DEFAULT NULL COMMENT '停车记录ID',
  `frontwheelbase` int(11) NOT NULL DEFAULT '0' COMMENT '前轮轮距',
  `rearwheelbase` int(11) NOT NULL DEFAULT '0' COMMENT '后轮轮距',
  `monthCardType` int(1) unsigned zerofill NOT NULL DEFAULT '0' COMMENT '月卡类型，0无，1体验，2月，3季度，4半年，5年',
  `monthCardTime` varchar(50) DEFAULT NULL COMMENT '月卡到期时间',
  PRIMARY KEY (`numberPlate`),
  KEY `vehicleTypeID` (`vehicleTypeID`) USING BTREE,
  KEY `parkingSpaceID` (`parkingSpaceID`) USING BTREE,
  KEY `parkingRecordsID` (`parkingRecordsID`) USING BTREE,
  KEY `v_garageID` (`garageID`) USING BTREE,
  KEY `vehicle_ibfk_5` (`orderRecordsID`),
  CONSTRAINT `vehicle_ibfk_1` FOREIGN KEY (`parkingRecordsID`) REFERENCES `parkingrecords` (`parkingRecordsID`),
  CONSTRAINT `vehicle_ibfk_2` FOREIGN KEY (`parkingSpaceID`) REFERENCES `parkingspace` (`parkingSpaceID`),
  CONSTRAINT `vehicle_ibfk_5` FOREIGN KEY (`orderRecordsID`) REFERENCES `orderrecords` (`orderRecordsID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='车辆信息表\r\n停车状态：0表示未停车，1表示已停车，2表示用户已经发送停车指令但系统还未处理，3表示用户已经发送取车指令但系统还未处理，4表示用户已经发送预约停车指令，5表示用户已经发送预约取车指令\r\n车型确认状态：0表示未确认，1表示已确认。';

-- ----------------------------
-- Records of vehicle
-- ----------------------------
INSERT INTO `vehicle` VALUES ('冀E5942Z', null, '0', '5', null, null, '0', null, '58', '0', '0', '0', null);
INSERT INTO `vehicle` VALUES ('桂K88888', null, '0', '5', null, null, '0', '49', '96', '0', '0', '0', null);
INSERT INTO `vehicle` VALUES ('桂K888S8', null, '0', '5', null, null, '0', null, '51', '0', '0', '0', null);
INSERT INTO `vehicle` VALUES ('苏B56789', null, '0', '5', null, null, '4', '46', '38', '0', '0', '0', null);
INSERT INTO `vehicle` VALUES ('鄂A11111', '3', '0', '5', null, null, '0', null, null, '0', '0', '0', '');
INSERT INTO `vehicle` VALUES ('鄂A12233', null, '0', '5', null, null, '1', null, null, '0', '0', '0', '');
INSERT INTO `vehicle` VALUES ('鄂A12345', '2', '0', '5', null, null, '4', '25', null, '0', '0', '0', '');
INSERT INTO `vehicle` VALUES ('鄂A19999', '0', '0', '5', null, null, '4', '31', null, '0', '0', '0', null);
INSERT INTO `vehicle` VALUES ('鄂A22222', null, '0', '5', null, null, '0', null, null, '0', '0', '0', null);