Skip to content

user_extcredits_logs 用户扩展分值日志表

字段名字段类型字段注释默认值可空备注
idbigint UNSIGNED主键 IDNO自动递增
user_idbigint UNSIGNED用户 IDNO关联字段 users->id
extcredits_idtinyint UNSIGNEDextcredits 编号NOextcredits 1~5
typetinyint UNSIGNED操作类型1NO1.加分 / 2.减分
amountint UNSIGNED数值0NO加或减的数值
opening_amountint UNSIGNED期初数值NO操作前数值
closing_amountint UNSIGNED期末数值NO操作后数值
app_fskeyvarchar(64)关联插件NO关联字段 apps->fskey
哪个插件触发的操作
remarktext备注YES
created_attimestamp创建时间useCurrentNO比如 MySQL 默认值为 CURRENT_TIMESTAMP
updated_attimestamp更新时间YES
deleted_attimestamp删除时间YES

Released under the Apache-2.0 License