DedeCMS database structure field description-Brief description, dedecms

DedeCMS database structure field description-Brief description, dedecms
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 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 area table

Eid int (11) region no.
Name varchar (20) region name
Rid int (11) number attribute description of the structure field of the dedeCMS database. If not all fields are found, add a description! For reference only