Table Naming Convention

[Das Goravani]

When I asked about case for data column names, the overall best approach recommended was for Postgres to use lower case, so I did. 

When it comes to naming tables and column names, the overall best approach laid out by many is what has been presented here already, but to summarize

TableName is tcustomers say
The columns get a prefix like custthenthecolumnname

Benefit is no need to prefix, all your column names are unique