Most Powerful Open Source ERP

Guideline SQL Column Id Use Singular For Related Key

To ensure consistent SQL naming.
  • Last Update:2017-04-06
  • Version:001
  • Language:en

Use Singular For Related Key Like Column Id

Related Keys are used inside the portal_catalog. You can define some in the settings tab.

Related Keys should be named like SQL column ids, because they are virtual columns. We should not use abreviations.

Good Example:

destination_title
destination_portal_type
grand_parent_simulation_state

Bad Example:

destinationType

Sometimes, we want to specify from which table we will take values (when it is not the default catalog one).

Good Example:

stock_section_category_uid

Bad Example:

stock_sectionCategory