RE:

  • 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