sql/upgrade_260806/cloudparkauthservice.sql

SET FOREIGN_KEY_CHECKS=0;

CREATE TABLE `cloudparkauthservice`.`inout_record_log`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `record_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '记录类型(业务事件类型)',
  `car_in_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '入场记录ID',
  `car_out_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '出场记录ID',
  `plate_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '车牌号',
  `park_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '车场ID',
  `project_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '项目编号',
  `lane_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '车道ID',
  `record_time` bigint NULL DEFAULT NULL COMMENT '记录时间戳(毫秒)',
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '事件载荷JSON',
  `create_time` bigint NULL DEFAULT NULL COMMENT '创建时间戳(毫秒)',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_record_type`(`record_type` ASC) USING BTREE,
  INDEX `idx_car_in_id`(`car_in_id` ASC) USING BTREE,
  INDEX `idx_park_record_time`(`park_id` ASC, `record_time` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14469 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '进出场事件日志' ROW_FORMAT = Dynamic;

CREATE TABLE `cloudparkauthservice`.`pre_in_record`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `record_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '预记录ID(=carInId)',
  `status` int NOT NULL DEFAULT 0 COMMENT '状态 0待处理 1已开闸 2已拒绝 3已过期',
  `project_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '项目编号',
  `park_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '车场ID',
  `park_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '车场名称',
  `park_level` int NULL DEFAULT NULL COMMENT '车场层级，当前车场层级；从1开始；',
  `first_park_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '一级车场ID',
  `lane_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '车道ID',
  `lane_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '车道名称',
  `device_sn` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '设备序列号',
  `plate_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '车牌号',
  `plate_color` int NULL DEFAULT NULL COMMENT '车牌颜色',
  `plate_type` int NULL DEFAULT NULL COMMENT '车牌类型',
  `car_size` int NULL DEFAULT NULL COMMENT '车辆大小',
  `car_identity` int NULL DEFAULT NULL COMMENT '车辆身份 1月卡 2临停',
  `model_code` int NULL DEFAULT NULL COMMENT '套餐类型编码',
  `model_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '套餐类型名称',
  `owner` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '车主(月卡客户名称)',
  `phone` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '联系电话(月卡客户电话)',
  `house_info` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '部门/房号(月卡客户归属部门+房号)',
  `car_in_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '入场记录ID(冗余=record_id, 用于按carInId同步)',
  `event_time` bigint NULL DEFAULT NULL COMMENT '事件时间戳(毫秒)',
  `auth_result_code` int NULL DEFAULT NULL COMMENT '鉴权结果码',
  `auth_result_msg` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '鉴权结果消息',
  `auto_open` tinyint(1) NULL DEFAULT NULL COMMENT '是否自动开闸',
  `small_img` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '小图URL',
  `big_img` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '大图URL',
  `extra` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '扩展信息JSON',
  `inout_record_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '关联正式入场记录ID',
  `open_time` bigint NULL DEFAULT NULL COMMENT '开闸时间戳(毫秒)',
  `open_operator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '开闸操作人',
  `operator_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '操作人姓名',
  `operator_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '操作人ID(账号)',
  `open_type` int NULL DEFAULT NULL COMMENT '开闸方式 1自动 2人工 3远程 4支付回调',
  `create_time` bigint NULL DEFAULT NULL COMMENT '创建时间戳(毫秒)',
  `update_time` bigint NULL DEFAULT NULL COMMENT '更新时间戳(毫秒)',
  `model_modified` tinyint(1) NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uk_record_id`(`record_id` ASC) USING BTREE,
  INDEX `idx_status`(`status` ASC) USING BTREE,
  INDEX `idx_park_plate_status`(`park_id` ASC, `plate_no` ASC, `status` ASC) USING BTREE,
  INDEX `idx_car_in_id`(`car_in_id` ASC) USING BTREE,
  INDEX `idx_create_time`(`create_time` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2339 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '预入场记录' ROW_FORMAT = Dynamic;

CREATE TABLE `cloudparkauthservice`.`pre_inout_record`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `record_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '预记录ID',
  `record_type` int NOT NULL COMMENT '记录类型 1预入场 2预出场',
  `status` int NOT NULL DEFAULT 0 COMMENT '状态 0待处理 1已开闸 2已拒绝 3已过期',
  `project_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '项目编号',
  `park_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '车场ID',
  `park_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '车场名称',
  `lane_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '车道ID',
  `lane_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '车道名称',
  `device_sn` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '设备序列号',
  `plate_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '车牌号',
  `plate_color` int NULL DEFAULT NULL COMMENT '车牌颜色',
  `plate_type` int NULL DEFAULT NULL COMMENT '车牌类型',
  `car_size` int NULL DEFAULT NULL COMMENT '车辆大小',
  `car_identity` int NULL DEFAULT NULL COMMENT '车辆身份 1月卡 2临停',
  `model_code` int NULL DEFAULT NULL COMMENT '套餐类型编码',
  `model_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '套餐类型名称',
  `car_in_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '关联入场记录ID',
  `in_time` bigint NULL DEFAULT NULL COMMENT '入场时间戳(毫秒)',
  `event_time` bigint NULL DEFAULT NULL COMMENT '事件时间戳(毫秒)',
  `auth_result_code` int NULL DEFAULT NULL COMMENT '鉴权结果码',
  `auth_result_msg` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '鉴权结果消息',
  `need_pay` tinyint(1) NULL DEFAULT NULL COMMENT '是否需要缴费',
  `amount` int NULL DEFAULT NULL COMMENT '应收金额(分)',
  `order_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '计费订单ID',
  `auto_open` tinyint(1) NULL DEFAULT NULL COMMENT '是否自动开闸',
  `small_img` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '小图URL',
  `big_img` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '大图URL',
  `extra` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '扩展信息JSON',
  `inout_record_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '关联正式进出场记录ID',
  `open_time` bigint NULL DEFAULT NULL COMMENT '开闸时间戳(毫秒)',
  `open_operator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '开闸操作人',
  `open_type` int NULL DEFAULT NULL COMMENT '开闸方式 1自动 2人工 3远程 4支付回调',
  `create_time` bigint NULL DEFAULT NULL COMMENT '创建时间戳(毫秒)',
  `update_time` bigint NULL DEFAULT NULL COMMENT '更新时间戳(毫秒)',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uk_record_id`(`record_id` ASC) USING BTREE,
  INDEX `idx_status_type`(`status` ASC, `record_type` ASC) USING BTREE,
  INDEX `idx_park_plate_status`(`park_id` ASC, `plate_no` ASC, `status` ASC, `record_type` ASC) USING BTREE,
  INDEX `idx_order_id`(`order_id` ASC) USING BTREE,
  INDEX `idx_create_time`(`create_time` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14525 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '预进出场记录' ROW_FORMAT = Dynamic;

CREATE TABLE `cloudparkauthservice`.`pre_out_record`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `record_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '预记录ID(=carOutId)',
  `status` int NOT NULL DEFAULT 0 COMMENT '状态 0待处理 1已开闸 2已拒绝 3已过期',
  `project_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '项目编号',
  `park_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '车场ID',
  `park_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '车场名称',
  `park_level` int NULL DEFAULT NULL COMMENT '车场层级，当前车场层级；从1开始；',
  `first_park_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '一级车场ID',
  `lane_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '车道ID',
  `lane_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '车道名称',
  `device_sn` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '设备序列号',
  `plate_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '车牌号',
  `plate_color` int NULL DEFAULT NULL COMMENT '车牌颜色',
  `plate_type` int NULL DEFAULT NULL COMMENT '车牌类型',
  `car_size` int NULL DEFAULT NULL COMMENT '车辆大小',
  `car_identity` int NULL DEFAULT NULL COMMENT '车辆身份 1月卡 2临停',
  `model_code` int NULL DEFAULT NULL COMMENT '套餐类型编码',
  `model_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '套餐类型名称',
  `car_in_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '关联入场记录ID',
  `in_time` bigint NULL DEFAULT NULL COMMENT '入场时间戳(毫秒)',
  `event_time` bigint NULL DEFAULT NULL COMMENT '事件时间戳(毫秒)',
  `auth_result_code` int NULL DEFAULT NULL COMMENT '鉴权结果码',
  `auth_result_msg` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '鉴权结果消息',
  `need_pay` tinyint(1) NULL DEFAULT NULL COMMENT '是否需要缴费',
  `total_amount` int NULL DEFAULT NULL COMMENT '总金额(分,来自ParkChargeVO.totalAmount)',
  `order_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '计费订单ID',
  `actual_amount` int NULL DEFAULT NULL COMMENT '实付金额(分,来自ParkChargeVO.actualAmount)',
  `discount_amount` int NULL DEFAULT NULL COMMENT '优惠金额(分,来自ParkChargeVO.discountAmount)',
  `free_amount` int NULL DEFAULT NULL COMMENT '免费金额(分,来自ParkChargeVO.freeAmount)',
  `paid_money` int NULL DEFAULT NULL COMMENT '已缴费金额(分,来自ParkChargeVO.paidMoney)',
  `stay_time` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '停车时长(格式化,来自DateUtils.formatStayDuration)',
  `auto_open` tinyint(1) NULL DEFAULT NULL COMMENT '是否自动开闸',
  `small_img` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '小图URL',
  `big_img` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '大图URL',
  `extra` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '扩展信息JSON',
  `inout_record_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '关联正式出场记录ID',
  `open_time` bigint NULL DEFAULT NULL COMMENT '开闸时间戳(毫秒)',
  `open_operator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '开闸操作人',
  `operator_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '操作人姓名',
  `operator_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '操作人ID(账号)',
  `open_type` int NULL DEFAULT NULL COMMENT '开闸方式 1自动 2人工 3远程 4支付回调',
  `create_time` bigint NULL DEFAULT NULL COMMENT '创建时间戳(毫秒)',
  `update_time` bigint NULL DEFAULT NULL COMMENT '更新时间戳(毫秒)',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uk_record_id`(`record_id` ASC) USING BTREE,
  INDEX `idx_status`(`status` ASC) USING BTREE,
  INDEX `idx_park_plate_status`(`park_id` ASC, `plate_no` ASC, `status` ASC) USING BTREE,
  INDEX `idx_park_order`(`park_id` ASC, `order_id` ASC) USING BTREE,
  INDEX `idx_car_in_id`(`car_in_id` ASC) USING BTREE,
  INDEX `idx_create_time`(`create_time` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2209 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '预出场记录' ROW_FORMAT = Dynamic;

CREATE TABLE `cloudparkauthservice`.`remote_gate_record`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `request_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '请求ID',
  `project_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '项目编号',
  `park_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '车场ID',
  `park_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '车场名称',
  `lane_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '通道ID',
  `lane_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '通道名称',
  `device_sn` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '设备序列号',
  `plate_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '车牌号',
  `plate_color` int NULL DEFAULT NULL COMMENT '车牌颜色',
  `gate_type` int NOT NULL COMMENT '开闸类型 1入场 2出场',
  `status` int NOT NULL DEFAULT 0 COMMENT '状态 0待执行 1成功 2失败 3超时',
  `car_in_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '关联入场记录ID',
  `pre_record_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '关联预记录ID',
  `reason` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '开闸原因',
  `voice_content` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '语音内容',
  `display_content` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '显示内容',
  `request_time` bigint NULL DEFAULT NULL COMMENT '请求时间戳(毫秒)',
  `operator_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '操作人ID',
  `operator_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '操作人姓名',
  `execute_time` bigint NULL DEFAULT NULL COMMENT '执行时间戳(毫秒)',
  `result_message` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '结果消息',
  `inout_record_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '关联正式进出场记录ID',
  `source` int NULL DEFAULT NULL COMMENT '请求来源 1云端 2APP 3岗亭',
  `extra` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '扩展信息JSON',
  `create_time` bigint NULL DEFAULT NULL COMMENT '创建时间戳(毫秒)',
  `update_time` bigint NULL DEFAULT NULL COMMENT '更新时间戳(毫秒)',
  `control_type` tinyint NULL DEFAULT NULL COMMENT '控制类型',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uk_request_id`(`request_id` ASC) USING BTREE,
  INDEX `idx_status_time`(`status` ASC, `request_time` ASC) USING BTREE,
  INDEX `idx_park_lane`(`park_id` ASC, `lane_id` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14765 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '远程开闸记录' ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS=1;