Re: Any preferred naming conventions?

Post #28,952 by Yendor 2/19/02 2:49:56 PM 2/19/02 3:14:15 PM Reply	Re: Any preferred naming conventions? I've seen a couple used before: tTableName.fFieldName vViewName.fFieldName t, v, and f are literally there. So: tVendor.fVendorID Another one which took me a while to understand why they did it like this: table_name.uniqueid_field1 table_name.uniqueid_field2 along with: table_2_name.uniqueid2_field1 So you could do something like: SELECT uniqueid_field2, uniqueid2_field1 FROM table_name, table_2_name WHERE uniqueid_field1 = uniqueid2_field1 Example: vendor.v_vendorid vendor.v_name product.p_productid product.p_vendorid SELECT p_productid, v_name FROM vendor, product WHERE p_vendorid = v_vendorid No need to worry about fieldname clashes. It's a bit tedious, but saves you from having to alias tables in your queries, and having to worry about that whole bit. -YendorMike Real programmers use "vi a.out". Edited by Yendor Feb. 19, 2002, 03:14:15 PM EST Expand All History
Post #29,028 by static 2/20/02 4:29:59 AM Reply	Extension of this idea. On the database I'm working with now, there was an effort to make field names globally unique, though we haven't completely succeeded. Generally, important tables give one letter prefixes to their field names (table contacts has a field c_firstname, for instance), while other tables get longer abbreviations. The extension we're using is that if the table has a unique ID - i.e. an autoincrement column - then it gets an "id" field. So, the contacts table has a c_id field, etc. Wade. "All around me are nothing but fakes Come with me on the biggest fake of all!"
Post #29,076 by tablizer 2/20/02 12:58:37 PM Reply	Foreign keys >> The extension we're using is that if the table has a unique ID - i.e. an autoincrement column - then it gets an "id" field. So, the contacts table has a c_id field, etc. << One convention I have seen that I liked is to use suffix "_ref" for foreign keys (and the regular "_id" for primary keys). In your example, a reference to the "c" table (via c_id) would be "c_ref". Or say "vendor_ID" and "vendor_Ref". Another variation is "_fk", but that looks like an insult if you read it fast. ________________ oop.ismad.com

Welcome to IWETHEY!