Oauth - Facebook/ Twitter / Foursquare

I am creating a way people can connect their Fb, Twitter and FS account to the account they create on my application. I wanna create a single table where i can store all the required stuff..

User(id, username, password, email)

Oauth (id, user_id, oauth_provider, ....... )

As for my Understanding

Facebook needs facebook id

Twitter needs id, token, secret

Foursquare requires email and consumer id.

Just wanted to confirm i am doing 开发者_运维问答it right.. in constructing the Oauth Table.

I personally create a field named "setting_parameter" for the requirement's value because all of these API need different things. As you've said Facebook need App ID (plus Token), Twitter needs Consumer Key and consumer Secret..

All of this value I merge them all into one string with JSON-format. I don't put them each into the field because I think there won't be necessary for me to query this table for operations other than get their value. Beside, I need to implemented other APIs in the future. That's why I can't create special field, because I won't know what kind of value the new API will going to need next time. That's why I prefer to squished them into one string field.

The table of mine is like this
Oauth(id, name, setting_parameter, description,...)