20260627_create_promotion_query_samples.sql 495 B

12345678
  1. CREATE TABLE IF NOT EXISTS `promotion_query_samples` (
  2. `id` VARCHAR(80) NOT NULL COMMENT '采样日志ID',
  3. `image_base64` LONGTEXT NOT NULL COMMENT '入参图片base64',
  4. `response_json` LONGTEXT NOT NULL COMMENT '返回JSON',
  5. `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  6. PRIMARY KEY (`id`),
  7. KEY `idx_create_time` (`create_time`)
  8. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='PromotionQuery采样记录';