Skip to content

user_likes 用户赞记录表

字段名字段类型字段注释默认值可空备注
idbigint UNSIGNED主键 IDNO自动递增
user_idbigint UNSIGNED用户主键 IDNO关联字段 users->id
mark_typetinyint UNSIGNED操作类型1NO1.正向(赞) / 2.反向(踩)
like_typetinyint UNSIGNED目标类型1NO内容类型编号
like_idbigint UNSIGNED目标 IDNO
created_attimestamp赞时间useCurrentNO比如 MySQL 默认值为 CURRENT_TIMESTAMP
updated_attimestamp更新时间YES
deleted_attimestamp删除时间YES

Released under the Apache-2.0 License