Skip to content


Column NameTypeCommentDefaultNullRemark
idbigint UNSIGNEDPrimary Key IDNOAuto Increment
comment_idbigint UNSIGNEDComment IDNORelated field comments->id
is_plugin_editortinyint UNSIGNEDIs it edited only in the plugin?0NO0.No / 1.Yes
editor_fskeyvarchar(64)Content Editing PluginYESRelated field plugins->fskey
can_deletetinyint UNSIGNEDDoes the author have the right to delete?1NO0.No / 1.Yes
is_close_btntinyint UNSIGNEDIs the comment extension button closed?0NO0.No / 1.Yes
Corresponding field post_appends->is_comment_btn
is_change_btntinyint UNSIGNEDIs the comment extension button replaced?0NO0.No / 1.Yes
btn_name_keyvarchar(64)Replacement button name keyYESRelated field configs->item_key
btn_stylevarchar(64)Button styleYESprimary / secondary / success / danger / warning / info
more_jsonjsonAdditional information fieldYESE.g. publisher IP location name, device name, etc.
map_jsonjsonMap - Detailed informationYES
map_idtinyint UNSIGNEDMap - Service provider numberYESSource 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