If you want users of your site to be able to log in using Facebook Connect, a Google account, etc., how do you create your database so that they are all integrated?
I suggest using an account table to store your local account data, which will then be associated with the AthenticationMethods table or credential table, which will store the associated external authentication data. This allows your site and all its complexity to be associated with Accounts and the login process, to perfectly abstract from the various forms of authentication that you might want to support. Given that each authentication method can have different levels of complexity, I suggest looking at the various APIs and cross-referencing them to find common similarities. More importantly, you want to find where they are different, so that the credential table can handle the different bits of data that each API may require. Remember to enable OpenID!
. "externalSystemId" (TINYINT), - "externalId" (DOUBLE). , externalSystemId, .. EXTERNAL_SYSTEM_FACEBOOK = 1, EXTERNAL_SYSTEM_OPENID = 2 .. - , , .
User , , -, , externalSystemId.
, , , , , .
Are you sure you want to save other information than "login": "password"? I would recommend that you have an enumeration to save the login system from which the user comes from.
Source: https://habr.com/ru/post/1711138/More articles:Auto-filling Intellisense crashes VC ++ in Visual Studio 2005 SP1 - c ++C ++ / CLI switch to String - stringИзменение свойства MaxArrayLength объекта XmlDictionaryReaderQuotas, используемого при создании XML-ридера - c#The list is designed as a function integer by length - listJustification for using non-portable code - designHow do I authenticate users in the Dynamic Data administration area on the ASP.NET MVC website? - asp.net-mvcHow to configure Nginx as a caching reverse proxy? - cachinghttps://translate.googleusercontent.com/translate_c?depth=1&pto=aue&rurl=translate.google.com&sl=ru&sp=nmt4&tl=en&u=https://fooobar.com/questions/1711141/sending-messages-to-a-remote-jms-topic&usg=ALkJrhhA1rVkNvLuN6djJfBIgTlQFo_5NwCompiling my own PHP extension on Windows with Visual Studio 2008 - windowsHTML layout, ASP.Net, browser difference ..... there should be a better way - htmlAll Articles