登录 注册
开源 企业版 高校版 私有云 Gitee AI NEW
扫描微信二维码支付
取消
支付完成
Watch
不关注 关注所有动态 仅关注版本发行动态 关注但不提醒动态
2 Star 8 Fork 0

辰光/基于SpringMVC的校园车辆信息管理系统

代码 Issues 0 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
该仓库未声明开源许可证文件（LICENSE），使用请关注具体项目描述及其代码上游依赖。
项目仓库所选许可证以仓库主分支所使用许可证为准
克隆/下载
park_sbt.sql 14.86 KB
一键复制 编辑 原始数据 按行查看 历史
辰光 提交于 2023-11-03 08:04 . add park_sbt.sql.
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222
/*

Navicat MySQL Data Transfer



Source Server         : localhost

Source Server Version : 50624

Source Host           : localhost:3306

Source Database       : park_sbt



Target Server Type    : MYSQL

Target Server Version : 50624

File Encoding         : 65001



Date: 2023-04-12 23:44:22

*/



SET FOREIGN_KEY_CHECKS=0;



-- ----------------------------

-- Table structure for admin

-- ----------------------------

DROP TABLE IF EXISTS `admin`;

CREATE TABLE `admin` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `name` varchar(32) DEFAULT NULL,

  `password` varchar(32) DEFAULT NULL,

  `createDate` date DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of admin

-- ----------------------------

INSERT INTO `admin` VALUES ('1', 'admin', 'admin', '2023-04-06');



-- ----------------------------

-- Table structure for apply

-- ----------------------------

DROP TABLE IF EXISTS `apply`;

CREATE TABLE `apply` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `user_id` int(11) DEFAULT NULL,

  `create_time` datetime DEFAULT NULL,

  `update_id` int(11) DEFAULT NULL,

  `update_time` datetime DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of apply

-- ----------------------------

INSERT INTO `apply` VALUES ('10', '2', '2023-04-06 20:25:03', '1', '2023-04-12 16:49:58');

INSERT INTO `apply` VALUES ('11', '1', '2023-04-06 21:01:23', '1', '2023-04-12 11:07:18');

INSERT INTO `apply` VALUES ('12', '3', '2023-04-06 21:20:55', '1', '2023-04-09 21:39:35');

INSERT INTO `apply` VALUES ('13', '4', '2023-04-09 23:45:29', '1', '2023-04-09 23:45:52');

INSERT INTO `apply` VALUES ('14', '5', '2023-04-11 20:20:40', '1', '2023-04-12 14:17:15');

INSERT INTO `apply` VALUES ('15', '30', '2023-04-12 00:07:44', '1', '2023-04-12 14:17:18');

INSERT INTO `apply` VALUES ('16', '18', '2023-04-12 16:00:35', '1', '2023-04-12 16:01:11');

INSERT INTO `apply` VALUES ('17', '13', '2023-04-12 16:22:39', null, null);



-- ----------------------------

-- Table structure for car

-- ----------------------------

DROP TABLE IF EXISTS `car`;

CREATE TABLE `car` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `car_num` varchar(32) DEFAULT NULL,

  `car_type` varchar(20) DEFAULT NULL,

  `user_id` int(11) DEFAULT NULL,

  `user_name` varchar(32) DEFAULT NULL,

  `status` int(11) DEFAULT '0',

  `update_id` int(11) DEFAULT NULL,

  `update_time` datetime DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `car_num` (`car_num`),

  KEY `user_id` (`user_id`),

  KEY `user_name` (`user_name`),

  KEY `update_id` (`update_id`),

  CONSTRAINT `car_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON UPDATE CASCADE,

  CONSTRAINT `car_ibfk_2` FOREIGN KEY (`user_name`) REFERENCES `user` (`name`) ON UPDATE CASCADE,

  CONSTRAINT `car_ibfk_3` FOREIGN KEY (`update_id`) REFERENCES `admin` (`id`) ON UPDATE CASCADE

) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of car

-- ----------------------------

INSERT INTO `car` VALUES ('1', '黑A99999', '轿车', '1', '吴一', '0', '1', '2023-04-12 16:49:44');

INSERT INTO `car` VALUES ('2', '京A88888', '轿车', '30', 'user30', '0', '1', '2023-04-12 15:45:08');

INSERT INTO `car` VALUES ('6', '辽B45623', '轿车', '22', 'user22', '0', '1', '2023-04-12 15:45:10');

INSERT INTO `car` VALUES ('7', '吉A16534', '轿车', '18', 'user18', '0', '1', '2023-04-12 16:02:25');

INSERT INTO `car` VALUES ('8', '吉A16548', 'SUV', '3', '王五', '0', null, null);

INSERT INTO `car` VALUES ('9', '吉A16324', 'SUV', '3', '王五', '0', null, null);

INSERT INTO `car` VALUES ('10', '辽B25436', 'SUV', '2', '李四', '0', null, null);

INSERT INTO `car` VALUES ('11', '冀A16598', 'SUV', '2', '李四', '0', null, null);

INSERT INTO `car` VALUES ('12', '黑A96529', 'MPV', '2', '李四', '0', null, null);

INSERT INTO `car` VALUES ('13', '黑A36534', 'MPV', '11', 'user11', '0', null, null);

INSERT INTO `car` VALUES ('14', '黑A36523', '货车', '16', 'user16', '0', null, null);

INSERT INTO `car` VALUES ('15', '吉B65327', '货车', '16', 'user16', '0', null, null);

INSERT INTO `car` VALUES ('16', '京A96327', '货车', '16', 'user16', '0', null, null);

INSERT INTO `car` VALUES ('17', '辽A63235', '货车', '13', 'user13', '0', null, null);

INSERT INTO `car` VALUES ('18', '鲁A23623', '货车', '13', 'user13', '0', null, null);

INSERT INTO `car` VALUES ('19', '黑A65239', '货车', '1', '吴一', '0', '1', '2023-04-12 16:49:36');



-- ----------------------------

-- Table structure for carapply

-- ----------------------------

DROP TABLE IF EXISTS `carapply`;

CREATE TABLE `carapply` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `car_num` varchar(20) DEFAULT NULL,

  `user_id` int(11) DEFAULT NULL,

  `user_name` varchar(32) DEFAULT NULL,

  `apply_time` datetime DEFAULT NULL,

  `update_id` int(11) DEFAULT NULL,

  `update_time` datetime DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `car_num` (`car_num`),

  KEY `user_name` (`user_name`),

  KEY `user_id` (`user_id`)

) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of carapply

-- ----------------------------

INSERT INTO `carapply` VALUES ('3', '黑A99999', '1', '吴一', '2023-04-12 15:32:29', '1', '2023-04-12 16:49:44');

INSERT INTO `carapply` VALUES ('4', '京A88888', '30', 'user30', '2023-04-12 15:34:14', '1', '2023-04-12 15:45:08');

INSERT INTO `carapply` VALUES ('5', '辽B45623', '22', 'user22', '2023-04-12 15:44:32', '1', '2023-04-12 15:45:10');

INSERT INTO `carapply` VALUES ('6', '吉A16534', '18', 'user18', '2023-04-12 16:00:46', '1', '2023-04-12 16:02:25');

INSERT INTO `carapply` VALUES ('7', '吉A16548', '3', '王五', '2023-04-12 16:15:52', null, null);

INSERT INTO `carapply` VALUES ('8', '吉A16324', '3', '王五', '2023-04-12 16:16:03', null, null);

INSERT INTO `carapply` VALUES ('9', '辽B25436', '2', '李四', '2023-04-12 16:16:54', null, null);

INSERT INTO `carapply` VALUES ('10', '冀A16598', '2', '李四', '2023-04-12 16:17:48', null, null);

INSERT INTO `carapply` VALUES ('11', '黑A96529', '2', '李四', '2023-04-12 16:18:06', null, null);

INSERT INTO `carapply` VALUES ('12', '黑A36534', '11', 'user11', '2023-04-12 16:18:22', null, null);

INSERT INTO `carapply` VALUES ('13', '黑A36523', '16', 'user16', '2023-04-12 16:21:02', null, null);

INSERT INTO `carapply` VALUES ('14', '吉B65327', '16', 'user16', '2023-04-12 16:22:05', null, null);

INSERT INTO `carapply` VALUES ('15', '京A96327', '16', 'user16', '2023-04-12 16:22:23', null, null);

INSERT INTO `carapply` VALUES ('16', '辽A63235', '13', 'user13', '2023-04-12 16:22:57', null, null);

INSERT INTO `carapply` VALUES ('17', '鲁A23623', '13', 'user13', '2023-04-12 16:23:16', null, null);

INSERT INTO `carapply` VALUES ('18', '黑A65239', '1', '吴一', '2023-04-12 16:48:16', '1', '2023-04-12 16:49:36');



-- ----------------------------

-- Table structure for notice

-- ----------------------------

DROP TABLE IF EXISTS `notice`;

CREATE TABLE `notice` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `title` varchar(20) DEFAULT NULL,

  `content` varchar(200) DEFAULT NULL,

  `create_time` datetime DEFAULT NULL,

  `create_id` int(11) DEFAULT NULL,

  `update_time` datetime DEFAULT NULL,

  `update_id` int(11) DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COMMENT='公告表';



-- ----------------------------

-- Records of notice

-- ----------------------------

INSERT INTO `notice` VALUES ('1', '请按规定停车', '校内公务车及教职工私家车进入校园后，请自觉在划定的车位规范停放，未划定停车位的路段、场地禁止停放车辆。', '2023-03-29 15:51:47', '1', '2023-04-12 15:46:17', '1');

INSERT INTO `notice` VALUES ('2', '电动车及自行车请勿随意停放', '电动车及自行车应停放在非机动车停车位内，不得在道路、机动车位及行人通行区域随意停放。', '2023-03-29 15:51:51', '1', '2023-04-12 15:46:39', '1');

INSERT INTO `notice` VALUES ('3', '车辆停放要整齐', '车辆停放要遵循整齐、有序原则，按停车位标线停放，做到线内停车，不挤占车位，机动车与非机动车互不混停。 ', '2023-03-29 15:52:17', '1', '2023-04-12 15:47:07', '1');

INSERT INTO `notice` VALUES ('4', '保卫部将加大整治力度', '保卫部将加大校园规范停车秩序整治力度，对违规停放的车辆予以抄牌并通报相关职能部门，作为其所在单位及个人的精神文明建设、师德师风建设、安全稳定工作等评选考核的重要参考依据。', '2023-04-02 19:34:27', '1', '2023-04-12 15:47:38', '1');

INSERT INTO `notice` VALUES ('6', '家属区内禁止停放', '家属区内禁止停放一切非机动车辆，各住户的摩托车和非机动车辆，应按规定办理存车手续，到指定地点停放。', '2023-04-02 19:42:42', '1', '2023-04-12 15:48:20', '1');

INSERT INTO `notice` VALUES ('9', '请尽量从正门出入校园', '在检查过程中发现学校正门停车场余位较多，请大家尽量从正门出入校园', '2023-04-04 12:29:04', '1', '2023-04-12 15:48:53', '1');

INSERT INTO `notice` VALUES ('11', '请勿违反相关规定', '对违规停放的车辆安全工作部将采取正确引导，前两次进行贴条警告，对两次以上违规停车者将做取消门禁自动识别进校处理。', '2023-04-04 13:10:24', '1', '2023-04-12 15:49:23', '1');

INSERT INTO `notice` VALUES ('13', '请自觉爱护环境卫生', '请自觉爱护停车场内的环境卫生，爱护停车场内的公共设施，共同维护好停车场内的公共秩序。', '2023-04-04 16:26:16', '1', '2023-04-12 15:52:06', '1');

INSERT INTO `notice` VALUES ('15', '离车锁好车门', '驾驶员离开车辆时，要锁好车门、车窗及后备箱，不要将贵重物品放在车内，以免造成物品丢失。', '2023-04-04 16:30:31', '1', '2023-04-12 15:51:06', '1');

INSERT INTO `notice` VALUES ('19', '不得在停车场内长时间停留', '车辆进入车位后，驾驶员及乘车人不得在停车场内长时间停留，并由行人通道离开停车场，以免发生意外。', '2023-04-11 19:58:15', '1', '2023-04-12 15:51:26', '1');

INSERT INTO `notice` VALUES ('20', '请按指定路线行驶', '车辆进入停车场后请按指定路线行驶，注意安全礼让，不得占用消防通道，未标识区域不得随意停放车辆。', '2023-04-11 20:46:50', '1', '2023-04-12 15:51:41', '1');



-- ----------------------------

-- Table structure for user

-- ----------------------------

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `name` varchar(32) DEFAULT NULL,

  `password` varchar(32) DEFAULT NULL,

  `phone` varchar(20) DEFAULT NULL,

  `status` int(11) DEFAULT '0',

  `vip_status` int(11) DEFAULT '0',

  `create_time` datetime DEFAULT NULL,

  `update_id` int(11) DEFAULT NULL,

  `update_time` datetime DEFAULT NULL,

  `department` varchar(50) DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `name` (`name`)

) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;



-- ----------------------------

-- Records of user

-- ----------------------------

INSERT INTO `user` VALUES ('1', '吴一', '123', '1231', '0', '1', '2023-04-05 11:08:40', '1', '2023-04-12 11:07:18', '信息与计算机学院');

INSERT INTO `user` VALUES ('2', '李四', '123', '1232', '0', '1', '2023-04-06 09:40:58', '1', '2023-04-12 16:49:58', '林学院');

INSERT INTO `user` VALUES ('3', '王五', '123', '1233', '0', '0', '2023-04-06 21:20:46', '1', '2023-04-09 21:39:35', '教务处');

INSERT INTO `user` VALUES ('4', '张三', '123', '1234', '0', '0', '2023-04-09 23:36:31', '1', '2023-04-09 23:45:52', '学工部');

INSERT INTO `user` VALUES ('5', '陈四', '123', '1235', '0', '0', '2023-04-11 19:09:06', null, null, '信息与计算机学院');

INSERT INTO `user` VALUES ('6', 'user6', '123', '1236', '0', '0', '2023-04-11 20:11:08', null, null, '土木工程学院');

INSERT INTO `user` VALUES ('7', 'user7', '123', '1237', '0', '0', '2023-04-11 20:11:12', null, null, '土木工程学院');

INSERT INTO `user` VALUES ('8', 'user8', '123', '1238', '0', '0', '2023-04-11 20:11:15', null, null, '信息与计算机工程学院');

INSERT INTO `user` VALUES ('9', 'user9', '123', '1239', '0', '0', '2023-04-11 20:11:19', null, null, '理学院');

INSERT INTO `user` VALUES ('10', 'user10', '123', '12310', '0', '0', '2023-04-11 20:11:22', null, null, '外国语学院');

INSERT INTO `user` VALUES ('11', 'user11', '123', '12311', '0', '0', '2023-04-11 20:11:25', null, null, '土木工程学院');

INSERT INTO `user` VALUES ('12', 'user12', '123', '12312', '0', '0', '2023-04-11 20:11:27', null, null, '外国语学院');

INSERT INTO `user` VALUES ('13', 'user13', '123', '12313', '0', '0', '2023-04-11 20:11:32', null, null, '教务处');

INSERT INTO `user` VALUES ('14', 'user14', '123', '12314', '0', '0', '2023-04-11 20:11:34', null, null, '学工部');

INSERT INTO `user` VALUES ('15', 'user15', '123', '12315', '0', '0', '2023-04-11 20:11:37', null, null, '非校内人员');

INSERT INTO `user` VALUES ('16', 'user16', '123', '12316', '0', '0', '2023-04-11 20:11:41', null, null, '信息与计算机学院');

INSERT INTO `user` VALUES ('17', 'user17', '123', '12317', '0', '0', '2023-04-11 20:11:43', null, null, '信息与计算机学院');

INSERT INTO `user` VALUES ('18', 'user18', '123', '12318', '0', '0', '2023-04-11 20:11:46', '1', '2023-04-12 16:01:11', '外国语学院');

INSERT INTO `user` VALUES ('19', 'user19', '123', '12319', '0', '0', '2023-04-11 20:11:48', null, null, '外国语学院');

INSERT INTO `user` VALUES ('20', 'user20', '123', '12320', '0', '0', '2023-04-11 20:11:51', null, null, '理学院');

INSERT INTO `user` VALUES ('21', 'user21', '123', '12321', '0', '0', '2023-04-11 20:11:53', null, null, '非校内人员');

INSERT INTO `user` VALUES ('22', 'user22', '123', '12322', '0', '0', '2023-04-11 20:11:56', null, null, '林学院');

INSERT INTO `user` VALUES ('23', 'user23', '123', '12323', '0', '0', '2023-04-11 20:11:58', null, null, '林学院');

INSERT INTO `user` VALUES ('24', 'user24', '123', '12324', '0', '0', '2023-04-11 20:12:01', null, null, '学工部');

INSERT INTO `user` VALUES ('25', 'user25', '123', '12325', '0', '0', '2023-04-11 20:12:03', null, null, '教务处');

INSERT INTO `user` VALUES ('26', 'user26', '123', '12326', '0', '0', '2023-04-11 20:12:06', null, null, '理学院');

INSERT INTO `user` VALUES ('27', 'user27', '123', '12327', '0', '0', '2023-04-11 20:12:08', null, null, '学工部');

INSERT INTO `user` VALUES ('28', 'user28', '123', '12328', '0', '0', '2023-04-11 20:12:11', null, null, '非校内人员');

INSERT INTO `user` VALUES ('29', 'user29', '123', '12329', '0', '0', '2023-04-11 20:12:12', null, null, '土木工程学院');

INSERT INTO `user` VALUES ('30', 'user30', '123', '12330', '0', '0', '2023-04-11 20:12:14', null, null, '信息与计算机学院');
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
Java
1
https://gitee.com/niu-ZUO/production-car.git
git@gitee.com:niu-ZUO/production-car.git
niu-ZUO
production-car
基于SpringMVC的校园车辆信息管理系统
master
点此查找更多帮助

搜索帮助

Git 命令在线学习 如何在 Gitee 导入 GitHub 仓库
Git 仓库基础操作
企业版和社区版功能对比
SSH 公钥设置
如何处理代码冲突
仓库体积过大，如何减小？
如何找回被删除的仓库数据
Gitee 产品配额说明
GitHub仓库快速导入Gitee及同步更新
什么是 Release（发行版）
将 PHP 项目自动发布到 packagist.org
评论
仓库举报
回到顶部