CREATE TABLE IF NOT EXISTS biz_product_risk_shop_candidate (
    id BIGINT PRIMARY KEY AUTO_INCREMENT COMMENT '主键',
    user_id BIGINT NOT NULL COMMENT '用户 ID',
    shop_name VARCHAR(255) NOT NULL COMMENT '店铺名（已规范化）',
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    UNIQUE KEY uk_user_shop (user_id, shop_name),
    KEY idx_user_id (user_id)
) COMMENT='商品风险解决-用户备选店铺';
