ExcelBoard_ 테이블

 

게시판테이블

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)

)