?? 建約束.sql
字號(hào):
use bbs
go
--用戶表約束
alter table userInfo
add
constraint PK_uId primary key (uId),
constraint UQ_uName unique(uName),
constraint DF_uType default(0) for uType,
constraint DF_uRegTime default(getdate()) for uRegTime
go
--版塊表約束
alter table sectionInfo
add
constraint PK_sId primary key(sId),
constraint DF_sMasterId default(0) for sMasterId,
constraint DF_sTopicCount default(0) for sTopicCount,
constraint DF_sParentId default(0) for sParentId
go
--發(fā)帖表
alter table topicInfo
add
constraint PK_tId primary key(tId),
constraint FK_tSId foreign key(tSId) references sectionInfo(sId),
constraint FK_tUId foreign key(tUId) references userInfo(uId),
constraint DF_tReplyCount default(0) for tReplyCount,
constraint DF_tClickCount default(0) for tClickCount,
constraint DF_tPublishTime default(getDate()) for tPublishTime
go
--跟帖表
alter table replyInfo
add
constraint PK_rId primary key(rId),
constraint FK_rTId foreign key(rTId) references topicInfo(tId),
constraint FK_rSId foreign key(rSId) references sectionInfo(sId),
constraint FK_rUId foreign key(rUId) references userInfo(uId),
constraint DF_rPublishTime default(getdate()) for rPublishTime
go
--短信表
alter table messageInfo
add
constraint PK_mId primary key(mId),
constraint FK_mSendUnameId foreign key(mSendUnameId) references userInfo(uId),
constraint FK_mReceiveUnameId foreign key(mReceiveUnameId) references userInfo(uId),
constraint DF_mPostTime default(getdate()) for mPostTime,
constraint DF_mReadSign default(false) for mReadSign
go
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -