Skip to content

hashtags

Column NameTypeCommentDefaultNullRemark
idbigint UNSIGNEDPrimary Key IDNOAuto Increment
namevarchar(64)Topic NameNO
slugvarchar(255)Topic Name URL EncodeNOUnique
descriptionjsonDescriptionYESMultilingual
typesmallint UNSIGNEDType1NOFor custom use, such as sorting or filtering
cover_file_idbigint UNSIGNEDCover Image IDYESRelated field files->id
cover_file_urlvarchar(255)Cover Image URLYES
more_infojsonMore InfoYES
view_countint UNSIGNEDNumber of View0NOCount by plugin
like_countint UNSIGNEDLike Count0NONumber of users who liked the topic
dislike_countint UNSIGNEDDislike Count0NONumber of users who disliked the topic
follow_countint UNSIGNEDFollow Count0NONumber of users who followed (bookmarked) the topic
block_countint UNSIGNEDBlock Count0NONumber of users who blocked (not interested) the topic
post_countint UNSIGNEDPost Count0NONumber of posts associated with the topic
comment_countint UNSIGNEDComment Count0NONumber of comments associated with the topic
post_digest_countint UNSIGNEDDigest Post Count0NOPlugin operation to digest posts, plugin counts addition and subtraction
comment_digest_countint UNSIGNEDDigest Comment Count0NOPlugin operation to digest comments, plugin counts addition and subtraction
last_post_attimestampLast Post Published TimeYES
last_comment_attimestampLast Comment Published TimeYES
is_enabledtinyint UNSIGNEDIs Enabled1NO0.Disabled / 1.Enabled
created_attimestampCreate TimeuseCurrentNOFor example, MySQL defaults to CURRENT_TIMESTAMP
updated_attimestampUpdate TimeYES
deleted_attimestampDelete TimeYES

Released under the Apache-2.0 License