Relation between user table and profile table

Question

0.00/5 (No votes)

See more:

Hi dear experts.
i want to build a simple social network .I'm currently working on the architecture
Now I've created the users table . but i can't understand relation between users table and profile table . ! Whether their relationship is 1 to 1?

Posted 15-Feb-12 21:13pm

Saeid.Babaei86

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2012-02-15T21:24:00

Solution 1

How many profiles do you expect your users to have?

Is it one user, one profile?
Or one user, many profiles?
Or many users, one profile?

The answer to that question is the answer to yours...

Posted 15-Feb-12 21:24pm

OriginalGriff

Comments

Saeid.Babaei86 16-Feb-12 3:30am

hi .
my profile table provide some fixed columns such as first name last name birthdate ,...
One user have one profile

OriginalGriff 16-Feb-12 3:41am

Then that should answer your question...

Sarvesh Kumar Gupta · Answer 2 · 2012-02-15T23:39:00

Hi, you have one user table and one profile table.
one user has one profile and reference of user id into profile table

add Userid as primary key in user table - auto increamented field
use this field make foreign key in profile table and using join queries you can fetch all fields from both the tables.