DEDECMS Column----Data collection

Main Data structure table

dede_addonarticle: Additional article table
aid Int (11) article number
typeid Int (11) Category column number
Body Mediumtext article content
Dede_addonflash additional Flash Tables
aid Int (one) Flash number
typeid Int (11) Category column number
FileSize varchar (10) File size
Playtime varchar (10) Playback duration
Flashtype varchar (10) Type of work
Flashrank smallint (6) Work level
Width smallint (6) Film width
Height smallint (6) Film Heights
Flashurl varchar Flash Address

dede_addonimages: Additional Atlas table
aid Int (11) Atlas Number
typeid Int (11) Category column number
Pagestyle smallint (6) expression mode (1 single page display 2 multi-page display 3 multi-row multi-column display)
MaxWidth smallint (6) Big picture limit width
Imgurls Text Picture set contents (Label storage)
Row smallint (6) Multi-column parameter (ROW)
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 tables
aid Int (11) Software number
typeid Int (11) Category 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) Operating environment
Softrank Int (11) software level
Officialurl varchar (30) Official website
Officialdemo varchar (50) Program demo address
Softsize varchar (10) Software size
softlinks text software download link list
Introduce text software introduction

Dede_addonspec: Additional feature sheets
aid Int (11) Topic number
typeid Int (11) Category column number
Note Text Featured content (tag code only)

dede_admin: Administrator Information Sheet
ID int (10) Auto-numbering
usertype Int (10) User type
UserID varchar (30) User login ID
PWD varchar (50) User password
uname varchar (20) User pseudonym
Tname varchar (30) real name
Email varchar (30) e-mail
typeid Int (11) is responsible for 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) is the default group
Purviews Text Permission list

Dede_arcatt: Document custom property sheet
Att smallint (6) Number
AttName varchar (30) Property name
Dede_archives Article table
ID int (11) Auto-numbering
typeid Int (11) belongs to main section number
Typeid2 Int (11) belongs to the sub-column number
Sortrank Int (11) Article sort (sticky method)
Iscommend smallint (6) Recommended
Ismake smallint (6) whether to generate static
Channel Int (11) article-owned model
Arcrank smallint (6) Read permissions
click Int (11) clicks
Money smallint (6) Consumption points
Title varchar (80) header
Shorttitle varchar (36) abbreviated title
Color varchar (10) Title Colors
Writer varchar (30) Author
SOURCE varchar (50) sources
Litpic varchar (100) Thumbnail
pubdate Int (11) Input time
senddate Int (11) Release time
Arcatt smallint (6) custom attribute (ATT)
Adminid Int (11) Release Administrator ID
MemberID Int (11) Release 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 reviews
RedirectURL varchar (150) Jump URL
Mtype Int (11) User defined Category
Userip varchar (20) User IP
Locklikeid smallint (6) Whether related articles are locked
Likeid varchar (240) related article ID

dede_arcrank: Read Permissions table
ID int (10) Auto-numbering
Rank smallint (10) Permission level
MemberName varchar (20) Rank name
Adminrank smallint (10) management level
Money Int (11) Consumption points

dede_arctype: Column Management table
ID int (10) column number (auto-numbering)
ReID Int (10) Parent column number
Topid Int (10)
Sortrank smallint (6) Sort number
TypeName varchar (30) Column name
Typedir varchar (100) Column catalogue
IsDefault smallint (6) Column list options (1 link to default page 0 link to list first page-1 use dynamic page)
DefaultName varchar (20) name of the default page
Issend smallint (6) whether the submission is supported
Channeltype smallint (6) channel type
maxpage Int (11) reserved
Ispart smallint (6) Column Properties
Corank smallint (6) Browse permissions
Tempindex varchar (60) Cover Template
Templist varchar (60) list template
Temparticle varchar (60) Article template
Tempone varchar (60) separate page template
Namerule varchar (50) Article naming conventions
Namerule2 varchar (50) List naming rules
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 Properties
SitePath varchar (60) Multi-site site root directory
SiteURL varchar (60) Multi-site bound domain name
Ishidden smallint (6) Whether to hide the column

Dede_area: Regional table
Eid Int (11) Region number
Name varchar (20) region names
RID Int (11) Number attribute

Dedecms column----data collection