<div>
How can a user log in if isn't registered?
</div>


How can a user log in if isn't registered?

<div>
They can login thru single sign-in, but they won't have specific permissions in the application until after they have gone thru the first time registration process. &nbsp;Perhaps using the term register is misleading. &nbsp;Basically, I need to differentiate between a first time user and a user that has gone thru the first-time registration process in the application. &nbsp;Does that help explain?
</div>


They can login thru single sign-in, but they won't have specific permissions in the application until after they have gone thru the first time registration process.  Perhaps using the term register is misleading.  Basically, I need to differentiate between a first time user and a user that has gone thru the first-time registration process in the application.  Does that help explain?

<div>
<div class="content wysiwyg-content">
I'm working on a database design for a credit card processing web application. &nbsp;We are using single sign-on to authenticate users, so the username and password will not be stored in the database schema. &nbsp;What I'm trying to determine right now is when a user logs in if they are a first-time user or if they are a registered user. &nbsp;I have a contact table and I was thinking I could just add a new column to the contact table &quot;registeredUser&quot; that is a bit datatype. &nbsp;But, I'm wondering if this is limiting and if there was a better design choice. &nbsp;Please see the attached database diagram.<br />
<br />
Thanks for any help from any database experts out there.<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2014/09_w39/874535/9-26-2014-8-46-31-AM.jpg" target="_blank" title="9-26-2014-8-46-31-AM.jpg (223 KB)"><img alt="9-26-2014-8-46-31-AM.jpg" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2014/09_w39/800_874535/9-26-2014-8-46-31-AM.jpg" /></a>
</div>
</div>


9-26-2014-8-46-31-AM.jpg

I'm working on a database design for a credit card processing web application.  We are using single sign-on to authenticate users, so the username and password will not be stored in the database schema.  What I'm trying to determine right now is when a user logs in if they are a first-time user or if they are a registered user.  I have a contact table and I was thinking I could just add a new column to the contact table "registeredUser" that is a bit datatype.  But, I'm wondering if this is limiting and if there was a better design choice.  Please see the attached database diagram.

Thanks for any help from any database experts out there.



how to identify first time user and a registered user

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.