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 |
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
 Posted - 2005-05-06 : 13:46:44
|
| Hi,It's been awhile since I've needed to design something, and I'm wondering if I could get some help. I'm designing a site that shows videos and pictures to start and possibly audio as well maybe other things to add later.Each one of these different media types could possibly have different properties, however each has to have the ability to be commented and rated on. For this reason I am thinking I need some sort of autoNumber column for all media types.This would be an example of how I would do the tables below. Am I making any sense? I can't seem to figure out how to wrap up the final steps. Thanks for any help.. mike123tblVideosvideoID int videoTitle varchar(50)videoDescription varchar(50)metaTitle varchar(50)metaDescription varchar(50)metaKeywords varchar(50)DatePosted dateTimetblPicturespicID int picTitle varchar(50)picDescription varchar(50)DatePosted dateTimeand here the comments table.tblCommentscommentID intcommentFromID intitemID intcomment varchar(50)datePosted dateTimeWould I need something like this ? tblItemsitemIDtypeIDtblTypestypeIDtypeDescription |
|
|
|
|
|
help with db design