ASP.NET 기초 게시판/ExcelBoard
ExcelBoard_ 테이블
이빛나리
2011. 3. 29. 15:08
게시판테이블
create table ExcelBoard
(
idx int PRIMARY KEY,
eref int Foreign Key references ExcelBoard(idx),
oID char(5) Foreign Key references OrganSeller(oID),
eanswer bit default(0),
edate smalldatetime default(getdate()),
econtent nvarchar(2000),
esession int,
estate bit default(0),
evisit int default(0),
efile varchar(25),
etitle nvarchar(100)
)
댓글테이블
create table ExcelBoardComment
(
idx int PRIMARY KEY,
eref int Foreign Key references ExcelBoard(idx),
oID char(5) Foreign Key references OrganSeller(oID),
edate smalldatetime default(getdate()),
ecomment nvarchar(500)
)