Skip to content


Column NameTypeCommentDefaultNullRemark
idbigint UNSIGNEDPrimary Key IDNOAuto Increment
post_idbigint UNSIGNEDPost IDNORelated field posts->id
is_plugin_editortinyint UNSIGNEDEdit only in plugin0NO0.No / 1.Yes
editor_fskeyvarchar(64)Content editor pluginYESRelated field plugins->fskey
can_deletetinyint UNSIGNEDCan author delete?1NO0.No / 1.Yes
is_read_lockedtinyint UNSIGNEDIs a reading auth required0NO0.No / 1.Yes
read_pre_percentagetinyint UNSIGNEDRead permission - content display ratio when unauthorizedYESPercentage
30 means displaying 30% of the content
read_btn_namevarchar(64)Read permission - button text when unauthorizedYESMultilingual
read_plugin_fskeyvarchar(64)Read permission - handling pluginYESRelated field plugins->fskey
is_user_listtinyint UNSIGNEDIs there a special user list?0NO0.No / 1.Yes
user_list_namevarchar(128)Specific user nameYESMultilingual
For example: Rewarding users, Purchasing users, Downloaded users
user_list_plugin_fskeyvarchar(64)Specific user source pluginYESRelated field plugins->fskey
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
is_comment_btntinyint UNSIGNEDDoes the comment have an extended button?
This button is only visible to the post author
0NO0.No / 1.Yes
comment_btn_namevarchar(64)Comment extended button - button textYESMultilingual
comment_btn_stylevarchar(64)Comment extended button - styleYESprimary / secondary / success / danger / warning / info
comment_btn_plugin_fskeyvarchar(64)Comment extended button - handling pluginYESRelated field plugins->fskey
more_jsonjsonAdditional information fieldYESFor example: Publisher IP location name, device name, etc.
map_jsonjsonMap - Detailed informationYES
map_idtinyint UNSIGNEDMap - Service provider IDYESSource map service provider key-value dictionary
map_continent_codevarchar(8)Map - Continent codeYES
map_country_codevarchar(8)Map - Country codeYES
map_region_codevarchar(8)Map - Region codeYES
map_city_codevarchar(8)Map - City codeYES
map_zipvarchar(32)Map - zipYES
map_poi_idvarchar(64)Map - POI IDYESMap service provider exclusive ID
edit_countsmallint UNSIGNEDNumber of edits0NOTotal number of edits
created_attimestampCreate TimeCURRENT_TIMESTAMPNO
updated_attimestampUpdate TimeYES
deleted_attimestampDelete TimeYES

map_json Complete Information

    "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