Database for a website

[quark]

I have a database driven website I am building & have a few questions.

First I have about 5 tables (possibly more) I want to make to store information & want to make sure I'm building it relationally correct.

My main table is the members table. Here I will assign the member a primary key & everything will revolve around the primary key since it is a member based website.

Next, I have Favorites, orders, conversations & feedback tables.

My question is, do I simply need to have a column for the primary key in all the subsequent tables to link them back to the member?

[peter]

Hi quark,

you have to add a so-called foreign key column to every subsequent table that references the primary key column in your member table.
If you don't add it: how do you know which favorite or order belong to which member?
_________________
Peter
Moderator

[Pollux]

You can see in this product catalog how to relate different dependent data when you need from PK or FK and how few FK can be compound PK.
_________________
Nothing's imposible imagination is everything!
Database Benchmark Software (GPL) | World's fastest database