The following is how to organize Discuz! X3.0 database dictionary. The table name is divided into three parts, which are separated by the following line. The following example uses pre _ as the prefix. In the middle, such as common, forum, connect, home, and portal, each function module is used. Pre_common_addon extension center service provider table pre_common_admincp_cmenu background management panel,
The following is how to organize Discuz! X3.0 database dictionary. The table name is divided into three parts, which are separated by the following line. The following example uses pre _ as the prefix. In the middle, such as common, forum, connect, home, and portal, each function module is used.
Pre_common_addon extension center service provider table
Pre_common_admincp_cmenu background management panel to customize common menu tables
Pre_common_admincp_group background team Title table
Pre_common_admincp_member background administrator member table
Pre_common_admincp_perm background team job permission assignment table
Pre_common_admincp_session logon session table on the background management panel
Pre_common_admingroup permission assignment table of the background Management Group
Pre_common_adminnote
Pre_common_advertisement advertising space management table
Pre_common_advertisement_custom ad space custom name
Pre_common_banned disable ip table
Pre_common_block diy module table
Pre_common_block_favorite diy module favorite table: Used in module management of portal management
Pre_common_block_item diy module attribute table
Pre_common_block_item_data diy module data table
Pre_common_block_permission diy module permission table
Pre_common_block_pic diy module Image table
Pre_common_block_style diy module style table
Pre_common_block_xml module xml Extended Data table
Pre_common_cache public cache table
Pre_common_card recharge card table
Pre_common_connect_guest qq interconnected tourist table
Pre_common_credit_log point record table
Pre_common_credit_log_field point record details added in version 3.0
Pre_common_credit_rule credit policy table
Pre_common_credit_rule_log credit policy validity record
Pre_common_credit_rule_log_field credit policy effective record extension
Pre_common_cron scheduled task table
Pre_common_devicetoken device data table 3.0 added
Pre_common_district region list
Pre_common_diy_data diy data table
Pre_common_domain application domain name allocation table
Pre_common_failedlogin common logon failure log table
Pre_common_friendlink
Pre_common_grouppm
Pre_common_invite invitation code table
Pre_common_magic item table
Pre_common_magiclog prop log table
Pre_common_mailcron mail plan task table
Pre_common_mailqueue list of mailing queues
Pre_common_member user table. the password is a randomly generated record, and the actual record is in the ucenter
Pre_common_member_action_log user table operation log table
Pre_common_member_connect User qq table
Pre_common_member_count user data statistics table
Pre_common_member_crime user penalty operation table
Pre_common_member_field_forum user forum settings table
Pre_common_member_field_home user home settings table
Pre_common_member_forum_buylog Forum purchase log
Pre_common_member_grouppm user group message sending Status Table
Pre_common_member_log user operation log table
Pre_common_member_magic user item configuration table
Pre_common_member_medal user Medal table
Pre_common_member_newprompt New user reminder table
Pre_common_member_profile user personal information table
Pre_common_member_profile_setting user personal information settings table
Pre_common_member_security personal information modification review
Pre_common_member_stat_field user status field table
Pre_common_member_status User Status Table
Pre_common_member_validate user authentication review
Pre_common_member_verify user authentication settings
Pre_common_member_verify_info user authentication information
Pre_common_moderate review data table
Pre_common_myapp roaming application table
Pre_common_myapp_count roaming application data statistics table
Pre_common_myinvite roaming invitation table
Pre_common_mytask user Task table
Pre_common_nav navigation menu table
Pre_common_onlinetime online schedule
Pre_common_optimizer optimization table
Pre_common_patch vulnerability patch table
Pre_common_plugin plug-in table
Pre_common_pluginvar plug-in parameter table
Pre_common_process high-speed cache table
Pre_common_regip register the ip table, preventing repeated registration up to five times
Pre_common_relatedlink
Pre_common_report report table
Pre_common_searchindex
Pre_common_secquestion password Q & A table
Pre_common_session user logon session table
Pre_common_setting website settings parameter table
Pre_common_smiley emojis
Pre_common_sphinxcounter sphter
Pre_common_stat statistical table
Pre_common_statuser
Pre_common_style style table
Pre_common_stylevar style parameter table
Pre_common_syscache system parameter cache table
Pre_common_tag tag table
Pre_common_tagitem tag content table
Pre_common_task user Task table
Pre_common_taskvar task parameter table
Pre_common_template Template table
Pre_common_template_block template module table
Pre_common_template_permission template permission table
Pre_common_uin_black uin blacklist
Pre_common_usergroup user group table
Pre_common_usergroup_field User Group permission table
Pre_common_usergroup_field User Group permission table
Pre_common_visit access table
Pre_common_word_type sensitive word type table
Pre_connect_disktask
Pre_connect_feedlog connect feed log table
Pre_connect_memberbindlog connect user binding/unbinding record table
Pre_connect_postfeedlog connect Reply post feed log
Pre_connect_tthreadlog connect Post feed log
Pre_connect_tlog Weibo log table
Pre_forum_access
Pre_forum_activity forum activity table
Pre_forum_activityapply forum activity registration form
Pre_forum_announcement forum announcement table
Pre_forum_attachment 1.5 = Forum annex table, x2 = attachment index table
Pre_forum_attachment_0 attachment table (x2), which is the last digit of the table name = the last digit of the attachment tid.
Pre_forum_attachmentfield Forum attachment extension table (x2 to remove)
Pre_forum_attachment_exif Forum attachment exif information table
Pre_forum_attachment_unused unused attachment table
Pre_forum_attachtype Forum attachment type table
Pre_forum_bbcode Forum ubbcode table
Pre_forum_collection taotie album table
Pre_forum_collectioncomment comment table
Pre_forum_collectionfollow Taobao Post subscription table
Pre_forum_collectioninvite invites you to manage the Tao album table
Pre_forum_collectionrelated tao Post subject income album table
Pre_forum_collectionteamworker online editing table
Pre_forum_collectionthread tao Post contains topic table
Pre_forum_creditslog forum point log table
Pre_forum_debate debate topic table
Pre_forum_debatepost debate Post table
Pre_forum_faq FAQ
Pre_forum_filter_post filter reply table
Pre_forum_forum Forum table
Pre_forum_forumfield forum settings table
Pre_forum_forumrecommend recommended post table
Pre_forum_forum_threadtable primary Post table
Pre_forum_groupcreditslog group point log
Pre_forum_groupfield group table
Pre_forum_groupinvite group invitation table
Pre_forum_grouplevel group-level table
Pre_forum_groupuser group user table
Pre_forum_hotreply_member reply to the user table
Pre_forum_hotreply_number hot reply digital table
Pre_forum_imagetype image type table
Pre_forum_medal Medal table
Pre_forum_medallog medal issuing log table
Pre_forum_memberrecommend user recommendation table
Pre_forum_moderator moderator table
Pre_forum_modwork master worksheet
Pre_forum_newthread Forum New topic table
Pre_forum_onlinelist online forum list
Pre_forum_order Forum order table
Pre_forum_poll Forum voting Post table
Pre_forum_polloption Forum voting option table
Pre_forum_polloption_image voting option Image table
Pre_forum_pollvoter Forum voting user table
Pre_forum_post Forum Reply table
Pre_forum_postcomment Post comment table
Pre_forum_postlog reply log table
Pre_forum_postposition reply floor table
Pre_forum_poststick
Pre_forum_post_moderate Forum Reply management table
Pre_forum_post_location Forum Reply to location table of geographical information
Pre_forum_post_tableid: id of the reply post after table sharding
Pre_forum_postcache Forum Reply cache table
Pre_forum_postcomment Forum Reply comment table
Pre_forum_postlog Forum Reply log table
Pre_forum_poststick Forum Reply insert
Pre_forum_promotion website promotion table
Pre_forum_ratelog score log table
Pre_forum_relatedthread Post table
Pre_forum_rsscache rss cache table
Pre_forum_sofa Forum sofa table
Pre_forum_spacecache space information cache table
Pre_forum_statlog Forum statistics log
Pre_forum_thread primary Post list
Pre_forum_threadpreview master Post preview table
Pre_forum_threadprofile Post information table
Pre_forum_threadprofile_group Post information group table
Pre_forum_threadcalendar Post calendar
Pre_forum_thread_moderate topic management table
Pre_forum_threadaddviews
Pre_forum_threadclass Post category table
Pre_forum_threadclosed
Pre_forum_threaddisablepos
Pre_forum_threadhot topic table
Pre_forum_threadimage topic Image table
Pre_forum_threadlog topic log table
Pre_forum_threadmod topic management record table
Pre_forum_threadtype topic category information table
Pre_forum_trade data table
Pre_forum_tradecomment product Post comment
Pre_forum_tradelog transaction log
Pre_forum_tyexception type option
Pre_forum_typeoptionvar option parameter
Pre_forum_typevar type parameter
Pre_forum_warning warning table
Pre_home_album Home album
Pre_home_album_category Home album category table
Pre_home_appcreditlog home application point log
Pre_home_blacklist home blacklist table
Pre_home_blog home blog table
Pre_home_blogfield home blog content table
Pre_home_blog_category home Blog category table
Pre_home_blog_moderate home log management table
Pre_home_class personal log category table
Pre_home_click action on logs and images
Pre_home_clickuser static user table
Pre_home_comment home comment table
Pre_home_comment_moderate home comment and message management table
Pre_home_docomment home record reply table
Pre_home_doing home record table
Pre_home_doing_moderate home record management table
Pre_home_favorite home favorites table
Pre_home_feed dynamic table
Pre_home_feed_app dynamic table of roaming apps
Pre_home_follow home listening table
Pre_home_follow_feed
Pre_home_follow_feed_archiver listen to the archive table
Pre_home_friend friends table
Pre_home_friendlog friend log table
Pre_home_friend_request friend request table
Pre_home_notification notification message
Pre_home_pic Home image table
Pre_home_pic_moderate home log management table
Pre_home_picfield album information table
Pre_home_poke greeting table
Pre_home_pokearchive
Pre_home_share table
Pre_home_assist_moderate home sharing management table
Pre_home_show declaration
Pre_home_specialuser star member table
Pre_home_userapp roaming app
Pre_home_userappfield roaming app
Pre_home_userapp_stat roaming app statistics
Pre_home_viewlog and user access record table
Pre_home_visitor recent visitor record table
Pre_home_follow broadcast listener table
Pre_home_follow_feed broadcast table
Pre_home_follow_feed_archiver broadcast archive table
Pre_mobile_setting mobile phone settings table
Pre_portal_article_content content table
Pre_portal_article_count article counter table
Pre_portal_article_moderate portal article management table
