Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 117
  • Last Modified:

how to identify first time user and a registered user

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.

9-26-2014-8-46-31-AM.jpg
0
-Dman100-
Asked:
-Dman100-
1 Solution
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
How can a user log in if isn't registered?
0
 
-Dman100-Author Commented:
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?
0
 
Scott PletcherSenior DBACommented:
I would use a separate table for that flag.  To me it's possible there might be new apps developed that would fall under the SSO umbrella, and you'd need to distinguish registration for each app separately.
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now