Forum attributes.

[tiffany]

Hi, i wanna get a little help on some database management. I was doing a forum use case. And i had come out of some of the attributes. There will be a FirstId in a thread table and FirstID in a reply table. But If the database design like this, it will have duplicate primary key in thread table as well as reply table.

So i'm thinking of, if we can compare by date and time to find the first message under a particular topic?


Thank you!

Tiffany