groups

Column Name	Type	Comment	Default	Null	Remark
id	int UNSIGNED	Group ID		NO	Auto Increment
gid	varchar(32)	Public ID		NO	Unique
parent_id	int UNSIGNED	Parent Group ID		YES	Used when type=2
user_id	bigint UNSIGNED	Creator ID		YES	Related field users->id
name	varchar(64)	Group Name		NO	Multilingual
description	text	Group Description		YES	Multilingual
type	tinyint UNSIGNED	Is Group Category	2	NO	1.Group Category (only as a parent group, not for publish) 2.Group 3.Subgroup, group within a group
type_mode	tinyint UNSIGNED	Group Mode	1	NO	1.Public (anyone can view group posts) 2.Non-public (only members can view group posts)
type_mode_end_after	tinyint UNSIGNED	Non-public Group Configuration	1	NO	1.No restrictions 2.All group content invisible 3.Content visible before expiration, new content not visible
type_find	tinyint UNSIGNED	Is Discoverable Also understood as whether to display	1	NO	1.Discoverable (anyone can find this group) 2.Undiscoverable (only members can find this group)
type_follow	tinyint UNSIGNED	Follow Method	1	NO	1.Native / 2.Plugin / 3.Closed
plugin_fskey	varchar(64)	Related Plugin		YES	Used when type_follow=2 Related field plugins->fskey
sublevel_public	tinyint UNSIGNED	Type=3 specific Are subgroups public	0	NO	0.Not public, group-specific 1.Public, visible to the entire site
cover_file_id	bigint UNSIGNED	Group Cover Image ID		YES	Related field files->id
cover_file_url	varchar(255)	Group Cover Image URL		YES
banner_file_id	bigint UNSIGNED	Group Banner Image ID		YES	Related field files->id
banner_file_url	varchar(255)	Group Banner Image URL		YES
rating	smallint UNSIGNED	Display Order	9	NO	Ascending order
is_recommend	tinyint UNSIGNED	Recommended Status	0	NO	0.Not recommended / 1.Recommended
recommend_rating	smallint UNSIGNED	Recommended Order	9	NO	Ascending order
permissions	json	Permission Parameters		NO
like_count	int UNSIGNED	Number of Likes	0	NO	Number of users who liked this group
dislike_count	int UNSIGNED	Number of Dislikes	0	NO	Number of users who disliked this group
follow_count	int UNSIGNED	Number of Followers	0	NO	Number of users who followed (bookmarked) this group
block_count	int UNSIGNED	Number of Blocks	0	NO	Number of users who blocked (not interested in) this group
post_count	int UNSIGNED	Number of Posts	0	NO	Number of posts published in this group
comment_count	int UNSIGNED	Number of Comments	0	NO	Number of comments published in this group
post_digest_count	int UNSIGNED	Number of digest Posts	0	NO	Plugin operation to digest posts, plugin adds and subtracts count
comment_digest_count	int UNSIGNED	Number of digest Comments	0	NO	Plugin operation to digest comments, plugin adds and subtracts count
is_enabled	tinyint UNSIGNED	Is Enabled	1	NO	0.Not enabled / 1.Enabled
created_at	timestamp	Create Time	CURRENT_TIMESTAMP	NO
updated_at	timestamp	Update Time		YES
deleted_at	timestamp	Delete Time		YES

Introduction to Permission Parameters

{
    // Whitelist roles for non-public mode
    "mode_whitelist_roles": [
        "2", "3"
    ],
    // Post publishing settings
    "publish_post": 1, // Post publishing permissions 1.All users 2.Users who followed the group only 3.Only specified role users 4.Group administrators only
    "publish_post_roles": [
        // Authorized role IDs, Related field roles->id
        "2", "3"
    ],
    "publish_post_review": false, // Enable post review
    // Comment publishing settings
    "publish_comment": 1, // Comment publishing permissions 1.All users 2.Users who followed the group only 3.Only specified role users 4.Group administrators only
    "publish_comment_roles": [
        "2", "3"
    ],
    "publish_comment_review": false, // Enable comment review
    // Additional custom settings can be added below
}

Default values of Permission Parameters

{"mode_whitelist_roles":[],"publish_post":1,"publish_post_roles":[],"publish_post_review":false,"publish_comment":1,"publish_comment_roles":[],"publish_comment_review":false}