On Jan 9, 2008 1:09 PM, Ray Hunter <[EMAIL PROTECTED]> wrote: > > Does UPHPU have a recommended resource in database conventions? If not > > could we start to discuss the pros and cons of the different styles. > > What do you use? What are some of the most popular conventions? I > > personally am looking to adopt one, but would like your input. > > in terms of naming conventions here is my standard: > > - allow lowercase letters with underscores as spaces. > - very descriptive names > - abbreviations for types in names > - db name similar to project name > > [example] > table: system_users > > field: users_id > users_first_name > users_last_name > users_address_id > users_status > > keys: users_id_pk > users_address_id_fk > > index: users_last_name_idx > > trigger: update_users_status_tgr > > view: v_users_admin > > > Basically, we try and come up with a set standard that everyone agrees > on that we can use and implement without too much hassle. We have > refined ours a bit and added abbreviations where needed. We make sure > that the labels really help with identifying the physical and logic data > layout. > > one thing to be aware about are database specific labels that you might > have a conflict with and length of labels (names). > > > -- > thebigdog > > _______________________________________________ > > UPHPU mailing list > [email protected] > http://uphpu.org/mailman/listinfo/uphpu > IRC: #uphpu on irc.freenode.net >
Ray describes a naming standard that has been around for a long time and is used by a lot of people. I was first introduced to this type of standard when I took my first Informix class back in... 1994. I have used a variation of it ever since. What I like about it is that every field in the database is uniquely identified (back from the day when data dictionary elements in a database had to be unique) and that you can tell by the field name what the field is used for (most of the time). My humble $.02. -- Scott Hill Food for thought: An eagle may soar but a weasel will never get sucked into a jet engine. A closed mouth gathers no foot. Never squat with your spurs on. _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
