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='车牌验证表';