title: Need to update my single user app database to allow multiple users, how to modify database schema?
body: <p>I built an app for a local group who runs frisbee leagues not too long ago.  I am wanting to build this out, and make it something that I can provide to other groups. </p>
  
  <p>Jist: people sign up to play, app creates teams, app creates schedules, there are admins for each group who can manage their leagues</p>
  
  <p>The problem is, I have one database, and it was originally set up to only deal with one group's leagues.  How would I go about reworking the schema to allow multiple groups to be able to log in and modify only their own leagues.</p>
  
  <p>My thought was to create an "account" table, and tack "account_id" to every table.  Is this a good approach?  I have attached the schema, so you should be able to see what I have thus far!</p>
  
  <p>Note: I am building this in Codeigniter (php) and MySQL.</p>
  
  <p><img src="https://i.stack.imgur.com/E2Rn3.jpg" alt="enter image description here"></p>