notifications

Column Name	Type	Comment	Default	Null	Remark
id	bigint UNSIGNED	Primary Key ID		NO	Auto Increment
type	tinyint UNSIGNED	Notification type		NO
user_id	bigint UNSIGNED	User ID		NO	Related field users->id，Owner of this notification
content	text	Notification content		YES	When involving posts or comments, a summary can be stored
is_markdown	tinyint UNSIGNED	Is content in MD format	0	NO	0.No / 1.Yes
is_multilingual	tinyint UNSIGNED	Is content multilingual	0	NO	0.No / 1.Yes
is_access_plugin	varchar(64)	Access plugin page	0	NO	Output access address of plugin_fskey
is_mention	tinyint UNSIGNED	Is mention to a notice	0	NO	0.No / 1.Yes I was mentioned in someone else's content and then notified of the interactive action
plugin_fskey	varchar(64)	Associated Plugin Fskey		YES	Related field plugins->fskey Notification message generated by which plugin
action_user_id	bigint UNSIGNED	Triggering user ID		YES	Related field users->id
action_is_anonymous	tinyint UNSIGNED	User is anonymous	0	NO	0.No / 1.Yes
action_type	smallint UNSIGNED	Triggering action type		YES	1.Like 2.Dislike 3.Follow 4.Block 5.Publish 6.Edit 7.Delete 8.Pin 9.Highlight 10.Manage
action_object	tinyint UNSIGNED	Triggering target		YES	1.User / 2.Group / 3.Hashtag / 4.Post / 5.Comment
action_id	bigint UNSIGNED	Triggering target ID		YES	Origin of this notification 1.Related field users->id 2.Related field groups->id 3.Related field hashtags->id 4.Related field posts->id 5.Related field comments->id
action_content_id	bigint UNSIGNED	Post or Comment ID		YES	Related field posts->id or comments->id
is_read	tinyint UNSIGNED	Read status	0	NO	0.Unread / 1.Read
created_at	timestamp	Create Time	CURRENT_TIMESTAMP	NO
updated_at	timestamp	Update Time		YES
deleted_at	timestamp	Delete Time		YES

Notification Type Introduction

• 1 System
• 2 Recommend
• 3 Like
• 4 Dislike
• 5 Follow
• 6 Block
• 7 Mention
• 8 Comment (reply)
• 9 quote (reshare)

System Message Interpretation

• type=1 represents a content message sent to you by the system
  • is_access_plugin Whether to access the plugin page
  • action_user_id Whether there is a triggering user
  • action_object + action_id Whether there is a triggering source content

Recommendation Message Interpretation

• type=2 represents content recommended to you by the system
  • content Recommendation language
  • is_access_plugin Whether to access the plugin page
  • action_user_id Whether there is a triggering user
  • action_object + action_id Recommended content

Interaction Message Interpretation

• type=3 represents action_user_id liked your action_object + action_id
• type=4 represents action_user_id disliked your action_object + action_id
• type=5 represents action_user_id followed your action_object + action_id
• type=6 represents action_user_id blocked your action_object + action_id
• type=7 represents action_user_id mentioned you in action_object + action_id
  • content Summary of the mention content
• type=8 represents action_user_id commented on your action_object + action_id content
  • content Summary of the comment content
  • action_content_id Their comment ID
• type=9 represents action_user_id quoted on your action_object=4 + action_id content
  • content Summary of the post content
  • action_content_id Their post ID