Linking phone book table/group table to account table
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!
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.