All pastes #964079 Raw Edit

Untitled

public text v1 · immutable
#964079 ·published 2008-03-31 00:40 UTC
rendered paste body
Hi, I'm coding a little application to make couples profile. The 
problem is I just don't know how to create my databases so that their 
are no bottlenecks and that I can have a relation. The way I see it is 
that their would be a user database and a profile database and they 
would link 2 to 1. Is this the right way? In the user db I would store 
their userid and some session info, should I use their userid as 
primary key? 

DB Scheme 
User1--- 
                |---Profile 
User2--- 

User DB 
-userid (primary key?) 
-profileid 
-session info 
-timestamp 

Profile DB 
-personnal info 
Any help would be appreciated, 
thanks' in advance.