I'm working on a site, and one feature will require two tables to store data. Records in table1 will sometimes (but not always!) also have an associated record in table2. When considering the design for this, I'm puzzled by one question: which table should reference which? Should the design be:
----table1-----
| id | table2_id |
--table2--
| id |
or:
--table1--
| id |
----table2-----
| id | table1_id |

--
The above message is encrypted with double rot13 encoding. Any unauthorized attempt to decrypt it will be prosecuted to the full extent of the law.



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to