access_control.sql

/*
SQLyog Ultimate v12.08 (64 bit)
MySQL - 8.0.29 : Database - access_control
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`access_control` /*!40100 DEFAULT CHARACTER SET utf8mb3 */ /*!80016 DEFAULT ENCRYPTION='N' */;

USE `access_control`;

/*Table structure for table `admin` */

CREATE TABLE `admin` (
  `admin_id` varchar(50) NOT NULL,
  `admin_name` varchar(50) DEFAULT NULL COMMENT '名称',
  `admin_pwd` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码',
  `admin_root` int DEFAULT NULL COMMENT '1:超级管理员  2:普通管理员',
  PRIMARY KEY (`admin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

/*Data for the table `admin` */

insert  into `admin`(`admin_id`,`admin_name`,`admin_pwd`,`admin_root`) values ('0fcb9320cbc690c6f8048effe8e87996','111','l8oEOWzwJagkD/mQiGIvZgYfkZ1XQbD1vey3s5OdhO0=:OzZ5O74Si6eDg33kvbhrDA==',2),('5e3763cc6962edf312181f471bc8a95f','1','eqtFukOf7LmoR6z0G35DF5EHckc/EgMIIt/mAd4kh0k=:Xafk5mEtyu1925tsYimXnQ==',2),('84456423','123','6M4oIcjCQCoIXXmFHGc0sxb3l126tkDBeg29vA6UVEc=:IeJU/rnowGAVuORJWDsz6A==',1);

/*Table structure for table `charge` */

CREATE TABLE `charge` (
  `charge_id` varchar(50) NOT NULL COMMENT '收费id',
  `charge_hour` int DEFAULT NULL COMMENT '低于该小时按此计费',
  `charge_moeny` int DEFAULT NULL COMMENT '收费金额',
  `charge_hour_tf` int DEFAULT NULL COMMENT '0表示小时计费  1表示包天计费',
  PRIMARY KEY (`charge_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

/*Data for the table `charge` */

insert  into `charge`(`charge_id`,`charge_hour`,`charge_moeny`,`charge_hour_tf`) values ('1',24,5,0),('19d04b9bf597b64b0416622cac1bf676',90,1000,1),('3',30,500,1),('e0bedce62835bd4a5831ac84dc539f0e',180,2000,1);

/*Table structure for table `face_record` */

CREATE TABLE `face_record` (
  `face_record_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8_general_ci NOT NULL COMMENT '人员进出记录表',
  `gate_name` varchar(50) DEFAULT NULL COMMENT '闸机名',
  `user_type` int DEFAULT NULL COMMENT '用户类型',
  `start_time` datetime DEFAULT NULL COMMENT '进入时间',
  `end_time` datetime DEFAULT NULL COMMENT '出时间',
  `user_id` varchar(50) DEFAULT NULL COMMENT '用户ID',
  `user_name` varchar(50) DEFAULT NULL COMMENT '用户名',
  `user_phone` varchar(50) DEFAULT NULL COMMENT '用户手机号',
  PRIMARY KEY (`face_record_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

/*Data for the table `face_record` */

insert  into `face_record`(`face_record_id`,`gate_name`,`user_type`,`start_time`,`end_time`,`user_id`,`user_name`,`user_phone`) values ('0b9e493b92c626673763bed85188ae96','大门1',1,'2025-09-14 11:17:32','2025-09-14 11:17:35','ffda22b603b0cc788e4b84a2f6548283','李四','45454'),('148ab5568050a4e55799476e59b16ff8','大门1',2,'2025-09-21 10:04:18','2025-09-21 10:14:12','a819cf9cb59ff47aa6b52312f71ea8f4','刘亦菲','789789'),('1f9de99cd2120130226a0855292813d6','大门1',1,'2025-09-12 22:07:28','2025-09-12 22:23:35','ffda22b603b0cc788e4b84a2f6548283','李四','45454'),('2abd27db72ada56270b31b50a10e2722','大门1',1,'2025-09-14 11:20:46','2025-09-14 11:23:07','ffda22b603b0cc788e4b84a2f6548283','李四','45454'),('4a4c7b2f477f5702748c0f3203399bf9','大门1',1,'2025-09-21 09:40:34','2025-09-21 10:00:29','ffda22b603b0cc788e4b84a2f6548283','李四','45454'),('637621f18e9420bd86d58942dfd96cbe','大门1',2,'2025-09-23 18:50:20','2025-09-23 19:28:53','2c9deacc9fdcc72ce3220f56b3766419','王鹤棣','sdf'),('66e7803a66d86333c80ff8981489747f','大门1',2,'2025-09-21 13:19:16','2025-09-21 16:22:22','a819cf9cb59ff47aa6b52312f71ea8f4','刘亦菲','789789'),('9632556c96c8a9c1597c2f07522b1586','大门1',1,'2025-09-23 18:49:36','2025-09-23 18:49:43','6d0a5b29b90329590eece855d187b39a','吴彦祖','吴彦祖'),('96f00ac7085c2bd1707d51b547482ad8','大门1',2,'2025-09-12 22:07:22','2025-09-12 22:25:08','2c9deacc9fdcc72ce3220f56b3766419','王鹤棣','sdf'),('994567f450227b7f6a64dbebbfa3479d','大门1',1,'2025-09-12 19:53:38','2025-09-13 19:56:26','6d0a5b29b90329590eece855d187b39a','吴彦祖','吴彦祖'),('b400ab3983475e1a4ed759d3b41fc5a9','大门1',1,'2025-09-14 11:16:53','2025-09-14 11:17:06','ffda22b603b0cc788e4b84a2f6548283','李四','45454'),('c0de074926767b0c41d24fcdf3cd2d40','大门1',1,'2025-09-19 16:08:24','2025-09-19 16:08:57','ffda22b603b0cc788e4b84a2f6548283','李四','45454'),('cbdb47f043e1df6cf81296d4f7086629','大门1',1,'2025-09-14 11:28:47','2025-09-19 15:49:36','ffda22b603b0cc788e4b84a2f6548283','李四','45454'),('d418ef121b9ea0b49687133a3a1eec1a','大门1',2,'2025-09-19 15:55:52','2025-09-19 15:55:59','2c9deacc9fdcc72ce3220f56b3766419','王鹤棣','sdf'),('df0ce920c38b37f16d952b58e75c1a3a','大门1',1,'2025-09-10 19:53:38','2025-09-12 19:54:06','6d0a5b29b90329590eece855d187b39a','吴彦祖','吴彦祖');

/*Table structure for table `fee_records` */

CREATE TABLE `fee_records` (
  `fee_records_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8_general_ci NOT NULL COMMENT '未出车辆记录表',
  `fee_records_card` varchar(50) DEFAULT NULL COMMENT '车牌',
  `fee_records_type` int DEFAULT NULL COMMENT '车辆类型 1vip  2访客 3常驻',
  `start_time` datetime DEFAULT NULL COMMENT '时间',
  `fee_records_in` int DEFAULT NULL COMMENT '1：进',
  `money` decimal(10,2) DEFAULT NULL COMMENT '费用 进入费用0',
  `vip_parking_lot` varchar(50) DEFAULT NULL COMMENT '停车场ID',
  PRIMARY KEY (`fee_records_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

/*Data for the table `fee_records` */

insert  into `fee_records`(`fee_records_id`,`fee_records_card`,`fee_records_type`,`start_time`,`fee_records_in`,`money`,`vip_parking_lot`) values ('0cd78e4a0a21833cb380674d4eee2180','鲁V718N9',1,'2025-09-21 10:40:31',1,NULL,'1'),('995812f773a49bd19f14eb59b7a18ec3','赣G7E767',1,'2025-09-23 19:29:01',1,NULL,'1'),('fbf052371f7abc9abc5209688425a40b','粤A88888',1,'2025-09-21 16:22:11',1,NULL,'1');

/*Table structure for table `gate` */

CREATE TABLE `gate` (
  `gate_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8_general_ci NOT NULL COMMENT '人脸闸机ID',
  `gate_name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '人脸闸机名称',
  PRIMARY KEY (`gate_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

/*Data for the table `gate` */

insert  into `gate`(`gate_id`,`gate_name`) values ('1','大门1'),('4e49c485e1ffd08c5f9f41d62be3db25','大sss');

/*Table structure for table `page_router` */

CREATE TABLE `page_router` (
  `page_router_id` varchar(50) NOT NULL COMMENT '页面请求ID',
  `admin_root` int DEFAULT NULL COMMENT '1超管  2普管',
  `page_router_url` varchar(50) DEFAULT NULL COMMENT '页面请求路径',
  `page_router_name` varchar(50) DEFAULT NULL COMMENT '页面请求名称',
  `page_router_margin_id` varchar(50) DEFAULT NULL COMMENT '父级Id',
  `page_router_root` int DEFAULT NULL COMMENT '权重',
  PRIMARY KEY (`page_router_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

/*Data for the table `page_router` */

insert  into `page_router`(`page_router_id`,`admin_root`,`page_router_url`,`page_router_name`,`page_router_margin_id`,`page_router_root`) values ('1',1,'/home/statistics','统计',NULL,200),('10',1,'/home/gate','闸机管理','9',NULL),('11',1,'/home/personFace','人员进出记录','9',NULL),('11e89b0cd3ac1fb56ed50079cca197ca',2,'/home/gate-table','未出人员记录',NULL,1),('12',1,'/home/gate-table','未出人员记录','9',NULL),('13',1,NULL,'车辆闸机',NULL,2),('14',1,'/home/parking','闸机管理','13',NULL),('15',1,'/home/parking-table','未出车辆','13',NULL),('16',1,NULL,'系统设置',NULL,1),('17',1,'/home/rootview','请求路由设置','16',11),('18',1,'/home/system','角色请求路由管理','16',11),('19',1,'/home/strategy','通行策略','16',1),('2',1,'/home/tariff','收费记录',NULL,10),('20',1,'/home/pageRouterView','页面路由设置','16',10),('21',1,'/home/pageRouterRootView','角色页面权限设置','16',10),('3',1,'/home/visitor-table','访客单列表',NULL,10),('4',1,'/home/fees','车场收费设置',NULL,10),('4adeea54471d80fee41911451f7c15bb',2,'/home/gate','闸机管理',NULL,1),('5',1,'/home/unit','地址/部门设置',NULL,10),('582dbe5360cd6f8dd9184da38ea64287',2,'/home/gate-table','未出人员记录',NULL,1),('6',1,'/home/user','用户管理',NULL,10),('7',1,'/home/internal','内部车管理',NULL,10),('8',1,'/home/admin','管理员设置',NULL,10),('9',1,NULL,'人脸闸机',NULL,2),('9e6306dabf516154a937814cd756bbc8',2,'/home/parking-table','未出车辆',NULL,1);

/*Table structure for table `routing_role` */

CREATE TABLE `routing_role` (
  `routing_role_id` varchar(50) NOT NULL COMMENT '权限ID',
  `routing_role_type` int DEFAULT NULL COMMENT '1:超管 2:普管 3:用户',
  `routing_role_url` varchar(50) DEFAULT NULL COMMENT '请求路径',
  `routing_role_name` varchar(50) DEFAULT NULL COMMENT '请求名称',
  PRIMARY KEY (`routing_role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

/*Data for the table `routing_role` */

insert  into `routing_role`(`routing_role_id`,`routing_role_type`,`routing_role_url`,`routing_role_name`) values ('07c5063865737aaee3f94076df7b2745',2,'/visitor/insert','新增授权登记表'),('1',1,'/visitor/select','查找登记授权列表'),('10',1,'/userCar/select','获取非临时车牌列表'),('11',1,'/userCar/insert','添加非临时车牌'),('12',1,'/userCar/del','删除非临时车牌'),('13',1,'/user/update','修改用户信息'),('14',1,'/user/updataUserFace','更改门禁头像'),('15',1,'/user/login','用户登录'),('16',1,'/user/insert','注册用户'),('17',1,'/user/approval','人员进出对比登记'),('18',1,'/unit/update','修改单位数据'),('19',1,'/unit/select','获取单位或地址列表'),('2',1,'/vipParkingLot/update','修改内部停车点'),('20',1,'/unit/insert','添加单位数据'),('2041192d98f21a1d162deda8b4c8418a',2,'/userCar/select','获取非临时车牌列表'),('21',1,'/unit/del','删除单位数据'),('22',1,'/system/uploadFile','上传图片'),('23',1,'/settings/update','修改系统设置'),('24',1,'/settings/select','获取系统设置'),('25',1,'/routingRole/update','修改路由表'),('26',1,'/routingRole/select','获取路由表'),('27',1,'/routingRole/insert','新增路由表'),('28',1,'/routingRole/del','删除路由表'),('29',1,'/routingRole/deduplication','获取去重的路由表'),('3',1,'/vipParkingLot/select','获取内部停车点列表'),('30',1,'/gate/update','修改大门'),('31',1,'/gate/select','获取大门列表'),('32',1,'/gate/insert','添加大门'),('33',1,'/gate/del','删除大门'),('34',1,'/feeRecords/select','获取未出车辆列表'),('35',1,'/charge/update','修改收费列表'),('36',1,'/charge/select','获取收费列表'),('37',1,'/charge/insert','新增收费数据'),('38',1,'/charge/del','删除收费数据'),('39',1,'/visitor/insert','新增授权登记表'),('4',1,'/vipParkingLot/insert','添加内部停车点'),('40',1,'/visitor/approval','审批授权登记表'),('41',1,'/tariff/select','获取收费列表'),('42',1,'/tariff/insert','新增收费数据'),('43',1,'/charge/section','用户开通包段'),('44',1,'/visitor/del','删除访客单'),('45',1,'/admin/select','获取管理员列表'),('46',1,'/user/isLogin','判断用户是否登录'),('47',1,'/user/tokenUserInfo','通过token获取用户信息'),('48',1,'/system/statistics','统计当天人员车辆出入'),('5',1,'/vipParkingLot/del','删除内部停车点'),('50',1,'/system/uploadFileList','批量上传图片'),('51',1,'/faceRecord/select','获取人员进出记录'),('519bc03095e83cc408172e795c428853',3,'/charge/select','获取收费列表'),('52',1,'/user/select','获取用户列表'),('53',1,'/visitor/userDelVisitor','用户删除访客单凭借证件号'),('54',1,'/pageRouter/select','根据token获取页面路由展示和页面路由列表'),('55',1,'/pageRouter/selectType','根据类型参数获取全部路由及该类型用户页面展示路由'),('56',1,'/pageRouter/update','修改页面路由名称'),('57',1,'/pageRouter/change','新增一级分类及子路由'),('58',1,'/pageRouter/updateRoot','修改页面权重'),('59',1,'/admin/insert','添加管理员'),('6',1,'/vipParkingLot/approval','车辆进出对比登记'),('60',1,'/admin/update','修改管理员'),('61',1,'/admin/del','删除管理员'),('62',1,'/admin/select','获取管理员列表'),('63',1,'/system/statisticsMonth','统计当月人员出入情况'),('64',1,'/system/statisticsMonthMoney','统计当月收入'),('7',1,'/userface/select','获取未出人员列表'),('8',1,'/userface/insert','新增未出人员数据'),('9',1,'/userCar/update','修改非临时车牌'),('a520eaa6569d9f2d0a16b537c7fc2c39',3,'/userCar/select','获取非临时车牌列表'),('b6ac861f05345523ef1d599524d8f0dc',2,'/visitor/select','查找登记授权列表'),('cdad2c3893bd868668ece5a230b96a35',2,'/user/login','用户登录');

/*Table structure for table `settings` */

CREATE TABLE `settings` (
  `settings_id` varchar(50) NOT NULL COMMENT '设置ID',
  `free_access` int DEFAULT NULL COMMENT '1全部收费进入 2vip免费进入 3常驻免费进入  4常驻+vip免费进入 5全部免费进入',
  `permission_is` int DEFAULT NULL COMMENT '0登记进入 1审批进入 2直接进入',
  PRIMARY KEY (`settings_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

/*Data for the table `settings` */

insert  into `settings`(`settings_id`,`free_access`,`permission_is`) values ('tf_money',1,NULL),('tf_root',NULL,1);

/*Table structure for table `tariff` */

CREATE TABLE `tariff` (
  `tariff_id` varchar(50) NOT NULL COMMENT '收费ID',
  `tariff_type` int DEFAULT NULL COMMENT '1:小时收费 2:包段收费  3:钱包充值',
  `start_time` datetime DEFAULT NULL COMMENT '开始时间',
  `end_time` datetime DEFAULT NULL COMMENT '结束时间',
  `tariff_car` varchar(50) DEFAULT NULL COMMENT '车牌',
  `tariff_money` decimal(10,2) DEFAULT NULL COMMENT '金额',
  `tariff_user_id` varchar(50) DEFAULT NULL COMMENT '用户ID',
  `tariff_user_type` int DEFAULT NULL COMMENT '用户类型 1(常驻) 2(临时授权) 3(vip)',
  `tariff_user_phone` varchar(50) DEFAULT NULL COMMENT '用户姓名',
  `tariff_user_name` varchar(50) DEFAULT NULL COMMENT '用户手机号',
  `tariff_vip` varchar(50) DEFAULT NULL COMMENT '闸机名',
  PRIMARY KEY (`tariff_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

/*Data for the table `tariff` */

insert  into `tariff`(`tariff_id`,`tariff_type`,`start_time`,`end_time`,`tariff_car`,`tariff_money`,`tariff_user_id`,`tariff_user_type`,`tariff_user_phone`,`tariff_user_name`,`tariff_vip`) values ('02cf694c413dd3bd9b4b3de8830c07a1',1,'2025-09-19 15:44:23','2025-09-19 15:51:15','粤R888G8','0.00','1',2,'111','3333','地下停车场'),('0f7e7d96c94b5e61ab63b29e5a0c435a',1,'2025-09-14 10:27:05','2025-09-19 15:49:59','赣G7E767','0.00','1',1,'17754400960','贺畅','地下停车场'),('12b600d69ea3f6e57a251c6ebf0968f4',1,'2025-09-12 22:07:54','2025-09-12 22:08:02','赣G7E767','0.00','1',1,'17754400960','贺畅','地下停车场'),('1b2491fb2a9680da2a0d7f9ce4ff2c97',1,'2025-09-14 11:18:29','2025-09-14 11:18:39','粤R888G8','0.00','1',2,'111','3333','地下停车场'),('22e5bbd3060dfdb5ff2afc0a7b0e6876',1,'2025-09-19 15:54:24','2025-09-19 15:54:27','赣G7E767','0.00','1',1,'17754400960','贺畅','地下停车场'),('22fbf98f2d3e4078ef1f594ff6fd6db7',1,'2025-09-12 18:05:31','2025-09-12 18:05:47','赣G7E767','0.00','1',1,'17754400960','贺畅','地下停车场'),('3113385c2bd2b5eb944aa18df42e68f8',1,'2025-09-12 20:00:04','2025-09-13 17:14:59','粤R888G8','105.00','1',2,'111','3333','地下停车场'),('3d6ee99d2d52dd1e34998aca754e4f3b',1,'2025-09-21 10:41:13','2025-09-23 18:48:45','赣G7E767','0.00','1',1,'17754400960','贺畅','地下停车场'),('46585b613d588b199d7a57886d24e21a',1,'2025-09-21 09:38:29','2025-09-21 09:39:59','粤A88888','0.00','ffda22b603b0cc788e4b84a2f6548283',1,'45454','李四','地下停车场'),('57362cf0f3dfd2814a291b8b668460bb',1,'2025-09-14 10:26:54','2025-09-14 11:16:20','粤R888G8','5.00','1',2,'111','3333','地下停车场'),('980ae4c14f107011dc87cf2375af0ba9',1,'2025-09-12 18:25:03','2025-09-12 18:29:27','粤R888G8','0.00','1',2,'111','3333','地下停车场'),('ad9df9569fecafdc4c72723ea2e01fcd',1,'2025-09-19 15:57:55','2025-09-19 16:00:17','粤R888G8','0.00','1',2,'111','3333','地下停车场'),('cc49103d655330533086c340ecd79674',1,'2025-09-12 17:52:53','2025-09-12 17:52:59','赣G7E767','0.00','1',1,'17754400960','贺畅','地下停车场'),('d02f4d13b8d798aa7addb9a76613fa7d',1,'2025-09-19 15:54:04','2025-09-19 15:54:17','赣G7E767','0.00','1',1,'17754400960','贺畅','地下停车场'),('d4cc89b2b443ccd9760dbbb3e0e23080',1,'2025-09-19 15:54:47','2025-09-19 15:54:50','赣G7E767','0.00','1',1,'17754400960','贺畅','地下停车场'),('da0cbfec168ebe8a6772079c3151464e',1,'2025-09-19 15:50:22','2025-09-19 15:51:26','赣G7E767','0.00','1',1,'17754400960','贺畅','地下停车场'),('da541d46dba0300d6e9411fac958d647',1,'2025-09-19 15:53:10','2025-09-19 15:53:15','赣G7E767','0.00','1',1,'17754400960','贺畅','地下停车场'),('dbcc6a90ac2c56fb7c08d56c7e8d338c',1,'2025-09-12 18:31:44','2025-09-12 19:57:06','粤R888G8','5.00','1',2,'111','3333','地下停车场'),('e4071c2ec4fab61150d0b1230ce97e4b',1,'2025-09-19 15:51:35','2025-09-19 15:51:44','赣G7E767','0.00','1',1,'17754400960','贺畅','地下停车场'),('f573ff556f12e460f08615155d2026b3',1,'2025-09-19 15:52:54','2025-09-19 15:53:01','赣G7E767','0.00','1',1,'17754400960','贺畅','地下停车场');

/*Table structure for table `unit` */

CREATE TABLE `unit` (
  `unit_id` varchar(50) NOT NULL COMMENT '单位ID',
  `unit_name` varchar(50) DEFAULT NULL COMMENT '单位名称',
  PRIMARY KEY (`unit_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

/*Data for the table `unit` */

insert  into `unit`(`unit_id`,`unit_name`) values ('1','一号楼八楼1'),('2','行政处'),('d3ea7de1cf57c699bfd3e9db76e9fb8a','爱思');

/*Table structure for table `user` */

CREATE TABLE `user` (
  `user_id` varchar(50) NOT NULL COMMENT '用户ID',
  `user_name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8_general_ci NOT NULL COMMENT '用户姓名',
  `user_phone` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8_general_ci NOT NULL COMMENT '用户手机号',
  `user_card` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8_general_ci NOT NULL COMMENT '用户证件号',
  `user_root` int DEFAULT '4' COMMENT '1(批人批车) 2(批车) 3(批人)',
  `user_face` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户人脸库ID',
  `user_type` int NOT NULL DEFAULT '1' COMMENT '-1(黑名单) 0(停用) 1(常驻) 2(临时授权) 3(vip)',
  `user_unit` varchar(50) DEFAULT NULL COMMENT '用户单位id',
  `start_time` datetime DEFAULT NULL COMMENT '权限开始时间',
  `end_time` datetime DEFAULT NULL COMMENT '权限结束时间',
  `user_moeny` decimal(10,2) DEFAULT NULL COMMENT '用户钱包余额',
  `user_pwd` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户密码',
  PRIMARY KEY (`user_id`),
  KEY `aa` (`user_unit`),
  CONSTRAINT `aa` FOREIGN KEY (`user_unit`) REFERENCES `unit` (`unit_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

/*Data for the table `user` */

insert  into `user`(`user_id`,`user_name`,`user_phone`,`user_card`,`user_root`,`user_face`,`user_type`,`user_unit`,`start_time`,`end_time`,`user_moeny`,`user_pwd`) values ('1','贺畅','17754400960','5656',2,'6a9d99b6a40f420cb7d8f8a7fc7000cb',1,'1','2025-09-02 16:35:47','2025-12-12 16:35:51','0.00','6M4oIcjCQCoIXXmFHGc0sxb3l126tkDBeg29vA6UVEc=:IeJU/rnowGAVuORJWDsz6A=='),('2c9deacc9fdcc72ce3220f56b3766419','王鹤棣','sdf','sdf',4,'86575eeef0c54228aff2b5c9eea5b5ba',2,NULL,'2025-09-11 01:00:00','2025-12-20 05:00:00',NULL,NULL),('3b853b102c4197a8e795e92e5c691512','杜怡君','6','454545',4,'94aae939979345e89226e4e53034f069',2,NULL,'2025-09-06 12:02:25','2025-12-28 12:02:45',NULL,NULL),('6d0a5b29b90329590eece855d187b39a','吴彦祖','吴彦祖','吴彦祖',1,'a2df2d88d23e4475a92e7b8cfc7c388c',1,'1','2025-09-04 16:32:55','2025-12-17 16:36:59','99987999.00','Cym5+Ei4CzAi68mVM6dj8TGMmoHjFP/coBA2NPvWj78=:1VA5zIFWmWG+khWSbBl8og=='),('a819cf9cb59ff47aa6b52312f71ea8f4','刘亦菲','789789','789789',4,'5516f7e679f44a31a4360f8765b8757c',2,NULL,'2025-09-14 10:02:33','2025-12-20 10:02:35',NULL,NULL),('admin','管理员用户','17671650990','4545',1,NULL,3,'1','2025-09-05 17:00:59','2025-12-20 17:01:02','10000.00','6M4oIcjCQCoIXXmFHGc0sxb3l126tkDBeg29vA6UVEc=:IeJU/rnowGAVuORJWDsz6A=='),('ffda22b603b0cc788e4b84a2f6548283','彭于晏','45454','154545',4,'813bbb8044dd492bbb63d7a8035cbe23',1,'1','2025-09-03 20:20:55','2025-12-13 20:20:58','39.55','6M4oIcjCQCoIXXmFHGc0sxb3l126tkDBeg29vA6UVEc=:IeJU/rnowGAVuORJWDsz6A==');

/*Table structure for table `user_car` */

CREATE TABLE `user_car` (
  `user_car_id` varchar(50) NOT NULL,
  `user_id` varchar(50) DEFAULT NULL COMMENT '用户id',
  `user_car_phone` varchar(50) DEFAULT NULL COMMENT '用户车牌',
  `start_time` datetime DEFAULT NULL COMMENT '包段开始时间',
  `end_time` datetime DEFAULT NULL COMMENT '包段结束时间',
  PRIMARY KEY (`user_car_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

/*Data for the table `user_car` */

insert  into `user_car`(`user_car_id`,`user_id`,`user_car_phone`,`start_time`,`end_time`) values ('1','ffda22b603b0cc788e4b84a2f6548283','粤A88888','2025-09-03 12:54:55','2025-09-04 12:54:58'),('1f13e23733fabfa7a57daa7db7e69d41','6d0a5b29b90329590eece855d187b39a','asd','2025-09-09 20:10:13','2026-09-04 20:10:13'),('65656','1','鲁V718N9','2025-09-12 10:25:40','2025-09-28 10:25:43'),('999','1','赣G7E767','2025-09-11 20:31:08','2026-10-06 20:31:08');

/*Table structure for table `user_face` */

CREATE TABLE `user_face` (
  `user_face_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8_general_ci NOT NULL COMMENT '未出人员表',
  `user_face_type` int DEFAULT NULL COMMENT '1(常驻) 2(临时授权) 3(vip)',
  `user_face_tf` int DEFAULT NULL COMMENT '1:进',
  `start_time` datetime DEFAULT NULL COMMENT '时间',
  `user_face_gate` varchar(50) DEFAULT NULL COMMENT '大门ID',
  `user_face_user_id` varchar(50) DEFAULT NULL COMMENT '用户ID',
  PRIMARY KEY (`user_face_id`),
  KEY `aaa` (`user_face_user_id`),
  KEY `bbv` (`user_face_gate`),
  CONSTRAINT `aaa` FOREIGN KEY (`user_face_user_id`) REFERENCES `user` (`user_id`),
  CONSTRAINT `bbv` FOREIGN KEY (`user_face_gate`) REFERENCES `gate` (`gate_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

/*Data for the table `user_face` */

/*Table structure for table `vip_parking_lot` */

CREATE TABLE `vip_parking_lot` (
  `vip_parking_lot` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8_general_ci NOT NULL COMMENT '车辆闸机ID',
  `vip_parking_lot_root` int DEFAULT NULL COMMENT '允许谁进入 1(常驻) 2(临时授权) 3(vip) 4(常驻+vip) 5全部',
  `vip_parking_lot_name` varchar(50) DEFAULT NULL COMMENT '内停名称',
  `vip_parking_lot_count` int DEFAULT NULL COMMENT '车位数量',
  `vip_parking_lot_statistics` int DEFAULT NULL COMMENT '剩余车位数量',
  PRIMARY KEY (`vip_parking_lot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

/*Data for the table `vip_parking_lot` */

insert  into `vip_parking_lot`(`vip_parking_lot`,`vip_parking_lot_root`,`vip_parking_lot_name`,`vip_parking_lot_count`,`vip_parking_lot_statistics`) values ('1',2,'地下停车场',500,476),('2',5,'地面停车场',400,26),('387db115c5f8c61ea3916bc068131a72',3,'vip',20,20),('d0deeaa5697738e3b590942ecbb0cab1',2,'宿舍',55,54);

/*Table structure for table `visitor_registration_form` */

CREATE TABLE `visitor_registration_form` (
  `visitor_registration_form_id` varchar(50) NOT NULL COMMENT '登记表ID',
  `visitor_registration_form_visitor` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '有车除车主访客json',
  `visitor_registration_form_visitor_card_phone` varchar(50) DEFAULT NULL COMMENT '访车牌',
  `visitor_registration_form_visitor_img` varchar(100) DEFAULT NULL COMMENT '访客图片 没车则填',
  `visitor_registration_form_visitor_info` varchar(500) DEFAULT NULL COMMENT '来访事由',
  `start_time` datetime DEFAULT NULL COMMENT '来访时间',
  `end_time` datetime DEFAULT NULL COMMENT '离开时间',
  `visitor_in_out_count` int DEFAULT NULL COMMENT '进出次数  -1不限',
  `visitor_pass` int DEFAULT NULL COMMENT '是否同意0同意 1不同意 2待审批',
  `interviewee_name` varchar(50) DEFAULT NULL COMMENT '被访人姓名',
  `interviewee_unit` varchar(50) DEFAULT NULL COMMENT '被访人单位',
  `approver_user_id` varchar(50) DEFAULT NULL COMMENT '审批人ID',
  `approver_info` varchar(500) DEFAULT NULL COMMENT '审批人意见',
  `visitor_registration_form_user` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '车主/访客姓名',
  `visitor_registration_form_phone` varchar(50) DEFAULT NULL COMMENT '车主/访客电话',
  `visitor_registration_form_card` varchar(50) DEFAULT NULL COMMENT '车主/访客证件',
  `visitor_registration_form_user_id` varchar(50) DEFAULT NULL COMMENT '车主/访客id',
  PRIMARY KEY (`visitor_registration_form_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

/*Data for the table `visitor_registration_form` */

insert  into `visitor_registration_form`(`visitor_registration_form_id`,`visitor_registration_form_visitor`,`visitor_registration_form_visitor_card_phone`,`visitor_registration_form_visitor_img`,`visitor_registration_form_visitor_info`,`start_time`,`end_time`,`visitor_in_out_count`,`visitor_pass`,`interviewee_name`,`interviewee_unit`,`approver_user_id`,`approver_info`,`visitor_registration_form_user`,`visitor_registration_form_phone`,`visitor_registration_form_card`,`visitor_registration_form_user_id`) values ('01ecb20ad6552322dbb81407ae15b287',NULL,NULL,'static/file/images/22193593-e911-4b85-ba68-ada8226f26d0.jpg','sdf','2025-09-11 01:00:00','2025-12-28 05:00:00',-1,0,'we','1','admin',NULL,'王鹤棣','789789','445564545622','2c9deacc9fdcc72ce3220f56b3766419'),('1','[{\"name\":\"会覆盖\",\"card\":\"5665656\",\"phone\":\"454545\"}]','粤R888G8','','找人啊啊啊啊啊','2025-09-02 16:41:38','2025-09-20 16:41:40',57,0,'哈哈哈','1','1','ok','3333','111','111',NULL),('2',NULL,NULL,'static/file/images/pp.jpg','找人','2025-09-03 20:20:55','2025-09-21 20:20:58',-1,3,NULL,NULL,'admin',NULL,'李四','45454','154545','ffda22b603b0cc788e4b84a2f6548283'),('504a11744d1d91d28987d5b8dd367843','[{\"name\":\"贺畅\",\"card\":\"3\",\"phone\":\"17754400960\"}]','川A66666',NULL,'浙江事由','2025-09-06 12:19:40','2025-09-14 12:19:38',4,0,'很合适地方','d3ea7de1cf57c699bfd3e9db76e9fb8a','admin',NULL,'浙江姓名','6969','4545454455',NULL),('5de81fae12e9dadbe7d969f5eac32665',NULL,NULL,'static/file/images/151ae0ea-debe-45d7-93f1-5bf96588de74.jpg','哦哦哦','2025-09-06 12:02:25','2025-09-08 12:02:45',-1,0,'很合适地方','1','admin',NULL,'杜怡君','6','454545','3b853b102c4197a8e795e92e5c691512'),('9c0d82906fc93d3acd9c099aafe2bbfc',NULL,NULL,'/java/bs/static/file/images/0856b6dc-7e28-47bf-8891-f1ecfb982810.jpg','789789','2025-09-14 10:02:33','2025-09-28 10:02:35',3,0,'78945','1','admin',NULL,'刘亦菲','789789','789789','a819cf9cb59ff47aa6b52312f71ea8f4'),('c4f7c97541abc236a7e484bd229c7eba',NULL,NULL,'static/file/images/ca531e8b-08cc-43fe-8d84-eeb71333cf9a.jpg','武城职','2025-09-04 11:15:47','2025-09-14 11:15:50',-1,0,'贺畅','1','admin',NULL,'杜怡君','6','dyj','3b853b102c4197a8e795e92e5c691512');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;