Table Naming Convention
martin.obongita at yahoo.com
Mon Jan 2 06:09:56 UTC 2023
I know that this topic has been discussed over and over in other forums.
I have searched the archives and I didn't find this topic discussed.
Most of the applications I have seen, I notice that the table column names are prefixed.
A student table named "student" will have the columns studentID, studentName etc
I guess this is helpful when working with queries.
On the other hand in my Postgresql db, I prefix my tables in categories.
System setting tables will begin with "z" eg "z1_setup", "z2_parameter" etc
The columns will be named z1_id, z1_datatype, z1_columndefault, z3_defaultpassword, z3_passwordlength,z3_passwordminchar
This will help when I create views and materialized views.
I will simply concatenate two table names using their prefixes.
This makes my work very easy when referencing columns.
My question is, What is the best practice in naming table columns and running SQL statements with Omnis query classes?
Best regardsMartin Obongita.
More information about the omnisdev-en