DEDECMS Database Fields Detailed description

Dede_addonarticle Additional Articles 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

Introuce Text Software Introduction

Dede_addonspec Additional feature Sheet

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 Reading Permission 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_sgpage single page

DEDECMS Database Fields Detailed description