title: Help designing database for a twitter web application
body: <p>I'm trying to create a small website in ASP.NET MVC that uses twitter. I want to be able to pull some information about twitter users and store it in a database, which I will update periodically.</p>
  
  <p>I am using the following tables:</p>
  
  <p><strong>Users</strong><br>
  user_id - uses the twitter id (int)<br>
  twitter_name - nvarchar(255)<br>
  last_updated - datetime  </p>
  
  <p><strong>TwitterData</strong><br>
  user_id<br>
  date<br>
  num_tweets<br>
  num_favorites<br>
  num_lists  </p>
  
  <p>Unfortunately I'm not really good with databases, so is this a good design? Can I use one table instead?</p>
  
  <p>Thanks in advance,
  Sasha</p>