| | |
| | | KEY `idx_access_plate` (`plate_number`) |
| | | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='门禁进出记录'; |
| | | |
| | | CREATE TABLE IF NOT EXISTS `access_vehicle` ( |
| | | `id` bigint NOT NULL AUTO_INCREMENT, |
| | | `plate_number` varchar(32) NOT NULL COMMENT '车牌号', |
| | | `plate_color` varchar(16) DEFAULT NULL COMMENT '车牌颜色', |
| | | `rfid_tag` varchar(64) DEFAULT NULL COMMENT 'RFID标签', |
| | | `carrier_name` varchar(120) DEFAULT NULL COMMENT '承运商', |
| | | `vehicle_type` varchar(64) DEFAULT NULL COMMENT '车辆类型', |
| | | `driver_name` varchar(64) DEFAULT NULL COMMENT '司机姓名', |
| | | `driver_phone` varchar(32) DEFAULT NULL COMMENT '司机电话', |
| | | `valid_start` date DEFAULT NULL COMMENT '有效期开始', |
| | | `valid_end` date DEFAULT NULL COMMENT '有效期结束', |
| | | `status` varchar(16) DEFAULT 'valid' COMMENT '状态 valid/disabled', |
| | | `remark` varchar(255) DEFAULT NULL, |
| | | `create_user` bigint DEFAULT NULL, |
| | | `create_time` datetime DEFAULT NULL, |
| | | `update_user` bigint DEFAULT NULL, |
| | | `update_time` datetime DEFAULT NULL, |
| | | `tenant_id` bigint DEFAULT NULL, |
| | | PRIMARY KEY (`id`), |
| | | KEY `idx_access_vehicle_plate` (`plate_number`), |
| | | KEY `idx_access_vehicle_rfid` (`rfid_tag`) |
| | | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='车辆通行授权'; |
| | | |
| | | -- ------------------------------------------------------------ |
| | | -- 3. 无人值守地磅:扩展字段 |
| | | -- ------------------------------------------------------------ |