 <p>I am not able to see your images (blocked!) so I'll just try to describe the "correct" design. If a player living in a zone doesn't necessarily mean they own it, you should have four tables: </p> <pre><code>PLAYER (playerid, &lt;other fields&gt;) ZONE (zoneid, &lt;other fields&gt; PLAYER_ZONE(playerid, lives_in_zoneid) ZONE_OWNER (zoneid, owner_playerid) </code></pre> <p>Otherwise three tables would suffice.</p>