Fresnsextend_usages
| Column Name | Type | Comment | Default | Null | Remark |
|---|---|---|---|---|---|
| id | bigint UNSIGNED | Primary Key ID | NO | 自动递增 | |
| usage_type | tinyint UNSIGNED | 目标类型 | NO | ||
| usage_id | bigint UNSIGNED | 目标主键 ID | NO | ||
| extend_id | bigint UNSIGNED | 扩展内容 ID | NO | 关联字段 extends > id | |
| can_delete | tinyint UNSIGNED | 是否有权删除 | 1 | NO | 0.否 / 1.是 编辑器：用户是否有权删除 |
| rating | smallint UNSIGNED | 排列顺序 | 9 | NO | 升序排序 |
| plugin_unikey | varchar(64) | 关联插件 | NO | 关联字段 extends > plugin_unikey | |
| created_at | timestamp | Create Time | CURRENT_TIMESTAMP | NO | |
| updated_at | timestamp | Update Time | YES | ||
| deleted_at | timestamp | Delete Time | YES |
使用目标关联介绍
usage_type目标类型1用户2小组3话题4帖子5评论6帖子日志7评论日志
usage_id目标主键 ID1关联字段 users->id2关联字段 groups->id3关联字段 hashtags->id4关联字段 posts->id5关联字段 comments->id6关联字段 post_logs->id7关联字段 comment_logs->id