Discuz Database Tables

http://faq.comsenz.com/library/database/x3/x3_index.htm Discuz database Table Dictionary

Discuz X3 each database table uses

Pre_common_addon plug-in Extension Center service table  
Pre_common_admincp_cmenu Background Management panel, customizing the Common menu table  
Pre_common_admincp_ Group background Team job name table  
Pre_common_admincp_member background Administrator member table  
Pre_common_admincp_perm Background Team title Rights Assignment Table  
Pre_common_admincp_session Admin Panel login Session table  
Pre_common_admingroup Background Management Group Rights Assignment table  
Pre_common_ Adminnote management team Message form  
pre_common_advertisement ad bit Management table  
Pre_common_advertisement_custom ad bit custom name  
pre_common_banned prohibit IP table  
Pre_common_block DIY module table  
pre_common_block_favorite DIY Module Collection table: The module management of portal management uses  
Pre_common_block_item DIY Module property sheet  
pre_common_block_item_data DIY module data sheet  
Pre_ Common_block_permission DIY module permission table  
pre_common_block_pic DIY module picture table  
Pre_common_block_style DIY Module style table  
Pre_common_block_xml Module XML extension class data table

Pre_common_cache public Cache table  
Pre_common_card Prepaid card table  
Pre_common_connect_guest QQ connected visitors table  
Pre_ Common_credit_log integral Record table  
Pre_common_credit_log_field Integration Record Details 3.0 version increased  
Pre_common_credit_rule Integration Strategy table  
Pre_common_credit_rule_log integration policy effective record  
Pre_common_credit_rule_log_field integration policy effective record extension  
Pre_common_cron Scheduled Task table  
Pre_common_devicetoken Device Data table 3.0 add  
pre_common_district area list  
Pre_common_diy_data DIY Data Sheet  
Pre_common_domain apply Domain name assignment table  
Pre_common_failedlogin normal login failure log table  
Pre_common_friendlink links table  
pre_common_grouppm mass sms list content  
Pre_common_invite Invitation Code table  
Pre_ Common_magic props table  
Pre_common_magiclog Item Log table  
Pre_common_mailcron Mail Schedule Task table  
Pre_common_ MailQueue Mail send queue table  
pre_common_member User table, password is randomly generated records, actually recorded in ucenter 
Pre_common_member_action_log User table operation log table  
Pre_common_member_connect user QQ interconnection table  
Pre_common_member_count user Data statistics

Pre_common_member_crime User penalty action 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 journal  
pre_common_member_grouppm user mass message status table  
Pre_common_member_log user Action Log table  
Pre_common_member_magic user item Configuration table  
Pre_common_member_ Medal User medal table  
Pre_common_member_newprompt user new Reminder table  
Pre_common_member_profile user personal Information table  
Pre_ Common_member_profile_setting User personal Information Settings table &NBSP
pre_common_member_security Personal Information modification audit  
Pre_common_member_ Stat_field User Status Field table  
Pre_common_member_status user Status table  
Pre_common_member_validate user authentication audit  
Pre_common_member_verify user authentication settings  
Pre_common_member_verify_info user authentication information  
Pre_common_moderate Audit Data Sheet  
Pre_common_myapp roaming application table  
Pre_common_myapp_count roaming Application Data statistics  
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 Cache Table
PRE_COMMON_REGIP registered IP table, anti-duplicate registration up to five times
Pre_common_relatedlink RELATED LINKS
Pre_common_report Report Form
Pre_common_searchindex Search Index Table
Pre_common_secquestion password question and answer table
Pre_common_session User Login Session Table
pre_common_setting Site setup Parameters table
Pre_common_smiley expression Table
Pre_common_sphinxcounter Sphinx Search Program with table
Pre_common_stat Statistics
Pre_common_statuser Statistics User Table
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 Permissions table
Pre_common_usergroup_field User Group Permissions table
Pre_common_visit Access table
Pre_common_word_type Sensitive Word Type table
Pre_connect_disktask Disk Tasks
Pre_connect_feedlog Connect Feed Log table
Pre_connect_memberbindlog Connect user bindings/Unbind record table
Pre_connect_postfeedlog Connect reply posts feed log
Pre_connect_tthreadlog Connect post posts feed log
Pre_connect_tlog Weibo log table
Pre_forum_access Forum access permissions separate settings table
Pre_forum_activity Forum Activity Table
Pre_forum_activityapply Forum Event Registration Form
Pre_forum_announcement Forum Bulletin Form
Pre_forum_attachment 1.5 = forum attachment table, x2 = Attachment Index Table
Pre_forum_attachment_0 attachment table (x2), with the last digit of the table name = Attachment Tid last
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 album table  
pre_forum_collectioncomment Amoy Comments Table  
Pre_forum_ Collectionfollow   Subscription form,
Pre_forum_collectioninvite invite Management Amoy album table  
pre_forum_collectionrelated Amoy Theme is income album table  
pre_forum_collectionteamworker cooperation Edit Table  
Pre_forum_collectionthread the theme table  
Pre_forum_creditslog Forum points Journal table  
pre_forum_debate debate topic table  
Pre_forum_debatepost debate post table  
Pre_ Forum_faq common question and Answer table  
Pre_forum_filter_post filter reply table  
Pre_forum_forum Forum plate  
Pre_forum_forumfield Forum plate set Table  
Pre_forum_forumrecommend section recommended  
pre_forum_forum_threadtable main list  
Pre_forum_ Groupcreditslog group score log  
Pre_forum_groupfield Group table  
Pre_forum_groupinvite Group Invitation form

Pre_forum_grouplevel Group Level table  
Pre_forum_groupuser Group User table  
Pre_forum_hotreply_member hot reply User table  
Pre_forum_hotreply_number Hot reply number table  
Pre_forum_imagetype image Type table  
Pre_forum_medal medal table  
Pre_forum_medallog Medal issued  
Pre_forum_memberrecommend user Referral table  
Pre_forum_moderator Moderator table  
Pre _forum_modwork Moderator sheet  
Pre_forum_newthread Forum New topic table  
pre_forum_onlinelist Forum online list  
Pre_forum_ Order Forum Orders form  
Pre_forum_poll Forum poll  
pre_forum_polloption Forum voting options table  
Pre_forum_polloption_ Image Voting options picture table  
Pre_forum_pollvoter Forum Voting user table  
Pre_forum_post Forum reply table  
Pre_forum_postcomment Post comment form  
Pre_forum_postlog reply to log table  
pre_forum_postposition reply Floor table  
Pre_forum_poststick Reply to the topic  
Pre_forum_post_moderate Forum reply to the Management table  
Pre_forum_post_location Forum Reply to geographic Information location table  
Pre_ Forum_post_tableid the ID of the post after the table has been returned

Pre_forum_postcache Forum reply cache table  
Pre_forum_postcomment Forum reply to the Review form  
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 related Posts table  
Pre_forum_rsscache rss cache table  
Pre_forum_sofa Forum sha  
Pre_forum_ Spacecache Spatial information cache table  
Pre_forum_statlog Forum Statistics log  
Pre_forum_thread main posts list  
Pre_forum_ Threadpreview main post preview table  
Pre_forum_threadprofile posts Information sheet  
Pre_forum_threadprofile_group post Information Group table  
Pre_forum_threadcalendar post Calendar table  
pre_forum_thread_moderate topic Management table  
Pre_forum_threadaddviews Post view digital table  
Pre_forum_threadclass post classification table  
pre_forum_threadclosed post Close table  
Pre_forum_ Threaddisablepos post Cancel table  
pre_forum_threadhot hot Topic table  
pre_forum_threadimage theme Picture table  
Pre_forum _threadlog topic Log table  
Pre_forum_threadmod topic Management Record Table

Pre_forum_threadtype topic Classification Information table  
Pre_forum_trade product Data sheet  
Pre_forum_tradecomment product comment  
Pre_forum_tradelog Commodity post transaction log  
pre_forum_typeoption type option  
Pre_forum_typeoptionvar type option parameter  
Pre_forum_typevar type parameter  
pre_forum_warning warning table  
pre_home_album Homeland album table  
Pre_home_album_ Category Home album classification table  
Pre_home_appcreditlog Home Application score log  
Pre_home_blacklist homeland blacklist table  
Pre_home_ Blog Home Blogs table  
Pre_home_blogfield Home Blog content table  
pre_home_blog_category Homeland Blog classification table  
Pre_home_blog_ Moderate Homeland log Management table  
Pre_home_class log Personal classification table  
Pre_home_click to log and picture gesture  
Pre_home_clickuser static user table  
Pre_home_comment home Comment form  
Pre_home_comment_moderate Homeland Comment message Management table  
Pre_home_docomment Home record reply form  
pre_home_doing home record table  
pre_home_doing_moderate Homeland Records Management table  
Pre_home_favorite Home Collection Table

Pre_home_feed home Dynamic table  
Pre_home_feed_app roaming app dynamic table  
Pre_home_follow home listening table  
Pre_home_ Follow_feed listen to the Feed table  
Pre_home_follow_feed_archiver listen to the archive table  
Pre_home_friend Home Friends table  
Pre_home _friendlog Friend log table  
pre_home_friend_request Friend request table  
pre_home_notification notification message  
Pre_home_pic Home picture table  
pre_home_pic_moderate Homeland Log Management table  
Pre_home_picfield album related information table  
Pre_home_poke Greeting Table  
Pre_home_pokearchive Greeting archive  
Pre_home_share sharing table  
Pre_home_share_moderate home sharing management table  
Pre_ Home_show declaration  
Pre_home_specialuser star Membership table  
Pre_home_userapp roaming app 
Pre_home_userappfield Roaming app 
Pre_home_userapp_stat roaming app statistics  
Pre_home_viewlog log and User access record table  
Pre_home_visitor Recent Visitor record table  
Pre_home_follow broadcast listening table

Pre_home_follow_feed Broadcast Table
Pre_home_follow_feed_archiver Broadcast Archive table
Pre_mobile_setting Phone Settings table
Pre_portal_article_content article content table
Pre_portal_article_count Article Count table
Pre_portal_article_moderate Portal Article Management table

Discuz Database Tables