Sample Header Ad - 728x90

PostgreSQL naming conventions

7 votes
2 answers
23150 views
Maybe double post but I could not find any answer here. I saw couple of posts how to name my tables and I understood that (semi-officially) it should contain lower cases, should be underscored and singular (f.e. my_table) My question arose when I had to do the following. I have an app where I have user, platform and user_info, where platform is what the user is working on (f.e. MAC, PC, LINUX). If I need to create junction table between user and platform, how do I name it in order the next person browsing the schema to understand that user and platform have a junction table named user_platform, but to not be confused when he sees the table user_info? BR
Asked by Pentarex (73 rep)
Aug 17, 2019, 11:56 PM
Last activity: Dec 27, 2020, 04:25 PM