At CFUnited I got the impression that the database naming convention we are
using is "old school" but I am meeting some stiff resistance about changing
it here. I am being given practical reasons; not just for the sake of
keeping the new databases the same as the old ones.
I am wondering what are the practical reasons for switching to the new way
of TableName ColumnName besides the one I mention below?
Most of the databases that have been created here use the naming convention
of a three digit prefix and each word divided by an underscore.
So for a table name Customer the fields would be
CST_FIRST_NAME
CST_CITY
Fairly recently we switched to Oracle. Before that we used all lower case in
our names. With Oracle it's all upper case.
My main objection to sticking with the old way is that it requires an entry
in reactor.xml for every field in the database. I plan to write a process
that will do most of the work but it is an extra step that I'd prefer to
avoid.
<reactor>
<objects>
<object name="CUSTOMER" alias="Customer">
<field name="CST_FIRST_NAME" alias="FirstName" />
<field name="CST_CITY" alias="City" />
</object>
</objects>
</reactor>
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
