April 6, 2005 at 3:40 am
Hi There,
I have been working with Databases for about 3 years, I dont claim to know more than you, I would just like to discuss my convetions with you and get your opinion.
Obviously we all have different ways of working with tables but I have identified 3 main types of tables which are: Main Tables(Eg Customer) = m_Customer
Lookup Tables (Eg Account Type) = l_accType
Cross Lookup Tables (Eg Account & Payment status) = x_accPayStat
This helps the sorting on your tables as well, as they are sorted by name in SQL server.
For views I use the prefix vw (eg vw_cusAcc) = Customer Accounts
For procedures I use the prefix proc (eg proc_mrgeAcc) = Merge Accounts
I think camel case is the best way of naming columns as well with a self defined prefix eg the m_Customer table will have the prefix cus_firstName,cus_lastName you get the basic idea.
This is my convention hope this comment helps.
Kind Regards,
Danny
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply