[CFCDev] OT: Database design

[Sam Shrefler]

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