Steve,
As much as I agree with you, the table names are far to
long. And wouldn't work in our current framework without us making so many
changes to the framework its not funny. In our Forums software that I wrote I
have this
fmForumCategories
fmForumTopics
fmForumMessages
I
think this is still easy to understand and read. And as each table as a link to
each other its easy to create and view relationships anyway.
Regards
Andrew Scott
Technical
Consultant
NuSphere Pty Ltd
Level 2/33 Bank Street
South Melbourne,
Victoria, 3205
Phone: 03 9686 0485 - Fax: 03 9699
7976
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Onnis
Sent: Wednesday, 4 May 2005 9:45 AM
To: CFAussie Mailing List
Subject: [cfaussie] Re: [best practice or your practice] Specifying table names in queries
I have
actually, but like a trooper i just accept that its the way it is and work with
it
--------Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Antony Sideropoulos
Sent: Wednesday, May 04, 2005 9:25 AM
To: CFAussie Mailing List
Subject: [cfaussie] Re: [best practice or your practice] Specifying table names in queriesI take it you've never had to work with a db that you haven't designed yourself?Lucky [EMAIL PROTECTED].The horror stories I could tell you...
On 5/3/05, Steve Onnis <[EMAIL PROTECTED]> wrote:--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/Name them properly in the begining then you dont need to
for example, i have a table called ForumTopisToForumCategories, indicating
to me that its a joiner table between Forum Topics and Forum Categories
If you wanted to then make it short hand for your SQL you coulf alias to be
FTTFC or something, but its rare.
I only alias if i am joining a table onto its self
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ ---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
