```ruby
primary_key :id
String :name, :text=>true
String :nickname, :text => true
String :twitter_user, :null => true
String :facebook_user, :null => true
```

Store the uid of each provider in twitter_user and facebook_user. The first used will define name and nickname. I don't know if you have plans to manage connections from user settings.