阅读( 1 ) 我要纠错

数据表:ims_yz_new_poster_award(新海报--奖励记录)。

字段类型默认值约束说明
idinteger-非空、自增
uniacidinteger unsigned-非空
poster_idinteger unsigned-非空海报id
subscriber_memberidinteger unsigned-非空关注者会员id
recommender_memberidinteger unsigned-非空推荐者会员id
recommender_creditinteger unsigned0-推荐者获得积分
recommender_bonusdecimal unsigned0.00-推荐者获得金额
recommender_wechat_bonusdecimal unsigned0.00-推荐者获得微信金额
recommender_coupon_idinteger unsigned0-推荐者获得优惠券id
recommender_coupon_numinteger unsigned0-推荐者获得优惠券数量
subscriber_creditinteger unsigned0-关注者获得积分
subscriber_bonusdecimal unsigned0.00-关注者获得金额
subscriber_wechat_bonusdecimal unsigned0.00-关注者获得微信金额
subscriber_coupon_idinteger unsigned0-关注者获得优惠券id
subscriber_coupon_numinteger unsigned0-关注者获得优惠券数量
created_atinteger unsigned--
updated_atinteger unsigned--
deleted_atinteger unsigned--
×