Why have the zip in 3 seperate tables?

1,095 registered users | 1 active user | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #215,901 by ChrisR 7/21/05 11:10:36 AM Reply	Why have the zip in 3 seperate tables? Perhaps have one table that stores off addresses and have the other tables foreign key the addresses from there?
Post #215,906 by folkert 7/21/05 11:57:08 AM Reply	Table record number are in teh Millions already In details at least, the zip and carrier could be combined, unfortunately they have different tables columns in them tha would be like a cartesean join... 20 different ways. -- [link\|mailto:greg@gregfolkert.net\|greg], [link\|http://www.iwethey.org/ed_curry\|REMEMBER ED CURRY!] @ *i_wethey* [image\|http://www.danasoft.com/vipersig.jpg\|\|\|\|]

Okay, so here I am making an indeterminate - (folkert) - (7) - July 21, 2005, 10:27:48 AM EDT

Why have the zip in 3 seperate tables? - (ChrisR) - (1) - July 21, 2005, 11:10:36 AM EDT

Table record number are in teh Millions already - (folkert) - July 21, 2005, 11:57:08 AM EDT

What's the primary key in CarrierRoutes? - (drewk) - (4) - July 21, 2005, 12:24:46 PM EDT

Record number. - (folkert) - (3) - July 21, 2005, 01:14:48 PM EDT

So CarrierRouteId+ZipCode is unique? -NT - (tuberculosis) - (2) - July 21, 2005, 01:58:00 PM EDT

Yessir - (folkert) - (1) - July 21, 2005, 03:23:46 PM EDT

It happens - (tuberculosis) - July 21, 2005, 04:00:04 PM EDT

I'd like to thank the Academy...
52 ms