Skip to content
On this page

post_appends

Column NameTypeCommentDefaultNullRemark
idbigint UNSIGNEDPrimary Key IDNO自动递增
post_idbigint UNSIGNED帖子 IDNO关联字段 posts->id
is_plugin_editortinyint UNSIGNED是否仅在插件中编辑0NO0.否 / 1.是
editor_unikeyvarchar(64)内容编辑插件YES关联字段 plugins->unikey
can_deletetinyint UNSIGNED作者是否有权删除1NO0.否 / 1.是
is_allowtinyint UNSIGNED是否有权限0NO0.否 / 1.是
allow_proportiontinyint UNSIGNED阅读权限-无权时内容显示比例YES百分比
30 代表显示 30% 的内容
allow_btn_namevarchar(64)阅读权限-无权时按钮文字YES多语言
allow_plugin_unikeyvarchar(64)阅读权限-处理插件YES关联字段 plugins->unikey
is_user_listtinyint UNSIGNED是否有特殊用户列表0NO0.否 / 1.是
user_list_namevarchar(128)特定用户的名称YES多语言
比如:打赏用户、购买用户、已下载用户
user_list_plugin_unikeyvarchar(64)特定用户来源插件YES关联字段 plugins->unikey
is_commenttinyint UNSIGNED是否可评论1NO0.否 / 1.是
is_comment_publictinyint UNSIGNED是否公开评论
不公开将仅帖子作者可见
1NO0.否 / 1.是
is_comment_btntinyint UNSIGNED评论是否有扩展按钮
该按钮仅帖子作者可见
0NO0.否 / 1.是
comment_btn_namevarchar(64)评论扩展按钮-按钮文字YES多语言
comment_btn_stylevarchar(64)评论扩展按钮-风格YESprimary / secondary / success / danger / warning / info
comment_btn_plugin_unikeyvarchar(64)评论扩展按钮-处理插件YES关联字段 plugins->unikey
ip_locationvarchar(64)IP 地区名YES
map_jsonjson地图-详细信息YES
map_scalevarchar(8)地图-比例YES缩放比例,范围 5~18
map_continent_codevarchar(8)地图-洲代码YES亚洲 AS
map_country_codevarchar(8)地图-国家代码YES中国 CN
map_region_codevarchar(8)地图-省或州代码YES江苏 JS
map_city_codevarchar(8)地图-城市代码YES苏州 SZ
map_cityvarchar(64)地图-城市名YES苏州 Suzhou
map_zipvarchar(32)地图-行政区划代码YES215000
map_poivarchar(128)地图-POI 信息YES
map_poi_idvarchar(64)地图-POI IDYES地图服务商专属 ID
edit_countsmallint UNSIGNED编辑次数0NO共编辑了几次
created_attimestampCreate TimeCURRENT_TIMESTAMPNO
updated_attimestampUpdate TimeYES
deleted_attimestampDelete TimeYES

map_json 完整信息

json
{
    "mapId": "posts > map_id",
    "latitude": "posts > map_latitude",
    "longitude": "posts > map_longitude",
    "scale": "post_appends > map_scale",
    "continent": "Asia",
    "continentCode": "AS",
    "country": "China",
    "countryCode": "CN",
    "region": "Jiangsu",
    "regionCode": "JS",
    "city": "Suzhou",
    "cityCode": "SZ",
    "district": "Taicang",
    "address": "xxx",
    "zip": "215400",
    "poi": "",
    "poiId": "",
}

Released under the Apache-2.0 License