Skip to content
On this page


Column NameTypeCommentDefaultNullRemark
idbigint UNSIGNEDPrimary Key IDNOAuto Increment
user_idbigint UNSIGNEDAuthor IDNORelated field users->id
post_idbigint UNSIGNEDPost IDYESRelated field posts->id
parent_post_idbigint UNSIGNEDParent post IDYESRelated field posts->id
Empty means no referenced post
create_typetinyint UNSIGNEDCreation type1NO1.Quick create / 2.Editor create / 3.Restore from post
is_plugin_editortinyint UNSIGNEDEdit only in plugin0NO0.No / 1.Yes
editor_fskeyvarchar(64)Content editor pluginYESRelated field plugins->fskey
group_idint UNSIGNEDGroup IDYESRelated field groups->id
contentlongtextContentYESFull content
is_markdowntinyint UNSIGNEDIs content in MD format0NO0.No / 1.Yes
is_anonymoustinyint UNSIGNEDIs anonymous0NO0.No / 1.Yes
is_comment_disabledtinyint UNSIGNEDAre comments disabled?0NO0.No / 1.Yes
is_comment_privatetinyint UNSIGNEDAre comments private?
Private only visible to the author of the post
0NO0.No / 1.Yes
map_jsonjsonLocation informationYESEmpty means not creating or clearing when modifying
read_jsonjsonRead permission settingsYESEmpty means not creating or clearing when modifying
user_list_jsonjsonSpecific user settingsYESEmpty means not creating or clearing when modifying
comment_btn_jsonjsonComment function button settingsYESEmpty means not creating or clearing when modifying
statetinyint UNSIGNEDStatus1NO1.Unpublished (draft)
2.Published (under review)
3.Published (approved and archived)
4.Published (not approved, draft status again)
reasonvarchar(255)Review rejection reasonYESUsed when review is rejected
submit_attimestampSubmit review timeYES
created_attimestampCreate TimeCURRENT_TIMESTAMPNOAs draft Create Time
updated_attimestampUpdate TimeYES
deleted_attimestampDelete TimeYES

post_id Field Description

  • Empty means a new draft, which may have more than one record, equivalent to the same author having more than one draft to publish.
  • If there is an ID
    • state=1, 2, 4 means that the existing content of the ID's post is being edited, and that no new drafts can be created for that ID, i.e. there can only be one draft being edited for the same post.
    • state=3 is the official version of the ID's post history, and there may be more than one.

Field: map_json Location information

// Parameters of fields not specified will not be stored separately, but along with the complete JSON in post_appends->map_json.
    "mapId": "post_appends->map_id",
    "latitude": "posts->map_latitude",
    "longitude": "posts->map_longitude",
    "scale": "post_appends->map_scale",
    "continent": "",
    "continentCode": "post_appends->map_continent_code",
    "country": "",
    "countryCode": "post_appends->map_country_code",
    "region": "",
    "regionCode": "post_appends->map_region_code",
    "city": "",
    "cityCode": "post_appends->map_city_code",
    "district": "",
    "address": "",
    "zip": "post_appends->map_zip",
    "poi": "",
    "poiId": "post_appends->map_poi_id",
    "mapId": 2,
    "latitude": 37.3185039,
    "longitude": -122.0288017,
    "scale": 14,
    "continent": "North America",
    "continentCode": "NA",
    "country": "United States",
    "countryCode": "US",
    "region": "California",
    "regionCode": "CA",
    "city": "Santa Clara",
    "cityCode": "SC",
    "district": "Cupertino",
    "address": "10800 Torre Ave, Cupertino, CA 95014",
    "zip": "95014",
    "poi": "Cupertino Library",
    "poiId": "TRDucfBPkhuzzR9a7",

Field: read_json Read permission configuration

    "isReadLocked": "post_appends->is_read_locked",
    "btnName": [
            "langTag": "en Language Tag",
            "name": "post_appends->read_btn_name / Button name"
    "previewPercentage": "post_appends->read_pre_percentage",
    "permissions": {
        "users": [
            1, 2,
            "userId", "userId"
            // Publish to post_auths->object_id
            // post_auths->type = 1
        "roles": [
            1, 2,
            "roleId", "roleId"
            // Publish to post_auths->object_id
            // post_auths->type = 2
    "pluginFskey": "post_appends->read_plugin_fskey"

Field: user_list_json List of affiliated users

    "isUserList": "post_appends->is_user_list",
    "userListName": [
            "langTag": "en Language Tag",
            "name": "post_appends->user_list_name / affiliated name"
    "pluginFskey": "post_appends->user_list_plugin_fskey"

Field: comment_btn_json Comment Settings

    "isCommentBtn": "post_appends->is_comment_btn",
    "btnName": [
            "langTag": "en Language Tag",
            "name": "post_appends->comment_btn_name / Button name"
    "pluginFskey": "post_appends->comment_btn_plugin_fskey"

Released under the Apache-2.0 License