User
user_registered and user_activated
username, email, name, trust_level
trust_level_changed
username, old_trust_level, new_trust_level
message_sent
sender_username, receiver_username, msg_title, msg_content
Do we want the message content to be sent?
Another option is to define the required information of a user and use it whenever we’re referring to a user. For example, instead of sender_username we would have sender_info which has {ID, name, username, email, trust_level, …}.
Topic
Topic_created
ID, title, content, creator_username, categories
Topic_liked
ID, title, username, number_of_likes
Topic_{pinned,unpinned,archived,closed,invisibled,bookmarked}
ID, title, username
Post
Post_liked
post_ID, topic_ID, username, number_of_likes
Reply_posted
post_ID, topic_ID, username, content
Other
Auto_close_set
I don’t know what this one means…
Flag_raised
post_id, topic_id, reason