CODEWITHSUNDEEP
phpmysqlsql
rossanmol
rossanmol

Reputation: 1653

MYSQL one-to-one relationship

I started transforming whole database to a normalised database. But there is one thing which I dont understand about relationships:

Let's say I have 2 tables:

Users
-userID (INT-PK)
-userName (varchar)
_favColor (int)

And:

Colors
-colorID (INT-PK)
-colorName (varchar)

Now obviously I have to create a relationship, the question is: Should I make relationship between Colors Table and Users Table, or between Users Table and Colors Table?

What I've noticed is that when creating a relationship, the relationship does not appear in both tables, it appears in just one of them, and this makes me confused.

Upvotes: 0

Views: 90

Answers (1)

Tom Johnson
Tom Johnson

Reputation: 699

For this example I would recommend a 1:M relationship, going from colours to users.

This is because the users table requires information from the colours table, the reason why you'd have a 1:M relationship is because different users may have the same favourite colour.

Upvotes: 1

Related Questions