Hmmm....I took a look at that page and was pleased to see that I follow the standards closely, but I've never used a "corresponding constraint name"...
I've always used what I considered foreign keys, by using the Primary Key of one table in another as a linking field, like the Customer_ID in the Order table...but what's the purpose of a "corresponding constraint name" and the FKn...etc., as described below? Rick The corresponding constraint names should be the table name followed by _FKn where n = 0..9 (e.g., ADDRESS_FK1, ADDRESS_FK2) -----Original Message----- From: Chris Terrebonne [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 29, 2005 4:29 PM To: CF-Talk Subject: Re: Database Model Suggestions - Elections Here are a few general db standards: http://livedocs.macromedia.com/wtg/public/coding_standards/database.html >>> [EMAIL PROTECTED] 03/29/05 01:37PM >>> Why is everyone naming their tables singularly? :) Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200596 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
