SQL Naming Conventions

Question

I read this tutorial, but I got confused about this.

What naming style should I be using in this case:

• My table name: QuestionTypes or question_types?
• My table id: QuestionTypeID or QuestionType_ID, question_type_id?

I know when MySQL workbench create .sql file, QuestionType_ID will be converted into questiontype_id, so should I be using this style: QuestionType?

Thank you very much.

Answer 1

If you want to follow that specific convention, your table would be named question_types, and the field question_type_id.

I don't follow that convention, so I would name the table QuestionType and the field QuestionTypeId.