database design for simple comment I have a following given scenario. 
A user can have zero or more item. 
A user can comment on the item. (Just simple comment listing with name of people who comment, no need hierarchical structure for replying comment)

And i come out database structure like this. Not sure if this is a good database design
You design is basic and cover 

1 user -&gt; many items
1 item -&gt; many comments
1 user -&gt; many comments


The question is would you like the user to be able to comment on the same item multiple of times?
if yes, you do have a good design else we would need to work on it.