title: a user bookmark system database design
body: <p>my user need to bookmark the articles, videos, pictures posted by the others.</p>
  
  <p>now I have a user table, an article table, a video table.</p>
  
  <p>and I come up with two way to store the bookmark data..</p>
  
  <p>first, I can create three one-to-many table.</p>
  
  <p><a href="https://i.stack.imgur.com/bsrBh.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bsrBh.png" alt="enter image description here"></a></p>
  
  <p>the second way is only create a table and add a category column on it..</p>
  
  <p><a href="https://i.stack.imgur.com/bfqcq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bfqcq.png" alt="enter image description here"></a></p>
  
  <p>with the first approach, I can store foreign keys to associate with the articles and video table. witch is easier for the orm system</p>
  
  <p>and the second way only need a table, but can't store the relationship..</p>
  
  <p>so. which one should I choose,or Is better???</p>
  
  <p>the third way is something like.</p>
  
  <p><a href="https://i.stack.imgur.com/lXljz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lXljz.png" alt="enter image description here"></a></p>