Using Power Ups
Edward Muller <[email protected]> Sun, 29 Jan 2006 19:00:22 -0600
| Newsgroups | gmane.comp.python.quotient.dev |
|---|---|
| Organization | Interlix |
| Message-ID | <[email protected]> |
I'd need to model the following one to many relationship. A customer can have different contacts. Each contact has a specific type (billing, tech, etc). Each contact can belong to multiple customers. I would normally do it with three tables: Customers -------------- customer_id name .... Contacts ----------------- contact_id name ... CustomerContactJoin ---------------------------- customer_id -> Customers.customer_id contact_id -> Contacts.contact_id type I feel that this is something I should be able to do with a powerup, but anyway that I conceive it seems to come out wrong. Can anyone point me in the right direction or offer any pointers? -- Edward Muller - Interlix [email protected] 417-862-0573 PGP Key: http://interlix.com/Members/edwardam/pgpkeys
signature.asc
(application/pgp-signature, 189 B)
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) iD8DBQBD3WUm6NYdR1GOdLkRApCnAJ4/PvMdJ5IiMm8fU9DWaLvXJFbSswCePqBm Zma+S5IM507ORPIugauoz0U= =CsOg -----END PGP SIGNATURE-----