Skip to content


Column NameTypeCommentDefaultNullRemark
idbigint UNSIGNEDPrimary Key IDNOAuto Increment
user_idbigint UNSIGNEDAuthor IDNORelated field users->id
comment_idbigint UNSIGNEDComment IDYESRelated field comments->id
post_idbigint UNSIGNEDPost IDNORelated field posts->id
parent_comment_idbigint UNSIGNEDParent Comment IDYESRelated field comments->id
Empty means a top-level comment
create_typetinyint UNSIGNEDCreation type1NO1.Quick creation / 2.Editor creation / 3.Recovered from post
is_plugin_editortinyint UNSIGNEDIs it edited only in the plugin?0NO0.No / 1.Yes
editor_fskeyvarchar(64)Content Editing PluginYESRelated field plugins->fskey
contentlongtextContentYESFull content
is_markdowntinyint UNSIGNEDIs the content in MD format?0NO0.No / 1.Yes
is_anonymoustinyint UNSIGNEDIs it anonymous?0NO0.No / 1.Yes
map_jsonjsonLocation informationYESEmpty value means not to create or clear when modifying
statetinyint UNSIGNEDStatus1NO1.Unpublished (Draft)
2.Published (Under review)
3.Published (Approved and archived)
4.Published (Rejected, back to draft status)
reasonvarchar(255)Review rejection reasonYESUsed when rejected in review
submit_attimestampSubmit review timeYES
created_attimestampCreate TimeCURRENT_TIMESTAMPNO
updated_attimestampUpdate TimeYES
deleted_attimestampDelete TimeYES

comment_id Field Description

  • If empty, it represents a new comment draft, and there can be multiple records, equivalent to a single author having multiple drafts waiting to be published.
  • When there is an ID:
    • state=1, 2, or 4 means editing the existing content of the comment with that ID. No new drafts can be created for that ID, which is equivalent to having only one draft being edited for the same comment.
    • state=3 represents the historical official versions of the comment with that ID, which can have multiple instances.

post_id Field Description

  • Cannot be empty, as it records to which post the comment belongs.
  • Only top-level comments can have drafts; child comments cannot generate drafts, so the comment_id is not the parent comment ID.
  • state=1, 2, or 4 represents unpublished comments, and at this time, no new comment drafts for that post can be created. This is equivalent to having only one comment draft for the same post.
  • state=3, at this time, the comment_id is completed, indicating the historical versions of the comment with that comment_id.

Field: map_json Location information

// Parameters of fields not specified will not be stored separately, but along with the complete JSON in comment_appends->map_json.
    "mapId": "comment_appends->map_id",
    "latitude": "comments->map_latitude",
    "longitude": "comments->map_longitude",
    "scale": "comment_appends->map_scale",
    "continent": "",
    "continentCode": "comment_appends->map_continent_code",
    "country": "",
    "countryCode": "comment_appends->map_country_code",
    "region": "",
    "regionCode": "comment_appends->map_region_code",
    "city": "",
    "cityCode": "comment_appends->map_city_code",
    "district": "",
    "address": "",
    "zip": "comment_appends->map_zip",
    "poi": "",
    "poiId": "comment_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",

Released under the Apache-2.0 License