I would add something about PK notation convention. I've seen a lot of "CustomerId", "ProductId" and so on as PK column name. The argument for this was it makes easier to spot the join columns (CustomerId in parent table, CustomerId in child table). Yeah right.
In my oppinion, Customer.Id = childtable.CustomerId is as good as the first approach. The benefit in this approach is if you will ever need/have/develop a tool to automatically generate CRUD commands, having a standardized name for primary key column will help a lot (been there, got bitten, learned my lesson). On Tue, Oct 18, 2011 at 2:28 PM, Stephen Russell <[email protected]> wrote: > On Tue, Oct 18, 2011 at 3:00 AM, Thierry Nivelet <[email protected]> wrote: >> ftp://foxincloud.com/standards.pdf >> > ------------------ > > Keeping the pollution in plain sight. Please DO NOT EMBED data type > in column name. That is perfect for your variables but it is wasteful > in column names. It makes for long searches in intellisense as well > when you know the name but some bimbo had to place a prefix. <yes > this is a hot button for me!> > > Do not prefix and underscore every column with the table name as well. > > Client_tab is table name in system. > Client_first, Client_Last, Client_addr1, Client_addr2, etc. > Why would you corrupt intellesence and demand 8 wasted keystrokes > before you get to the first significant position to help actually find > the column name you want! > > > > -- > Stephen Russell > > 901.246-0159 cell > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAH=cqd+fd1+tvgz6gdjfrqhpj_bsvupcaclksg+us9vpzj8...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
