What values to store in the database to uniquely identify an authenticated user?

[Behrang Saeedzadeh]

Hi,

Basically I want to know what values should I use for "provider ID" and a "unique user id" to store an authenticated user in the database?

A possible schema might look like this:

provider_id varchar(255) NOT NULL

user_id varchar(255) NOT NULL

first_name varchar(255)

last_name varchar(255)

email varchar(255)

For provider ID, I think I can use accessGrant.getProviderId() or profile.getProviderID().

However I am not sure how to retrieve a unique ID for the user for the given provider. Should I use Profile.getValidatedId()?