数据库表创建 [英] Database table creation

问题描述

我正在为移动应用创建数据库。

用户可以通过用户注册登录，也可以通过社交媒体登录。

有人可以建议我如何创建数据库用于社交媒体登录和用户注册登录。



最初我创建了一个用户注册表，其中包含用户名和用户密码等所有用户详细信息，现在我们希望用户登录社交媒体。因此请求创建表的任何建议。

I am creating a database for Mobile App.
User can Login through user registration or he can login through social media.
Can someone suggest how can i create database for social media login and user registration login.

Initially i had created a table for user registration with all user details including Username and userpassword and now we want the user login through social media. Hence requesting any suggestion for table creation.

推荐答案

如果我理解你，你想要启用用户两种验证过程：1）通过自定义登录窗口，和2）通过社交媒体（无论它意味着什么）。



创建自定义身份验证方法非常明显。您可以在Google上找到大量样本。第二种方法有点难以实现，因为那些社交媒体必须提供一种方式来返回有关验证过程结果的信息。



我建议读这个：

使用ASP.NET Web API的外部身份验证服务（C＃） [ ^ ]

通过社交网络进行OWIN OAuth2身份验证 [ ^ ]



您可能对 SSO（单点登录）方法感兴趣 [ ^ ]。

单点登录（SSO）的基础知识 [ ^ ]



结论：没有人能够向您展示数据库的确切结构。这取决于很多因素......

If i understand you well, you want to enable user two ways of verification process: 1) via custom logon window, and 2) via social media (whatever it means).

Creating custom authentication method is quite obvious. You can find tons of samples on Google. Second method is bit hard to implement, because those social media must provide a way to return information about result of verification process.

I do recommend to read this:
External Authentication Services with ASP.NET Web API (C#)[^]
OWIN OAuth2 authentication via Social networks[^]

You might be interested in SSO (Single Sign On) method[^].
Basics of Single Sign on (SSO)[^]

Conclusion: No one can show you exact structure of database. It depends on many factors...

这篇关于数据库表创建的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！