How can I store in a db several phone numbers to be related to their own restaurants?

Posted by Rami Alashri on Stack Overflow See other posts from Stack Overflow or by Rami Alashri
Published on 2010-03-29T21:40:09Z Indexed on 2010/03/29 21:43 UTC
Read the original article Hit count: 411

Filed under:

phone

|

relations

|

table

|

database

I have a table called "restaurants" which contains each restaurant information, I want to add its phone numbers. Should I make another table called say "phones" with fields "phone1", "phone2", "phone3", etc, then make a relation between them? or their is an easier way to do this? Thanks a lot :)

© Stack Overflow or respective owner

Related posts about phone

Measuring "real" phone signal strength on a mobile phone

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to programmatically measure the phone signal strength in a mobile phone. I don't actually care about the mobile phone or the programming environment: It can be based on android or windows mobile or even J2ME and can be from any manufacturer (please no iPhone). However, it needs to be a real… >>> More
Rapid Repository – Silverlight Development

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Hi All, One of the questions I was recently asked was whether the Rapid Repository would work for normal Silverlight development as well as for the Windows 7 Phone. I can confirm that the current code in the trunk will definitely work for both the Windows 7 Phone and normal Silverlight development… >>> More
Looking For iPhone 4S Alternatives? Here Are 3 Smartphones You Should Consider

as seen on Tech Dreams - Search for 'Tech Dreams'
If you going to buy iPhone 4S on a two year contract in USA, Europe or Australia you may not find it expensive. But if you are planning to buy it in any other parts of the world, you will definitely feel the heat of ridiculous iPhone 4S price. In India iPhone 4S costs approximately costs $1000 which… >>> More
Windows 7 Phone Database Rapid Repository – V2.0 Beta Released

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Hi All, A V2.0 beta has been released for the Windows 7 Phone database Rapid Repository, this can be downloaded at the following: http://rapidrepository.codeplex.com/ Along with the new View feature which greatly enhances querying and performance, various bugs have been fixed including a more serious… >>> More
Windows 7 Phone Database – Querying with Views and Filters

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
I’ve just added a feature to Rapid Repository to greatly improve how the Windows 7 Phone Database is queried for performance (This is in the trunk not in Release V1.0). The main concept behind it is to create a View Model class which would have only the minimum data you need for a page. This View… >>> More

Related posts about relations

Rails model relations depending on count of nested relations

as seen on Stack Overflow - Search for 'Stack Overflow'
I am putting together a messaging system for a rails app I am working on. I am building it in a similar fashion to facebook's system, so messages are grouped into threads, etc. My related models are: MsgThread - main container of a thread Message - each message/reply in thread Recipience - ties… >>> More
Doctrine toarray does not convert relations.

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, so..I followed doctrine documnetation to get started. Here is the documentation http://www.doctrine-project.org/documentation/manual/1_2/en/working-with-models#dealing-with-relations:retrieving-related-records My code is $User = Doctrine_Core::getTable("User")->find(1); when I access… >>> More
When should complexity be removed?

as seen on Programmers - Search for 'Programmers'
Prematurely introducing complexity by implementing design patterns before they are needed is not good practice. But if you follow all (or even most of) the SOLID principles and use common design patterns you will introduce some complexity as features and requirements are added or changed to keep… >>> More
Pair programming business logic with a non-IT person

as seen on Programmers - Search for 'Programmers'
Have you have any experience in which a non-IT person works with a programmer during the coding process? It's like pair programming, but one person is a non-IT person that knows a lot about the business, maybe a process engineer with math background who knows how things are calculated and can understand… >>> More
how do I write a functional specification quickly and efficiently

as seen on Programmers - Search for 'Programmers'
So I just read some fabulous articles by Joel on specs here. (Was written in 2000!!) I read all 4 parts, but Im looking for some methodical approaches to writing my specs. Im the only lonely dev, working on this fairly complicated app (or family of apps) for a very well known finance company. I've… >>> More