简单课程设计{论坛}

create table Users ( UserId int primary key, UserName varchar(20) not null, UserPwd varchar(50), UserEmail varchar(200), UserPic varchar(200), UserQx int, UserOnline int, UserIp varchar(50), UserLoginDate datetime, IsAdmin int ) create table BlockBig ( bigId int primary key, bigName varchar(50), bigDescription varchar(200), bigAdmin varchar(200), bigAddtime datetime ) create table BlockSmall ( small_Id int primary key, small_Name varchar(50), small_Desciption varchar(200), small_ImgUrl varchar(500), small_Admin int, small_BigId int, small_PostCount int, small_PostBackCount int, ) foreign key (small_BigId)references BlockBig(bigId) create table Message ( message_id int primary key, message_title varchar(50), message_content varchar(50), message_sender int, message_toUser int, message_IsRead int, message_Adddate datetime ) create table Popedom ( popedom_id int primary key, popedom_Name varchar(50) ) create table Post ( post_id int primary key, post_Title varchar(200), post_content varchar(5000), post_SendTime datetime, post_SmallId int, post_TypeId int, post_BrowseCount int, post_BackCount int ) create table PostBack ( Postback_Id int , Postback_content varchar(5000), Postback_Sender int, Postback_SendTime dateTime, Postback__PostId int ) create table PostType ( PostType_Id int primary key, PostType_Name varchar(50), PostType_BlockSmallId int, PostType_Adddate datetime )