Looking for field name standards documents

[Ray Cassick]

Not answers really, just pointers that people may know of to any industry and business segment specific field name standards documents out there. Things that address naming conventions across various industry\business segments so that I can look to normalize a set of tables for a generalized system that could cross industry boundaries and still manage to keep some standardization across industry expectations would be great. I admit here I have just start my search so perhaps I am being a bit lazy :) But is IS 3:53 AM on Jan 1 and I am up thinking about THIS :) so I figured I'd ask the masses here for some advice at the start of the new year.. Thanks for any pointers.

---

LinkedIn[^] | Blog[^] | Twitter[^]

[Lost User]

Ray Cassick wrote:

Things that address naming conventions across various industry\business segments so that I can look to normalize a set of tables for a generalized system that could cross industry boundaries and still manage to keep some standardization across industry expectations would be great.

Probably not what you expected, but I'd go for English. No systems hungarian, just a short name in a single language. Now, a fieldname is rarely self-descriptive, so it would be a good idea to keep a list with the fieldnames along with their descriptions. That way you can make sure that everybody knows what you mean when you refer to a "client". A good description should be self-explanatory to readers who have no specific knowledge of either domain. That requires a definition of the fields' contents in such a way that it's not going to be confusing to the reader, whether it's a programmer thinking about sockets or an enduser thinking about leads - it should be clear from the documentation of the design what a "client" is. Your goal would be to remove any possible ambiguity. MSDN[^] would be a general pointer. It would also help if you use a standard-unit of measurement, where possible. --edit-- SQL is case-insensitive, hence no recommendations on the use of camelCasing and the like :)

I are Troll :suss: