当前位置:首页 >> 数据库

详解Redis中key的命名规范和值的命名规范

数据库中得热点数据key命名惯例

表名:主键名:主键值:字段名 例如 user:id:0001:name 例如 user:id:0002:name 例如 order:id:s2002:price

上面的key对应的值则可以是

存放的方式 key value 优点 单独的key:value形式 order:id:s2002:price 2000 方便简单的操作,例如incr自增或自减 json格式 user:id:0001 {id:0001,name:"张三"} 方便一次性存和取数据,但是不方便更新数据

redis 缓存 key常量命名规则示例

package com.awj.mall.restfulapi.common.consts;

public class CacheConsts {

  // 短信验证码类型
  /**
   * 登录
   */
  public static final String SMS_TYPE_LOGIN = "cache:api:sms_login_";
  /**
   * 重置密码
   */
  public static final String SMS_TYPE_RESETPWD = "cache:api:sms_resetpwd_";
  /**
   * 重置手机号
   */
  public static final String SMS_TYPE_RESETPHONE = "cache:api:sms_resetphone_";
  /**
   * 注册
   */
  public static final String SMS_TYPE_REG = "cache:api:sms_reg_";
  /**
   * 工单报备报备人校验
   */
  public static final String SMS_TYPE_PROJECT = "cache:api:sms_project_";
  
  /**
   * 服务商申请
   */
  public static final String SMS_TYPE_SERVICE = "cache:api:sms_service_";
  /**
   * 绑定账户
   */
  public static final String SMS_TYPE_BIND_PAYACCOUNT = "cache:api:sms_bing_payaccount_";
  /**
   * 服务商接单后核销码短信消息(消费者)
   */
  public static final String SMS_TYPE_SERVICE_HX = "cache:api:sms_service_hx_";


  /**
   * 重置密码_token
   */
  public static final String SMS_TYPE_RESETPWD_TOKEN = "cache:api:sms_resetpwd:token_";
  /**
   * 重置密码_手机号
   */
  public static final String SMS_TYPE_RESETPHONE_TOKEN = "cache:api:sms_resetphone:token_";

  //省市区商圈缓存
  /**
   * 所有省市区
   */
  public static final String SYS_CITY_LIST = "cache:api:city_list";
  /**
   * 已开通区域包含商圈信息
   */
  public static final String SYS_CITY_ESC_LIST = "cache:api:city_esc_list";
  /**
   * 所有已开通商圈
   */
  public static final String SYS_ESC_LIST = "cache:api:esc_list";

  public static final Integer SYS_CITY_LIST_EXPIRE_TIME_SECONDS = 60 * 60 * 24 * 15;

  /**
   * 验证码过期时间:5分钟
   */
  public static final Integer CHECKCODE_EXPIRE_TIME_SECONDS = 5 * 60 * 1000;

  /**
   * 验证码在redis中的存储时间:30分钟
   */
  public static final Integer CHECKCODE_EXPIRE_TIME_SAVE_SECONDS = 30 * 60 * 1000;

  /**
   * 广告类图片
   */
  public static final String CACHE_IMAGE_RES_ADV = "cache:image_dir:" + SysConsts.IMAGE_RES_ADV;
  /**
   * 体验服务中心相关图片
   */
  public static final String CACHE_IMAGE_RES_ESC = "cache:image_dir:" + SysConsts.IMAGE_RES_ESC;
  /**
   * 品牌店铺相关图片
   */
  public static final String CACHE_IMAGE_RES_SHOP = "cache:image_dir:" + SysConsts.IMAGE_RES_SHOP;
  /**
   * 产品相关图片
   */
  public static final String CACHE_IMAGE_RES_PRODUCT = "cache:image_dir:" + SysConsts.IMAGE_RES_PRODUCT;
  /**
   * 其他图标/logo相关图片
   */
  public static final String CACHE_IMAGE_RES_ICON = "cache:image_dir:" + SysConsts.IMAGE_RES_ICON;
  /**
   * 程序使用静态文件资源
   */
  public static final String CACHE_IMAGE_RES_STATIC = "cache:image_dir:" + SysConsts.IMAGE_RES_STATIC;

  /**
   * 商品分类保存
   */
  public static final String CACHE_GOODS_CATE = "cache:goodscate";
  /**
   * 商品分类保存过期时间
   */
  public static final Integer CACHE_GOODS_CATE_EXPIRE_TIME = 60 * 10;

  /**
   * 品牌保存
   */
  public static final String CACHE_GOODS_BRAND = "cache:goodsbrand";


  /**
   * 平台品牌保存
   */
  public static final String CACHE_GOODS_BRAND_PLATFORM = "cache:goodsbrand:platform";

  /**
   * 商家品牌保存
   */
  public static final String CACHE_GOODS_BRAND_SHOP = "cache:goodsbrand:shop";

  /**
   * 品牌保存过期时间
   */
  public static final Integer CACHE_GOODS_BRAND_EXPIRE_TIME = 10 * 60;

  public static final String CACHE_P_USERINFO = "cache:piduserinfo";


  public static final String CACHE_ORDER_UN_PAY = "cache:order:unpay";
  public static final Long CACHE_ORDER_UN_PAY_EXPIRE_TIME = 24 * 60 * 60 * 1000L;


  public static final String CACHE_ORDER_COMMIT = "cache:commit:order:userid_";
  public static final Long CACHE_ORDER_COMMIT_EXPIRE_TIME = 3 * CACHE_ORDER_UN_PAY_EXPIRE_TIME;


  public static final String CACHE_WORKBENCH_UPDATE_MAX_INTEGRATL = "cache:workbeanch:updatemaxintegratl:userid_";

  public static final Long CACHE_SERVICE_EXPIRE_TIME = 30 * 24 * 60 * 60 * 1000L ;

  public static final Integer CACHE_P_USERINFO_EXPIRE_TIME = 30 * 60;


  public static final String CACHE_RANDOM_CATE_LIST = "cache:random_cate:list";


  public static final String CACHE_TAKE_ORDER = "cache:take_order:shop_";


  public static final String CACHE_SHOP_GOODS_PLUS_VOLUME = "cache:shop_goods:plusVolume";


  public static final String CACHE_SHOP_INFO_PLUS_VOLUME = "cache:shop_info:plusVolume";


  public static final String CACHE_SYS_TEMPLATE_CACHE = "cache:sms_template:";


  public static final String CACHE_TOKEN = "cache:token:";
  
  public static final String CACHE_SHOP_IMMEDIATELY_COMMIT = "cache:shop:immediately:commit:userid_";
  
  public static final Long CACHE_SHOP_IMMEDIATELY_COMMIT_EXPIRE_TIME = 10000L;


}