Re: DB design question (so maybe a little OT)
| From: | Jonathan Hilgeman | Date: | Fri, 07 Sep 2001 18:41:01 +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-12255@lists.php.net to get a copy of this message | ||
I'm thinking that you should get all the common fields among the different
types of people:
F. Name, L. Name, Address, CC Number
And then create a different table containing additional information that
only pertains to certain types of people. Then join them using an id.
- Jonathan
"Alexander Deruwe" <a@deruwe.be> wrote in message
news:20010907182943.C6134217B2B@tartarus.telenet-ops.be...
> 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.