archives

Column Name	Type	Comment	Default	Null	Remark
id	int UNSIGNED	Primary Key ID		NO	Auto Increment
app_fskey	varchar(64)	Related Plugin		NO	Related field apps->fskey Which plugin created it
name	json	Name		YES	Multilingual
description	json	Description		YES	Multilingual
code	varchar(32)	Code		NO	Unique，English letters only, no symbols or spaces supported
usage_type	tinyint UNSIGNED	Usage Type		NO	Content Type
usage_group_id	int UNSIGNED	Used for group content	0	NO	Related field groups->id Use with post or comment
form_type	varchar(16)	Form Element		NO
form_options	json	Option Type Configuration Value		YES	Multilingual Array format, Provides option values for select, checkbox, radio, etc.
is_tree_option	tinyint UNSIGNED	Is tree option	0	NO	0.No / 1.Yes
is_multiple	tinyint UNSIGNED	Is Multiple	0	NO	0.No / 1.Yes Valid for select element
is_required	tinyint UNSIGNED	Is Required	0	NO	0.No / 1.Yes
file_type	tinyint UNSIGNED	File Type		YES	form_type=file 1.Image / 2.Video / 3.Audio / 4.Document
input_pattern	varchar(128)	Custom Regular Expression		YES
input_max	smallint UNSIGNED	Maximum Value		YES
input_min	smallint UNSIGNED	Minimum Value		YES
input_maxlength	smallint UNSIGNED	Maximum Length		YES
input_minlength	smallint UNSIGNED	Minimum Length		YES
sort_order	smallint UNSIGNED	Sorting Order	9	NO	Ascending order
is_enabled	tinyint UNSIGNED	Is Valid	1	NO	0.Invalid / 1.Valid Invalid after, all related are invalid
created_at	timestamp	Create Time	useCurrent	NO	For example, MySQL defaults to CURRENT_TIMESTAMP
updated_at	timestamp	Update Time		YES
deleted_at	timestamp	Delete Time		YES

Introduction to the form_type field

form_type	HTML Code	Description
input	<input type="text">	Single-line text
textarea	<textarea></textarea>	Multi-line text
select	<select></select>	Dropdown select
radio	<input type="radio">	Radio
checkbox	<input type="checkbox">	Checkbox
color	<input type="color">	Color picker
time	<input type="time">	Time picker
date	<input type="date">	Date picker
month	<input type="month">	Month picker
datetime	<input type="datetime-local">	Date and time picker
number	<input type="number">	Number input
email	<input type="email">	Email input
url	<input type="url">	URL input
file	<input type="file">	Single file upload
tags	<input type="text">	Tags input, format ["tag", "tag"]

Introduction to the form_options field

{
    "{langTag}": [
        {"name": "IT", "value": 1, "options": [
            {"name": "Internet", "value": 11, "options": []}
        ]},
        {"name": "Manufacturing", "value": 2, "options": []},
        {"name": "Medical", "value": 3, "options": []},
        {"name": "Finance", "value": 4, "options": []},
        {"name": "Business", "value": 5, "options": []},
        {"name": "Culture", "value": 6, "options": []},
        {"name": "Art", "value": 7, "options": []},
        {"name": "Law", "value": 8, "options": []},
        {"name": "Education", "value": 9, "options": []},
        {"name": "Administration", "value": 10, "options": []}
    ]
}