I create tables like so:

```
CREATE TABLE account (
  id serial PRIMARY KEY,
  username varchar (32),
  email varchar (255)
)

```

A `SELECT` query with a `JOIN` would then look like this (I have to use periods here, because the id column exists in both tables):

```
SELECT account.id, name 
FROM account 
JOIN activity ON activity.account_id = account.id

```

I have seen others create tables with the table name in the column name for the id included (separated by an underscore):

```
CREATE TABLE account (
  account_id serial PRIMARY KEY,
  username varchar (32),
  email varchar (255)
)

```

The query would then look like this:

```
SELECT account_id, name 
FROM account 
JOIN activity ON activity.account_id = account.account_id

```

Are there any benefits of using the underscore variant? Is there a performance difference? Is there any best practice about this subject?