Re: DB design question (so maybe a little OT)
| From: | Justin Buist | Date: | Fri, 07 Sep 2001 19:47:56 +0000 |
| Subject: | Re: DB design question (so maybe a little OT) | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-12254@lists.php.net to get a copy of this message | ||
On Fri, 7 Sep 2001, Alexander Deruwe wrote:
> 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,
Nope...
> 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).
Correct, and another table "person_type" perhaps, with an id and a
description, add another field to your "person" table with a foreign key
to something in the "person_type" table.
Justin Buist
Trident Technology, Inc.
4700 60th St. SW, Suite 102
Grand Rapids, MI 49512
Ph. 616.554.2700
Fx. 616.554.3331
Mo. 616.291.2612