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
-Dman100-Software ConsultantAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
How can a user log in if isn't registered?
0
-Dman100-Software ConsultantAuthor 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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.