db-jdo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Robin M. Roos" <ro...@ogilviepartners.com>
Subject Re: Fwd: Convention for case of SQL objects
Date Tue, 15 Feb 2005 14:58:50 GMT
The conventions which I'm used to here in London are:

table names: capitals with _ separator

column names: lowercase with _ separator

e.g. EMPLOYEE_PAYROLL.employee_id

On Mon Feb 14 20:37:40 PST 2005, Niclas Hedhman 
<niclas@hedhman.org> wrote:

> On Tuesday 15 February 2005 07:49, Craig Russell wrote:
>> Please reply to jdo-dev alias as well as jdo-experts alias.
>> This is not a super important issue but it's very timely.
> :o)
> IMHO, I think the UPPERCASE that is still preferred by many DB 
> admins are a relic from COBOL days, and that the CamelCase is 
> both easier to read. But since Tables maps roughly with classes 
> and columns roughly to members, wouldn't it make sense to 
> preserve case at all times when automated and 'use' same case 
> when manually mapped?
> I also think this is a non-issue in that if there is already 
> something in place, then use it. Don't spend time on a change.
> Cheers
> Niclas

View raw message