Re: several pointers to records in one field
| From: | Alain Barthélemy | Date: | Mon, 17 Mar 2003 22:11:16 +0000 |
| Subject: | Re: several pointers to records in one field | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-26430@lists.php.net to get a copy of this message | ||
Le lundi 17 mars 2003, 15:19:07 ou environ May, Patrick <Patrick.May@Thomsonmedia.com> a
écrit:
> The table structure I can imagine:
>
> person
> ------------
> personId
> name
> etc
>
> relationship
> ------------
> relationshipId
> description
>
> personToPersonRelationship
> --------------------------
> fromPersonId
> toPersonId
> relationshipId
>
> The flexibility in here is to let you model pretty much any
> relationship between two people. I don't know your data, but this may
> be helpful (To be able to express step mothers, step fathers, nannies,
> etc)
>
> ~ Patrick
Thank you Patrick. I keep the proposition but I'll try the proposition
of Johh Holmes.
--
Alain Barthélemy
cassandre@bartydeux.be
http://bartydeux.be