[UPHPU] Database Conventions

[Ray Hunter]

> 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