DedeCMS database structure field description - brief description

dede_addonarticle　Additional article table

aid int(11) Article number
typeid int(11) Category column number
body mediumtext Article content
dede_addonflash Additional Flash table
aid int(11) FLASH number
typeid int(11) ) Category column number
filesize varchar(10) File size
playtime varchar(10) Play time
flashtype varchar(10) Work type
flashrank smallint(6) Work level
width smallint(6) Video width
height smallint(6) Video height
flashurl varchar(80) FLASH address


dede_addonimages Additional album table

aid int(11) Album number
typeid int(11) Category column number
pagestyle smallint(6) Expression method ( 1 Single page display 2 Multi-page display 3 Multi-row and multi-column display)
maxwidth smallint(6) Large picture limit width
imgurls text Picture collection content (label storage)
row smallint(6) Multi-column parameters (rows)
col smallint(6) Multi-column parameter (column)
isrm smallint(6) Whether to download remote pictures
ddmaxwidth smallint(6) Small picture width limit


dede_addonsoft additional software table

aid int(11) Software number
typeid int(11) Classification column number
filetype varchar(10) File type
language varchar(10) Interface language
softtype varchar(10) Software type
accredit varchar(10) Authorization method
os varchar(30) Run Environment
softrank int(11) Software level
officialUrl varchar(30) Official website
officialDemo varchar(50) Program demonstration address
softsize varchar(10) Software size
softlinks text Software download link list
introduce text Software introduction


dede_addonspec Additional topic table

aid int(11) Topic number
typeid int(11) Classification column number
note text Topic content (only stores tag code)


dede_admin Administrator information table

ID int(10) Automatic number
usertype int(10) User type
userid varchar(30) User login ID
pwd varchar(50) User password
uname varchar(20) User pen name
tname varchar(30) Real name
email varchar(30) Email address
typeid int(11) Responsible channel (0 means all)
logintime datetime Login time
loginip varchar(20) Login IP


dede_admintype System user group management table

rank smallint( 6) Group level number
typename varchar(30) Group name
system smallint(6) Whether it is the system default group
purviews text permission list


dede_arcatt document custom attribute table
att smallint(6) number
attname varchar(30) Attribute name


dede_archives Article table

ID int(11) Automatic number
typeid int(11) Main column number
typeid2 int(11) Sub-column number
sortrank int( 11) Article sorting (top method)
scommend smallint(6) Recommended or not
ismake smallint(6) Whether to generate static
channel int(11) Article model
arcrank smallint(6) Reading permission
click int(11) Number of clicks
money smallint(6) consumption points
title varchar(80) title
shorttitle varchar(36) abbreviated title
color varchar(10) title color
writer varchar(30) author
source varchar(50) source
litpic varchar(100) ) Thumbnail
pubdate int(11) Entry time
senddate int(11) Publishing time
arcatt smallint(6) Custom attribute (att)
adminID int(11) Publishing administrator ID
memberID int(11) Publishing member ID
description varchar(250) Summary
keywords varchar(60) Keywords
templet varchar(60) Document template
lastpost int(11) Last comment time
postnum int(11) Number of comments
redirecturl varchar(150) Jump URL
mtype int(11) User-defined classification
userip varchar(20) User IP
locklikeid smallint(6) Whether to lock related articles
likeid varchar(240) Related article ID


dede_arcrank Reading permission table

ID int(10) automatic number
rank smallint(10) authority 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 numbering)
reID int(10) Parent column number
topID int(10)
sortrank smallint(6) Sorting number
typename varchar(30) Column name
typedir varchar(100) Column directory
isdefault smallint(6) Column list options (1 link to the default page 0 link to the first page of the list -1 use dynamic page)
defaultname varchar(20) The name of the default page
issend smallint(6) Whether to support submission
channeltype smallint( 6) Channel type
maxpage int(11) Reserved
ispart smallint(6) Column attribute
corank smallint(6) Browse permission
tempindex varchar(60) Cover template
templist varchar(60) List template
temparticle varchar(60) Article Template
tempone varchar(60) Single page template
namerule varchar(50) Article naming rule
namerule2 varchar(50) List naming rule
modname varchar(30) Template name
description varchar(200) Column introduction
keywords varchar(100) Keywords
moresite smallint(6) Multi-site support
siterefer smallint(6) Multi-site site root directory attribute
sitepath varchar(60) Multi-site site root directory
siteurl varchar(60) Multi-site binding domain name
ishidden smallint(6 ) Whether to hide the column



dede_area area table

eid int(11) area number
name varchar(20) area name
rid int(11) number attribute

Dreamweaver dedeCMS database structure field description, please add additional explanation if it is not complete! For reference only