DEDECMS 5.7 数据库 表说明.pdf

《DEDECMS 5.7 数据库 表说明.pdf》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。

1、Dedecms5.7数据库表说明字段类型整理属性Null默认注释Idmediumint(8)UNSIGNED是0文档IDtypeidsmallint(8)UNSIGNED是0栏目IDsortrankint(10)UNSIGNED是0时间排序flagset('c','h','p','utf8_general是null自定义属性值f','s','j','a','b')_ciismakesmallint(6)是0是否审核channelsmallint(6)是1所属模型IDarcranksmallint(6)是0阅读权限dede_archivesclickmediumint(8UNSIGNED是0点

2、击数文档主表)moneysmallint(6)是0消费点数titlechar(60)utf8_general是标题_cishorttitlechar(36)utf8_general是简明标题_cicolorchar(7)utf8_general是颜色_ciwriterchar(20)utf8_general是作者_cisourcechar(30)utf8_general是文档来源_cilitpicchar(60)utf8_general是缩略图_cipubdateint(10)UNSIGNED是0时间senddateint(10)UNSIGNED是0时间midmediumint(8UNSIG

3、NED是0会员ID)keywordschar(30)utf8_general是关键词_citempletchar(30)utf8_general是_cilastpostint(10)UNSIGNED是0最后回复scoresmediumint(8UNSIGNED是0阅读权限)goodpostmediumint(8UNSIGNED是0好评)badpostmediumint(8UNSIGNED是0差评)notposttinyint(1)UNSIGNED是0评论选项（1：允许评论）useripchar(15)utf8_general是IP_ciredirecturlvarchar(255utf8_g

4、eneral是跳转地址)_cidescriptionvarchar(255utf8_general是摘要)_ci字段类型整理属性Null默认额外dede_addonarticleaidmediuminUNSIGN否0文档IDt(8)ED文章附加表typeidsmallint(5UNSIGNED否0栏目ID)bodymediumteutf8_gene是null内容xtral_ci字段类型整理属性Null默认额外aidmediumint(UNSIGNED否0文档ID8)dede_addonimagestypeidsmallint(5)UNSIGNED否0栏目ID图片附加表pagestylesma

5、llint(6)否1表现方式（多页多图显示、多页单图显示、多行多列显示）maxwidthsmallint(6)否600图片宽度限制imgurlstextutf8_gene是null图片内容ral_ci（{dede:pagestyle…）rowsmallint(6)否0多列式参数（行）colsmallint(6)否0多列式参数（列）isrmsmallint(6)否0特殊选项（下载远程图片、从ZIP压缩包中解压图片、网上复制图片）ddmaxwidtsmallint(6)否200缩略图宽h度限制pagepicnumsmallint(6)否12每页图片数（单页多图显示需要设置此参数）字段类型整理属性

6、Null默认额外aidmediumint(UNSIGNED否文档id08)typeidsmallint(5)UNSIGNED否栏目id0bodymediumtextutf8_genera是商品内容nulll_cipricefloat否价格0dede_addonshoptruepricefloat否优惠价0商品附加表brandvarchar(250utf8_genera否品牌)l_ciunitsvarchar(250utf8_genera否单位)l_ci字段类型整理属性Null默认额外aidmediumintUNSIGNED否文档ID0(8)typeidsmallint(5)UNSIGNED否

7、栏目ID0dede_addonsoft软件附加表filetypevarchar(10utf8_genera否文件类型)l_cizip、rarlanguagevarchar(10utf8_genera否软件语言)l_cisofttypevarchar(10utf8_genera否软件类型)l_ci（国产..）accreditvarchar(10utf8_genera否授权方式)l_ci（共享软件..）osvar