数据库设计
2017-10-26 18:42:15 0 举报
论坛后台数据库设计
作者其他创作
大纲/内容
followerId INT
postId_col INT
adminId INT
post_time DATETIME
email VARCHAR(45)
content VARCHAR(1024)
comment
sex CHAR(6)
authorId INT
userId INT
industry VARCHAR(45)
password CHAR(20)
like_num INT
lastlog_time DATETIME
postId INT
verifyQuestion
comId INT
by_followerId INT
birth DATE
rank INT
sector
id INT
nick_name VARCHAR(45)
secname VARCHAR(45)
title VARCHAR(45)
type VARCHAR(20)
share_num INT
self_content VARCHAR(1024)
userInform
id INT
clickRate VARCHAR(45)
area VARCHAR(45)
oppose_num INT
authorId INT
com_num INT
following
id INT
post_num INT
real_name VARCHAR(30)
username VARCHAR(30)
com_time DATETIME
question VARCHAR(128)
Pb INT
question2 INT
position VARCHAR(45)
com_num INT
footCollect
id INT
id INT
answer VARCHAR(45)
content VARCHAR(2048)
questionId1 INT
post_num VARCHAR(10)
icon VARCHAR(256)
post
postId_print INT
userAccount
id INT
reg_time DATE
secId INT
0 条评论
下一页