Skip to content


Column NameTypeCommentDefaultNullRemark
idint UNSIGNEDPrimary Key IDNOAuto Increment
item_keyvarchar(64)Key NameNOUnique
item_valuelongtextKey ValueYES
item_typevarchar(16)Key TypestringNO
item_tagvarchar(32)Key TagNO
is_multilingualtinyint UNSIGNEDIs Multilingual0NO0. No / 1. Yes
is_customtinyint UNSIGNEDIs Custom1NO0. No / 1. Yes
0 means system-built, 1 means added by plugin
is_apitinyint UNSIGNEDIs API Output0NO0. Forbidden / 1. Allowed
created_attimestampCreate TimeCURRENT_TIMESTAMPNO
updated_attimestampUpdate TimeYES
deleted_attimestampDelete TimeYES

Key Type item_type

Based on JSON data type, extended with three types: file, plugin, and plugins.

file type: If the key value is a number, it represents the file ID, and the file URL is output with the ID. Otherwise, it represents the file URL and is output as is.

plugin type represents the plugin fskey value, and the plugin URL is output with the fskey.

plugins type represents multiple selected plugins, stored in Array format, replacing the fskey with the URL to output the plugin URL.

// plugins format
        "order": 1,
        "code": "code",
        "fskey": "fskey"

Plugins need to determine whether plugins->plugin_host has a value; if it has a value, the plugin table's plugin_host + access_path fields are concatenated into a complete URL; if it has no value, the .env APP_URL + plugins->access_path field are concatenated into a complete URL.

  • number
  • string
  • boolean
  • array
  • object
  • file
  • plugin
  • plugins

For file, plugin, and plugins types of key values, the corresponding URL needs to be output.

Released under the Apache-2.0 License