Hi Azeez, This is what we thought as well. Thanks. Regards, Inosh
On Wed, Nov 19, 2014 at 10:49 AM, Afkham Azeez <az...@wso2.com> wrote: > 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 <pras...@wso2.com> 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 <ino...@wso2.com> 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 >>> Dev@wso2.org >>> 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: **az...@wso2.com* <az...@wso2.com> > * cell: +94 77 3320919 <%2B94%2077%203320919>blog: * > *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* > -- Inosh Perera Software Engineer, WSO2 Inc. Tel: 0785293686
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev