title: database design for sharing post from another user
body: <p>I'm developing a social network </p>
  
  <p>my problem is how can i design  sharing post in the database</p>
  
  <p>what i have now </p>
  
  <pre><code>user table 
  </code></pre>
  
  <p>and</p>
  
  <p><code>post table</code> has a foreign key to <code>user id</code> </p>
  
  <p>and </p>
  
  <p><code>like table</code> contain two foreign key <code>user id</code> vs <code>post id</code> </p>
  
  <p>what i'm looking for is to have  any small solution for sharing  post from a user and connect this solution with like table because  if some one share a post he will get new like on it </p>
  
  <p>I dont know if creating  a new <code>share table</code> is good but what about like now  ?</p>
  
  <p>any idea please ? </p>