DB structure

Hi guys,

Say I would like to track hits on products or articles
Would you create an extra table to store these hits (with articleID as foreign key), or just put them in the article table itself?

Something tells me the last option makes most sense,
since an article can have only 1 sort of hits and in that way its a one to one relationship. Hmm typing this I am almost certain this is correct anyone wanna agree or disagree?

you're fine for articles

where are the produict hits going to go?

Hi r937

I should have been more precise. for article and products I use the same structure. So the hits are bound to 1 product. I assume an extra table is not required than since its a 1-to-1 relation.

For instance each time someone views a product it's hitrating increases.