Java 汽车租赁管理系统

Java 汽车租赁管理系统 数据库配置说明xmsql

 

 

-- ----------------------------
-- Table structure for car
-- ----------------------------
DROP TABLE IF EXISTS `car`;
CREATE TABLE `car` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `goodsId` int(11) DEFAULT NULL,
  `userId` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_pvkclq3v68c3acqo6ivqh2f92` (`goodsId`),
  KEY `FK_ep0mtwg2w4rju18rk2wm153wg` (`userId`),
  CONSTRAINT `FK_ep0mtwg2w4rju18rk2wm153wg` FOREIGN KEY (`userId`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_pvkclq3v68c3acqo6ivqh2f92` FOREIGN KEY (`goodsId`) REFERENCES `goods` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of car
-- ----------------------------

-- ----------------------------
-- Table structure for dd
-- ----------------------------
DROP TABLE IF EXISTS `dd`;
CREATE TABLE `dd` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `goodsId` int(11) DEFAULT NULL,
  `userId` int(11) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_548toqb33aavwqnpti6to5fwv` (`goodsId`),
  KEY `FK_ictbe1fmckey0v1blmqidtbbh` (`userId`),
  CONSTRAINT `FK_548toqb33aavwqnpti6to5fwv` FOREIGN KEY (`goodsId`) REFERENCES `goods` (`id`),
  CONSTRAINT `FK_ictbe1fmckey0v1blmqidtbbh` FOREIGN KEY (`userId`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of dd
-- ----------------------------
INSERT INTO `dd` VALUES ('7', '7', '6', '17041521090001', '2017-04-15 21:09:02', null, ' 1测试', '12');

-- ----------------------------
-- Table structure for goods
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `isDelete` int(11) DEFAULT NULL,
  `price` double NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `url1` varchar(255) DEFAULT NULL,
  `url2` varchar(255) DEFAULT NULL,
  `url3` varchar(255) DEFAULT NULL,
  `url4` varchar(255) DEFAULT NULL,
  `ppId` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_m8jpxcm9wffl7vgvxeydquemp` (`ppId`),
  CONSTRAINT `FK_m8jpxcm9wffl7vgvxeydquemp` FOREIGN KEY (`ppId`) REFERENCES `pp` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

 

 

 

-- ----------------------------
-- Table structure for manage
-- ----------------------------
DROP TABLE IF EXISTS `manage`;
CREATE TABLE `manage` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `passWord` varchar(255) DEFAULT NULL,
  `realName` varchar(255) DEFAULT NULL,
  `type` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of manage
-- ----------------------------
INSERT INTO `manage` VALUES ('1', 'admin', '111111', '管理员', '1');

-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` longtext,
  `createTime` datetime DEFAULT NULL,
  `introduction` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of news
-- ----------------------------
INSERT INTO `news` VALUES ('1', '122233', null, null, '测试公告');

-- ----------------------------
-- Table structure for pp
-- ----------------------------
DROP TABLE IF EXISTS `pp`;
CREATE TABLE `pp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cpUrl` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `lbId` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_f1x00nmm3d4xdha0vvpccg1g7` (`lbId`),
  CONSTRAINT `FK_f1x00nmm3d4xdha0vvpccg1g7` FOREIGN KEY (`lbId`) REFERENCES `lb` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;