[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-windows
Subject:    Re: [PHP-WIN] Help on MYSQL Table design
From:       "Toby Miller" <tmiller () cgchost ! net>
Date:       2001-04-30 18:12:27
[Download RAW message or body]

John,

No, you could just add another link table. So you would have the following
tables:

personal_info
------------------------------
ID -> unique id for family member
NAME -> family members name

family_info
------------------------------
ID -> unique id for family
F_NAME -> family name

personal_family_link
------------------------------
P_ID -> comes from personal_info.ID
F_ID -> comes from family_info.ID
RELATIONSHIP -> family members relationship

All of these fields would be required (NOT NULL).

Toby


----- Original Message -----
From: "John" <frizzy1994@hotmail.com>
To: <php-windows@lists.php.net>
Sent: Sunday, April 29, 2001 8:57 AM
Subject: [PHP-WIN] Help on MYSQL Table design


> Hi Everybody,
>
> I have 2 tables: personal_info and family_info.
> For example, in personal_info, I have ID and NAME as fields. In
> family_info, I have ID, F_NAME and RELATIONSHIP as fields.
>
> The problem is in family_info, for each ID, I have several records. Do I
> need to have another field, say, COUNT in family_info so that I
> associate these records to each ID?
>
>
> Thanks.
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net
> For additional commands, e-mail: php-windows-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>


-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net
For additional commands, e-mail: php-windows-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net

[prev in list] [next in list] [prev in thread] [next in thread]