StarXploser
September 16th, 2006, 11:13 AM
Hello,
I'm building a small app that lets people find users with the same interests.
I dont know exactly what I will put in there but I was thinking something like, Favorite Book, Movie, Actor,...,hobby,etc...
I would like to hear from you guys if you think that the way I'm building my mySql tables makes sense, I don't want to restructure everything after the site is launched. So here is what I have so far:
USERS
---------------------------------------------
| ID | Name | D.O.B | Etc.... |
---------------------------------------------
FavBOOKS
----------------------------
| BookTitlte | UserID |
----------------------------
FavActor
-----------------------------
| ActorName | UserID |
-----------------------------
ETC......
-------------
| ... | ... |
-------------
Does it make sense? Is there a better way?
Thanx
I'm building a small app that lets people find users with the same interests.
I dont know exactly what I will put in there but I was thinking something like, Favorite Book, Movie, Actor,...,hobby,etc...
I would like to hear from you guys if you think that the way I'm building my mySql tables makes sense, I don't want to restructure everything after the site is launched. So here is what I have so far:
USERS
---------------------------------------------
| ID | Name | D.O.B | Etc.... |
---------------------------------------------
FavBOOKS
----------------------------
| BookTitlte | UserID |
----------------------------
FavActor
-----------------------------
| ActorName | UserID |
-----------------------------
ETC......
-------------
| ... | ... |
-------------
Does it make sense? Is there a better way?
Thanx