title: Help with MySQL database structure - user notification system
body: <p>I'd like to send global notifications to my users (1000+ users) and allow them to close the notification box once they have read the message.</p>
  
  <p>Basically I may send one notification per week globally ie/ each user get the same message and they are not personal in nature.</p>
  
  <p>What is the best way to achieve this?</p>
  
  <p>Create 2 tables:</p>
  
  <pre><code>**tb_messages**
  message_id
  massage_title
  message_content
  
  **tb_read_messages**
  user_id
  message_id
  is-read
  </code></pre>
  
  <p>That way i can just show each user the current notifications that are not read?</p>
  
  <p>select * from tb_read_messages WHERE user_id = $user_id AND is-read = no</p>
  
  <p>OR is there a more efficient way?</p>
  
  <p>Thanks!!!</p>