{"activity_type":"NEW_USER_REGISTER","reward":[{"coupon_id":"C10","quantity":2},{"points":100}],"rules":[{"condition":"device_id NOT IN (blacklist)"},{"condition":"ip_city = '上海'"}]}
▶ 4.4 风控系统设计
风险场景拦截策略
风险类型
检测方式
处置动作
刷券
同一IP 5分钟内领取>10次
冻结账户
套现
多张券相同商户高频核销
延迟结算+人工审核
黑产库匹配
手机号/设备ID命中征信系统
拒绝发放
5. 数据库设计(部分)
5.1 核心表结构
表名:coupon_info
字段
类型
描述
coupon_id
VARCHAR(32)
全局唯一ID(雪花算法)
user_id
BIGINT
所属用户
balance
DECIMAL(12,2)
剩余金额
status
TINYINT
1=未激活 2=已使用…
分片键
user_id % 128
分库分表策略
5.2 索引优化
CREATEINDEX idx_user_status ON coupon_info(user_id,status)USINGBTREE;
RDBMS: 19.28
参考文档:
IF:How to determine an optimum value for PROCESSES parameter (Doc ID 2012693.1)
All About the Initialization Parameter PROCESSES and the Related Issues (Doc ID 2673195.1)
How to calculate the proper value from …
文章目录1. Theoretical basisThe C standard library has multiple versions. To understand the implementation principles of stack and queue, we must know which STL version we are using.The stack and queue discussed next are data structures in *SGI STL*. Only …