RE: [CFCDev] OT: Database design

[Nolan Erck]

One question: is the “Person” entity the same as “Client/Vendor” or is it the same as “Contacts”?  I think you meant “Person” and “Contacts” to be the same, but I want to double-check first.   -nolan     Nolan Erck Web Developer/Programmer Schools Financial Credit Union (916) 569-5409 Office (916) 569-2024 Fax www.schools.org -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sam Shrefler Sent: Friday, February 10, 2006 11:45 AM To: cfcdev@cfczone.org Subject: [CFCDev] OT: Database design   This is a little off-topic but: I was wondering if anyone had suggestions on how i can build my database for the following datastructure (what keys would be between tables)... Multiple Tables reperesenting different Entities (Client, Vendor, ....) Each of those can have multiple Contacts (Contact) Each Person can have ContactTypes (emails, phone numbers, faxes) I'm stuck how i can make a datastructure that can reuse the Contact tables for each different Entity table and each Contact can have many entries in the ContactTypes table Thanks Sam ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to cfcdev@cfczone.org with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/cfcdev@cfczone.org The information contained in this e-mail is confidential and may contain privileged information exempt from disclosure under applicable law. The information is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, employee, or agent responsible to deliver it to the intended recipient, you are hereby notified that any use, dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please delete the message from your computer and immediately notify the sender by telephone (you may call collect) at 916-569-5400 or by e-mail to [EMAIL PROTECTED] Thank you. ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to cfcdev@cfczone.org with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/cfcdev@cfczone.org