Re: MySQL DB Schema
| From: | Erik Price | Date: | Tue, 18 Feb 2003 18:00:52 +0000 |
| Subject: | Re: MySQL DB Schema | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-136044@lists.php.net to get a copy of this message | ||
On Tuesday, February 18, 2003, at 12:39 PM, David Otton wrote:
You want the tables and the relationships between them? Not easy to get the links because of the lack of foreign keys in MySQL.You can add a comment to your table with the COMMENT modifier, which gives you 60 characters to describe your table's relationship to other tables. (In a table named "registrants", you could have the comment registrants.user_id = users.user_id ) http://www.mysql.com/doc/en/CREATE_TABLE.html Erik -- Erik Price email: erikprice@mac.com jabber: erikprice@jabber.org