Database table structure for storing SSO information for FB or Google+ <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>