Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail From: "Tony Johansson" Newsgroups: comp.databases.ms-sqlserver Subject: Creating a web log Date: Wed, 4 Jun 2014 23:47:28 +0200 Organization: A noiseless patient Spider Lines: 13 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit Injection-Date: Wed, 4 Jun 2014 21:47:31 +0000 (UTC) Injection-Info: mx05.eternal-september.org; posting-host="8fdc2b5af81c338deb7045fc6c39b0e2"; logging-data="28075"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18emPZxkWKt8Mu7GP0v/uOc" X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18463 X-Newsreader: Microsoft Windows Mail 6.0.6002.18197 Cancel-Lock: sha1:8NbPpUmb8Q8zPp4FObiepr/xo+M= X-Priority: 3 X-MSMail-Priority: Normal Xref: csiph.com comp.databases.ms-sqlserver:1762 If I want to create a web log that user can comment my post I have this kind of design. One user can make many Post and one post can have many comment and each comment can have many replies(post) you have a connection table called Answer in between. I have only find one sensible field to add to the Answer table and that is a DateTime. What can I add more to the Answer table. //Tony