Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bcanonica
Starting Member
35 Posts |
 Posted - 2009-04-15 : 16:27:38
|
| Anyone have experience with designing a database structure similar to this, CONTACT parent table that has a one to many relationship with a child table CONTACTPHONENUMBERS. CONTACTPHONENUMBERS has a look up table of PHONETYPES.This would allow you to have multiple "work numbers" for one contact and give you the scalability to add new phone number types going forward. Anyone ever do anything similar or have issues with this type of structure? |
|
|
SQLinTheCloud
Starting Member
3 Posts |
Posted - 2009-04-16 : 01:39:39
|
| Yeah, I can help you with that...back in 2001 I wrote a piece for the SQL Server Magazine that addresses your question..."Metamodel for Contact Manager", Michelle A. Poolet,InstantDoc #21120, July 2001, http://sqlmag.com/Articles/Print.cfm?ArticleID=21120. If you've got a subscription to the mag you can pull up the text and then yell at the management because they've blown the connections to the images, which is really not good. If you don't have a subscription you can spend $6 and buy a month's pass to the entire online archive and browse to your heart's content. Good luck with your design! |
 |
|
|
LoztInSpace
Aged Yak Warrior
940 Posts |
Posted - 2009-04-16 : 09:36:47
|
| Nothing wrong with it. Another option is Contact(contactID, stuff)PhoneNumber(pnID, number)ContactToPhoneNumber(contactID, pnID, pnType)PhoneNumberType(pnType,desc)which allows for more than one number to have multiple usesregardless, the only 'issues' come when you have to decide which 'work number' you have to use when you have more than one. You have to incorporate extra data somewhere depending on what you decide. |
|
|
|
rdemartini
Starting Member
2 Posts |
Posted - 2009-04-16 : 10:50:02
|
| does anyone have experience working with SQLite3 on iPhone application platform... I am trying to convert an IPhone timeIntervalSince1970 stored as a REAL to .NET dateTime |
|
|
|
|
|
|
|
|
Design