Table and Column naming conventions violated in many examples about sqlstyle.guide HOT 3 CLOSED

Hi Alex,

I think the only one I've seen is b.engines. This is a column name and should be a singular - probably engine_tally. Possibly also pens_in_drawer although less so.

All the others are table names and should be plural so I am unsure of the difficulty with those. Are you suggesting that there are better collective terms for office_locations, riders, albums and champions that could be used instead?

Cheers,
Simon

from sqlstyle.guide.

@amopremcak does this answer your question?

from sqlstyle.guide.

Yes, that answers my question. I missed the 'collective terms' portion of that sentence and read only the singular part. There is a similar style guideline to yours online that uses this convention instead, I think I just got mixed up. Nice document though, I found it really helpful.

from sqlstyle.guide.