[RESOLVED] Databases linking with multiple tables

[everythingis]

Just want to make sure I'm doing this correctly.

These are my tables:
table 1: members (user_id, username, firstname, lastname)
table 2: events (event_id, event_title, start_date, end_date)
table 3: member_feed (feed_id, feed_field, feed_date

When I want to pull information from table 2 or 3 to display on the website & ensure it is from the correct user_id from table 1, am I duplicatiing my user_id field in each table and setting it as a foreign key?

Or, is there a different way I should be doing it?

Thanks!

[djjjozsi]

am I duplicatiing my user_id field in each table and setting it as a foreign key?

what do you mean: dupliacate your user_id?

If one user can make many feeds or events, you can store the userid as foreign key in the events and member_feed table.

[everythingis]

Ok, that's exactly what I mean. So my updated tables will be:

table 1: members (user_id, username, firstname, lastname)
table 2: events (user_id FK, event_id, event_title, start_date, end_date)
table 3: member_feed (user_id FK, feed_id, feed_field, feed_date)

[djjjozsi]

in events table user_id is redundant because member_feed also has a user_id value.

[everythingis]

but if I have 3 separate database tables, how would I know which user created an event or a member_feed without referencing the user_id in each one?

For instance, if a member cancels their account or I ban a member from my site & I delete their row in the database, I would want their feed and events to be deleted as well.

[Weedpacket]

If events and member_feed aren't related, but they are both related to users, then yes: both will use the user_id as a foreign key.

As for making sure that deleted users have their events and member_feed(s) deleted as well, you'd set the foreign key constraints to be ON DELETE CASCADE.

[everythingis]

Thanks!!