title: Database table structure for storing SSO information for FB or Google+
body: <p>I have a web application that I would like to add single sign on capability using user's Facebook or Google+/Google App account. </p>
  
  <p>I have a <code>USERS</code> table that stores users login information.  All users are required to have a record in this table no matter if they signed up using FB or Google+.</p>
  
  <p>I am trying to figure out the information that I need to store in the database in order to link <code>USERS</code> table records to FB or Google information.  </p>
  
  <p>Facebook <a href="https://developers.facebook.com/docs/facebook-login/manually-build-a-login-flow#token" rel="nofollow">documentation states</a>:</p>
  
  <blockquote>
    <p>the app should store the token in a database along with the <code>user_id</code>
    to identify it.</p>
  </blockquote>
  
  <p>So should I create a table called <code>SSO_LOOKUP</code> with following columns:</p>
  
  <ul>
  <li>USER_ID // user's id that links to my <code>USER</code> table</li>
  <li>PROVIDER_ID // user's FB or Google account id</li>
  <li>PROVIDER_TYPE // indicates if it is Google, FB, Twitter, etc. </li>
  <li>ACCESS_TOKEN</li>
  </ul>