comment_appends

Column Name	Type	Comment	Default	Null	Remark
id	bigint UNSIGNED	Primary Key ID		NO	Auto Increment
comment_id	bigint UNSIGNED	Comment ID		NO	Related field comments->id
is_plugin_editor	tinyint UNSIGNED	Is it edited only in the plugin?	0	NO	0.No / 1.Yes
editor_fskey	varchar(64)	Content Editing Plugin		YES	Related field plugins->fskey
can_delete	tinyint UNSIGNED	Does the author have the right to delete?	1	NO	0.No / 1.Yes
is_close_btn	tinyint UNSIGNED	Is the comment extension button closed?	0	NO	0.No / 1.Yes Corresponding field post_appends->is_comment_btn
is_change_btn	tinyint UNSIGNED	Is the comment extension button replaced?	0	NO	0.No / 1.Yes
btn_name_key	varchar(64)	Replacement button name key		YES	Related field configs->item_key
btn_style	varchar(64)	Button style		YES	primary / secondary / success / danger / warning / info
more_json	json	Additional information field		YES	E.g. publisher IP location name, device name, etc.
map_json	json	Map - Detailed information		YES
map_id	tinyint UNSIGNED	Map - Service provider number		YES	Source map service provider key-value dictionary
map_continent_code	varchar(8)	Map - Continent code		YES
map_country_code	varchar(8)	Map - Country code		YES
map_region_code	varchar(8)	Map - Region code		YES
map_city_code	varchar(8)	Map - City code		YES
map_zip	varchar(32)	Map - zip		YES
map_poi_id	varchar(64)	Map - POI ID		YES	Map service provider exclusive ID
edit_count	smallint UNSIGNED	Number of edits	0	NO	Total number of edits
created_at	timestamp	Create Time	CURRENT_TIMESTAMP	NO
updated_at	timestamp	Update Time		YES
deleted_at	timestamp	Delete Time		YES

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",
}