Dedecms database structure

This article is mainly written for secondary development of Dedecms in the future. The database structure of dedecms after installation is shown in (). after installation, dedecms has 86 data tables. Main data structure table dede_addonarticle: Additional article table aidint (11) Article No. typeidint (11) category column No. bodymediumtext article content

This article is mainly written for secondary development of Dedecms in the future. The database structure of dedecms after installation, as shown in,

After the installation, dedecms has a total of 86 data tables.

Main data structure table

Dede_addonarticle: Additional article table 
Aid int (11) Article No.
Typeid int (11) category column No.
Body mediumtext content
Dede_addonflash appended Flash table
Aid int (11) FLASH number
Typeid int (11) category column No.
Filesize varchar (10) file size
Playtime varchar (10) playback duration
Flashtype varchar (10) file type
Flashrank smallint (6) file level
Width smallint (6) film width
Height smallint (6) film height
Flashurl varchar (80) FLASH address

Dede_addonimages: Additional gallery table 
Aid int (11) gallery No.
Typeid int (11) category column No.
Pagestyle smallint (6) presentation mode (1 single page with 2 pages and 3 multiple rows and multiple columns)
Maxwidth smallint (6) limit width
Imgurls text image set content (tag storage)
Row smallint (6) multi-column parameters (rows)
Col smallint (6) multi-column parameters (columns)
Isrm smallint (6) whether to download remote images
Ddmaxwidth smallint (6) small image width limit

Dede_addonsoft Additional software table 
Aid int (11) software No.
Typeid int (11) category column No.
Filetype varchar (10) file type
Language varchar (10) interface language
Softtype varchar (10) software type
Accredit varchar (10) authorization method
OS varchar (30) running environment
Softrank int (11) software grade
OfficialUrl varchar (30) official website
OfficialDemo varchar (50) demo address
Softsize varchar (10) software size
Softlinks text software download link list
Introduction to introduce text software

 
Dede_addonspec: Additional topic table 
Aid int (11) Topic No.
Typeid int (11) category column No.
Note text topic content (only store tag code)
 

Dede_admin: Administrator information table 
ID int (10) automatic number
Usertype int (10) user type
Userid varchar (30) user logon ID
Pwd varchar (50) user password
Uname varchar (20) user pen name
Tname varchar (30) real name
Email varchar (30) email
Typeid int (11) channel (0 indicates all)
Logintime datetime logon time
Loginip varchar (20) logon IP

 
Dede_admintype : System User Group management table 
Rank smallint (6) group level No.
Typename varchar (30) group name
Whether system smallint (6) is the system default group
Purviews text permission list
 

Dede_arcatt:Document custom attribute table 
Att smallint (6) No.
Attname varchar (30) attribute name
Dede_archives article table
ID int (11) automatic number
Number of the main topic to which the typeid int (11) belongs
ID of the secondary topic to which the typeid2 int (11) belongs
Sortrank int (11) sorting of articles (top setting method)
Iscommend smallint (6) recommended?
Ismake smallint (6) whether to generate static
Model of the channel int (11) article
Arcrank smallint (6) read permission
Click int (11) clicks
Money smallint (6) consumption points
Title varchar (80) title
Subtitle title varchar (36) brief title
Color varchar (10) title color
Writer varchar (30) Author
Source varchar (50) source
Litpic varchar (100) thumbnail
Pubdate int (11) input time
Senddate int (11) release time
Arcatt smallint (6) custom attributes (att)
AdminID int (11) release administrator ID
MemberID int (11) released member ID
Description varchar (250) summary
Keywords varchar (60) keywords
Templet varchar (60) document template
Lastpost int (11) recent comments
Postnum int (11) comment count
Redirecturl varchar (150) redirection URL
Mtype int (11) user-defined classification
Userip varchar (20) user IP
Locklikeid smallint (6) whether to lock related articles
Likeid varchar (240) Article ID

Dede_arcrank: Read permission list 
ID int (10) automatic number
Rank smallint (10) permission level
Membername varchar (20) level name
Adminrank smallint (10) management level
Money int (11) consumption points

 
Dede_arctype : Column management table 
ID int (10) column number (automatic number)
ReID int (10) Parent column No.
TopID int (10)
Sortrank smallint (6) sorting number
Typename varchar (30) Topic Name
Typedir varchar (100) topic directory
Isdefault smallint (6) topic list option (1 link to Feature Page 0 link to list first page-1 use dynamic page)
Defaultname varchar (20) name of the details page
Does issend smallint (6) support submission?
Channeltype smallint (6) channel type
Maxpage int (11) reserved
Ispart smallint (6) attributes
Corank smallint (6) browsing permission
Tempindex varchar (60) cover template
Templist varchar (60) list template
Temparticle varchar (60) document template
Tempone varchar (60) separate page template
Namerule varchar (50) naming rules for articles
Namerule2 varchar (50) list naming rules
Modname varchar (30) Template name
Description varchar (200)
Keywords varchar (100) keywords
Moresite smallint (6) multi-site support
Siterefer smallint (6) multi-site root directory attribute
Sitepath varchar (60) root directory of multiple sites
Siteurl varchar (60) domain names bound to multiple sites
Ishidden smallint (6) hidden columns

Dede_area: Region table 
Eid int (11) Region No.
Name varchar (20) region name
Rid int (11) number attribute