sckw-service-platform/sql/2026/04/2026_04_08_validate_license_plate.sql

CREATE TABLE validate_License_Plate (
                                        `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
                                        license_plate VARCHAR(20) NOT NULL DEFAULT '' COMMENT '车牌号',
                                        uuid 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='车牌验证表';