List:General Discussion« Previous MessageNext Message »
From:John Meyer Date:August 11 2006 12:32pm
Subject:Re: mysql naming convention
View as plain text  
Barry wrote:
> Hello everyone!
> 
> I am looking for a standard naming convention for databases.
> 
> For example: is it good to use tablenames in column names like:
> table => tb_id,tb_text,tb_name

I've for a long time been using an uppercase notation for databases.
Probably isn't the best system, but it's what I've worked with so far.
That and naming the primary key on a table with the suffix ID.  Foreign
Keys have the same name as they do on primary keys.   Simple, strong,
ugly, and dignified

-- 
John Meyer
http://pueblonative.wordpress.com
http://pueblonative.110mb.com/board
Thread
mysql naming conventionBarry11 Aug
  • Re: mysql naming conventionDouglas Sims11 Aug
  • Re: mysql naming conventionJohn Meyer11 Aug
    • Re: mysql naming conventionJames Harvard11 Aug
      • Re: mysql naming conventionbnewton11 Aug
      • Re: mysql naming conventionPaul McCullagh11 Aug
        • Re: mysql naming conventionJames Harvard11 Aug