title: ER Diagram/Schema Setup with Admin/Member roles
body: <p>I am learning databases and am trying to create an ER Diagram for a scenario where a User (has own table) can create an Event (has own table). </p>
  
  <p>A User can have many Events and an Event can have many Users so I plan to use a join table called UserEvent. </p>
  
  <p>In this scenario I want a User to be able to create an Event and be the only admin for that event so that he/she can edit or delete the Event. </p>
  
  <p>For which table would I want to specify the 'user role' (Admin or Member) of the Event that was created? Is this the best setup for this scenario?</p>