Name columns in the most natural way. There is no need to have the table name or component name as the column name prefix. That is redundant. e.g. prefer USERNAME over UM_USERNAME as the column name.
On Wed, Nov 19, 2014 at 10:26 AM, Prasad Tissera <[email protected]> wrote: > Hi Inosh, > > AFAIK Oracle limits column size to maximum of 30 characters. Since > TABLE_NAME_COLUMN_NAME > will not work in most cases. Thanks. > > Regards, > Prasad. > > On Tue, Nov 18, 2014 at 10:36 PM, Inosh Perera <[email protected]> wrote: > >> Hi all, >> I went through couple of products and noticed, the naming conventions >> used are inconsistent in some SQL scripts. >> What is the standard way of naming, >> 1. Tables - Currently, this is consistent, and the standard is appending >> a prefix that describes to which component the table belongs to, such as >> REG_*, UM_*. >> 2. Columns - This is inconstant as some scripts contain >> TABLE_NAME_COLUMN_NAME and some doesn't have the table name appended. I >> also noticed some have COMPONENT_NAME_COLUMN_NAME, instead of table name >> as a prefix. >> >> What is the recommend approach? >> >> Regards, >> Inosh >> >> -- >> Inosh Perera >> Software Engineer, WSO2 Inc. >> Tel: 0785293686 >> >> _______________________________________________ >> Dev mailing list >> [email protected] >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > Prasad Tissera > Software Engineer. > Mobile : +94777223444 > -- *Afkham Azeez* Director of Architecture; WSO2, Inc.; http://wso2.com Member; Apache Software Foundation; http://www.apache.org/ * <http://www.apache.org/>* *email: **[email protected]* <[email protected]> * cell: +94 77 3320919blog: **http://blog.afkham.org* <http://blog.afkham.org> *twitter: **http://twitter.com/afkham_azeez* <http://twitter.com/afkham_azeez> *linked-in: **http://lk.linkedin.com/in/afkhamazeez <http://lk.linkedin.com/in/afkhamazeez>* *Lean . Enterprise . Middleware*
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
