论坛数据库设计文档

1、数据库表设计一共7张表（暂定7张可能后期可能会添加）1. 论坛用户表2. 类別表3. 发帖表4. 评论表5. 回复表6. 公告表7. 友情链接注*不是我想用varchar使用integer类型时总是报错l.bbsuser （论坛用户）表字段名屮文名类型能否为空备注utd用户idint否主键、自定增长uphone电话号码int否唯一值uname用户昵称varchar否唯一值默认随机值upassword密码char否uemail电子邮件varchar否uuniquc个性签名varcharubirthady生日varcharusex性别varchar否默认男uhead用户头像varcharusate

2、ment用户备注varcharuregdate注册日期varchar否ustate用户状态varcharurank用户等级varcharupoint用户积分varcharurealname真实姓名varcharuldonti ty身份证号varchar唯一2. bbsclass （类别表）字段名中文名类型能否为空备注cid分类idint否主键自定增长cname类别名称varchar否cpid父类to号int否cpath分类路径varchar3. bbstopic （发贴表）字段名中文名类型能否为空备注tid发贴表idint否主键自定增长tcid类别int否外键（引用类别表的cid）tuid发贴

3、人int否外键（引用用户表的uid）tfavour点赞数inttreplycount评论数intttopic标题varchar否tcontents正文varchar否ttime发贴时间datetime否tciickcoount点击率inttflag状态int新发文章，精华文章4.bbsreview评论衣字段名中文名类型能否为空备注rtd评论表idint否主键自定增长rtid所属帖子int口外键（引用发帖表的tid）tu1d评论人int木 口外键（引用用户表的uid）remotion评论表情varcharrcontents评论内容varchar口rtime评论时间datetime丕 nrfavo

4、ur点赞数 int5. bbsback冋复表字段名中文名类型能否为空备注bid回复表idint否主键自定增长brtd所属评论int否外键（引用评论表的rid）tuid评论人int否外键（引用用户表的uid）remotion评论表情varcharrcontents评论内容varchar否rtime评论时间datetime否6. bbsplacard (公告表)字段名中文名类型能否为空备注ptd公告idint否主键自定增长ptitle标题varchar否ptext公告内容varcharppromulgator发布人varchar否ptime发布时间datetime否7. bbslink （友情链接

5、表）字段名中文名类型能否为空备注lididint否主键自定增长llogologoint否lname链接名称int否laddress链接地址varchar否lstate状态tinyint否默认为禁用lendtime截止时间datetime否-table structure for bbsuser'drop table if exists 'bbsuser'create table 'bbsuser' ('uld' int(10) unsigned not null autojncremen7；'uphone' int(ll)

6、 not null,'uname' varchar(20) collate utf8_unicode_ci not null, 'upassword' varchar(20) collate utf8_unicode_ci not null, 'uemail' varchar(30) collate utf8_unicode_ci not null, 'usign' text collate utf8_unicode_ci not null,'ubrithday' varchar(20) collate utf8_

7、unicode_ci not null, 'usex' varchar(2) collate utf8_unicode_ci not null,'uhead' varchar(255) collate utf8_unicode_ci not null, 'ustatement' varchar(20) collate utf8_unicode_ci not null,ustate' varchar(2) collate utf8_unicode_ci not null, 'uregdate' char(255) colla

8、te utf8_unicode_ci not null, 'urank' char(2) collate utf8_unicode_ci not null, 'uroint' char(255) collate utf8_unicode_ci not null, 'urealname' varchar(20) collate utf8_unicode_ci not null, 'ulnumber' int(18) not null,primary key ('uld')engine=mylsam default c

9、harset=utf8 collate=utf8_unicode_ci;-records of bbsuser-table structure for 'bbsbackdrop table if exists 'bbsback'create table 'bbsback' ('bid' int(10) unsigned not null autojncrement,'brid' int(ll) not null,'tuid'int(ll) not null,'bemotion' varcha

10、r(255) collate utf8_unicode_ci not null,bcontents' varchar(255) collate utf8_unicode_ci not null,'btime' int(ll) not null,primary key ('bid')engine=mylsam default charset=utf8 collate=utf8_unicode_ci;-records of bbsback-table structure for bbsclassdrop table if exists bbsclass

11、9;create table 'bbsclass' ('cid' int(10) unsigned not null autojncrement,'cname' varchar(20) collate utf8_unicode_ci not null,'cpid' int(ll) not null,'cpath' varchar(255) collate utf8_unicode_ci not null,primary key ('cid')engine=mylsam default charset

12、=utf8 collate=utf8_unicode_ci;-records of bbsclass一 table structure for 'bbslink'drop table if exists 'bbslink'create table 'bbslink' ('lid' int(10) unsigned not null autojncrement,'logo' varchar(255) collate utf8_unicode_ci not null,'lname'varchar(255

13、) collate utf8_unicode_ci not null,'laddress' varchar(255) collate utf8_unicode_ci not null, 'lendtime' int(ll) not null,primary key ('lid')engine=mylsam default charset=utf8 collate=utf8_unicode_ci;-records of bbslink-table structure for 'bbsplacard'drop table if exi

14、sts 'bbsplacard'create table 'bbsplacard' ('pid' int(10) unsigned not null autojncrement'ptitle' varchar(20) collate utf8_unicode_ci not null,'ptext' text collate utf8_unicode_ci not null,'ppromulgator' varchar(255) collate utf8_unicode_ci not null, &#

15、39;ptime' int(ll) not null,primary key ('pid')engine二mylsam default charset=utf8 collate=utf8_unicode_ci;-records of bbsplacard-table structure for 'bbsreview'drop table if exists 'bbsreview'create table 'bbsreview' ('rid' int(10) unsigned not null autoncr

16、 em ent；'rtid' int(ll) not null,'tuid' varchar(20) collate utf8_unicode_ci not null, 'rcontents' varchar(255) collate utf8_unicode_ci not null, 'remotion' varchar(255) collate utf8_unicode_ci not null, 'rfavour' varchar(255) collate utf8_unicode_ci not null, r

17、time' varchar(255) collate utf8_unicode_ci not null, primary key ('rid')engine=mylsam default charset=utf8 collate=utf8_unicode_ci;一 records of bbsreview-table structure for 'bbstopic'drop table if exists 'bbstopic'create table 'bbstopic' ('tid' int(10) un

18、signed not null autojncremen7；'tcid' varchar(255) collate utf8_unicode_ci not null,'tuid' varchar(20) collate utf8_unicode_ci not null,'tfavour' varchar(20) collate utf8_unicode_ci not null, 'trepluconut' varchar(20) collate utf8_unicode_ci not null, 'ttopic' varchar(255) collate utf8_unicode_ci not null, 'tcontents' text