I too follow a similar naming convention for database tables.
And a few posts ago, @ben also suggested to prefix foreign columns with table name and it has made a great improvement while using these fields in Wappler or otherwise.
I knowingly avoid underscores in naming all things. Its just takes me a lot of time to press shift +_ rather that shift+alphabet when using camel case. And, for case-insensitive queries I can even skip writing column names in camel case.
And, I have learned my lesson from the days of using just ID for PK, and never repeat that mistake.