I will get involved in a big project and I would like to know which is, in your opinion, the best practice for naming SQL table columns.
Lets say we have a products table. Which of the following naming will you prefer?
- id,
- name,
- description,
- photo,
- price
or
- product_id,
- product_name,
- product_description,
- product_photo,
- product_price