Fresnsmentions
| Column Name | Type | Comment | Default | Null | Remark |
|---|---|---|---|---|---|
| id | bigint UNSIGNED | Primary Key ID | NO | 自动递增 | |
| user_id | bigint UNSIGNED | 发起艾特者 ID | NO | 关联字段 users->id | |
| mention_type | tinyint UNSIGNED | 关联目标类型 | 1 | NO | 1.用户 users > bio2.小组 groups > description3.话题 hashtags > description4.帖子 posts > content5.评论 comments > content |
| mention_id | bigint UNSIGNED | 关联目标主键 ID | NO | 1.关联字段 users > id2.关联字段 groups > id3.关联字段 hashtags > id4.关联字段 posts > id5.关联字段 comments > id | |
| mention_user_id | bigint UNSIGNED | 被艾特用户 ID | NO | 关联字段 users->id | |
| created_at | timestamp | Create Time | CURRENT_TIMESTAMP | NO | |
| updated_at | timestamp | Update Time | YES | ||
| deleted_at | timestamp | Delete Time | YES |