DB design question (so maybe a little OT)
| From: | Alexander Deruwe | Date: | Fri, 07 Sep 2001 20:26:32 +0000 |
| Subject: | DB design question (so maybe a little OT) | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-12253@lists.php.net to get a copy of this message | ||
Hey all,
I have 4 database tables, that each describe some sort of 'person'
(transporting company, truck-driver, ..) and have almost exactly the same
fields.
Is this the best way of storing this, or does this make more sense:
One table, with all the same fields + 1 extra, noting the type of person
(that could come from yet another table).
Any suggestions, 'cause this really bothers me. :)
ad.