Linking phone book table/group table to account table
Posted by: Seth Meltzer
Date: March 01, 2007 03:35PM

Hi all. I have searched this forum but can't solve this table design question:

So far I have a general login table with username/password/email, etc. and a couple of other tables with the username as primary in order to link them.

I need to give users a phonebook entry option to store phone numbers -- but here's what's holding me up: I need to also allow users to group phone numbers together in different ways. For example grouping phone numbers as Personal contacts, Business Contacts, Rotary Club contacts, etc.

Do I need one table for each user? Or one table for each grouped phone list? I can't figure out how I would fit all those requirements into rows in one table.

Thanks so much in advance! Any help I can get is much appreciated!

Options: ReplyQuote


Subject
Written By
Posted
Linking phone book table/group table to account table
March 01, 2007 03:35PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.