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,


> 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

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to