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
Last activity: Dec 27, 2020, 04:25 PM