CREATE TABLE weighbridge_records (
                                     `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
                                     weighbridge_name VARCHAR(50) NOT NULL DEFAULT '' COMMENT '地磅名称',
                                     weighbridge_code VARCHAR(20) NOT NULL DEFAULT '' COMMENT '地磅编码',
                                     license_plate VARCHAR(20) NOT NULL DEFAULT '' COMMENT '车牌号',
                                     weight DECIMAL(10,2) NOT NULL DEFAULT 0.00 COMMENT '重量（吨）',
                                     weigh_time DATETIME NOT NULL DEFAULT '1000-01-01 00:00:00' COMMENT '过磅时间',
                                     photo_urls VARCHAR(2048) DEFAULT '' COMMENT '过磅照片，存储图片 URL 多个地址用逗号隔开',
                                     tag VARCHAR(255) NOT NULL DEFAULT '' COMMENT '处理标签，用于指定处理方向',
                                     created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间',
                                     updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '记录更新时间',
                                     PRIMARY KEY (`id`),
                                     KEY `idx_weighbridge_code` (`weighbridge_code`),
                                     KEY `idx_weighbridge_name` (`weighbridge_name`),
                                     KEY `idx_license_plate` (`license_plate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='地磅过磅记录表';



CREATE TABLE validate_License_Plate (
                                     `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
                                     license_plate VARCHAR(20) NOT NULL DEFAULT '' COMMENT '车牌号',
                                     status tinyint NOT NULL DEFAULT '0' COMMENT '状态，0=可用，1=不可用',
                                     created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT '记录创建时间',
                                     updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '记录更新时间',
                                     PRIMARY KEY (`id`),
                                     KEY `idx_license_plate` (`license_plate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='车牌验证表';