How to design a database for friends and messaging

So I want to add friends and messaging to my rails application and I now how to do it in rails but my question is how is it done in SQL. Is it done using a relationships table like:

relationships: id usr1 usr2

or is each user given their own friends table?

Is it possible to give each user their own table in SQL?