Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
harish_babu
Starting Member
19 Posts |
 Posted - 2001-08-08 : 06:19:35
|
| Hi, Below are the two tables designed for a discussion forum taken from a site.Is it a good idea to seperate the parent-child relation into a seperate table or can we add the parent_messageID to the message table. Message messageID int not null, threadID int not null subject varchar(255) null, userID int not null, body text null, modifiedDate char(15) not null, creationDate char(15) not null, approved int not null,MessageTree( message_parentID int not null, message_childID int not null,) |
|
|
|
|
|
table design