How to design a database to store unlimited type of user informaiton
Posted by: Bill Leung
Date: May 09, 2008 07:39PM

HI,

Just want to design a database to store users' information. Basically, it should be similar to Facebook, so there will be a lot of fields, like, name, birth place, work, tel, ...............

But how to do this??

I try to make a table to store basic user information like, username, password, id, and email
and another one to store the type and the id of type of user information, like birth place, work company....
finally, another will store the type id, user id, and the content/information of the type of the user.

However, there is a problem that the data type of each information, like, birth place needs maybe 30 chars, but the "about me" need to be a text field...

How to deal with this problem??

Thank you!!

Options: ReplyQuote


Subject
Written By
Posted
How to design a database to store unlimited type of user informaiton
May 09, 2008 07:39PM


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.