Okay, so here I am making an indeterminate

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

Welcome to IWETHEY!

Post #215,899 by folkert 7/21/05 10:27:48 AM Reply	Okay, so here I am making an indeterminate Relationship with tables. I have three tables. AddressDetail, ZipCodeInfo, CarrierRoutes. The relationships: AddressDetail.ZipCode -> ManytoLessMany -> CarrierRoutes.ZipCode -> ManytoLessMany -> ZipCodeInfo.ZipCode AddressDetail.CarrierRouteID -> ManytoLessMany -> CarrierRoutes.CarrierRouteID (with implied AddressDetail.ZipCode -> ManytoLessMany -> CarrierRoutes.ZipCode) It this Sane? (Yes, I relaize Many to less Many isn't a real relationship, but I think it is easier to think of it that way rather than Multiple Many to One relationships) -- [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\|\|\|\|]
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\|\|\|\|]
Post #215,909 by drewk 7/21/05 12:24:46 PM Reply	What's the primary key in CarrierRoutes? Is there a unique index in CarrierRoutes? === Purveyor of Doc Hope's [link\|http://DocHope.com\|fresh-baked dog biscuits and pet treats]. [link\|http://DocHope.com\|http://DocHope.com]
Post #215,916 by folkert 7/21/05 1:14:48 PM Reply	Record number. There are so many Carrier Routes that are the same, but for different ZipCodes... Awww, feck it all. The Address Details has everything I need, I just have to compute totals and sorting by. It ain't worth the effort to join this stuff. Of course... I could do all left joins. See as I only know them. -- [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\|\|\|\|]
Post #215,924 by tuberculosis 7/21/05 1:58:00 PM Reply	So CarrierRouteId+ZipCode is unique? "Whenever you find you are on the side of the majority, it is time to pause and reflect" --Mark Twain "The significant problems we face cannot be solved at the same level of thinking we were at when we created them." --Albert Einstein "This is still a dangerous world. It's a world of madmen and uncertainty and potential mental losses." --George W. Bush
Post #215,950 by folkert 7/21/05 3:23:46 PM Reply	Yessir Indeed that is what is unique. Never had to use a Multi-field primary key. -- [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\|\|\|\|]
Post #215,967 by tuberculosis 7/21/05 4:00:04 PM Reply	It happens and you can use it that way if it is immutable. Otherwise replace it with a generated key and add a constraint. "Whenever you find you are on the side of the majority, it is time to pause and reflect" --Mark Twain "The significant problems we face cannot be solved at the same level of thinking we were at when we created them." --Albert Einstein "This is still a dangerous world. It's a world of madmen and uncertainty and potential mental losses." --George W. Bush

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

iwethey.org

Where is a super volcano when you need one?
87 ms