MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Table Relationships
Posted by: Barry Galbraith
Date: May 24, 2015 08:27PM

state_access probably doesn't need the id field.
Your primary key can be compund of state_id, user_id.
There will be one row of state_access per user/state combination.
So, if a user can access 2 states there will be two rows for that user, one for each state.

Good luck,
Barry.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Table Relationships
Michael Tranchina
May 22, 2015 09:47AM
Re: Table Relationships
Barry Galbraith
May 24, 2015 08:27PM
Re: Table Relationships
Does it matter
May 26, 2015 03:54AM
Re: Table Relationships
Phillip Ward
May 26, 2015 06:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.