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
