title: Database modelling
body: <p>I am trying to model sports games in a database..</p>
  
  <p>I have the following tables</p>
  
  <pre><code>[sport_game]
  sport_game_id
  sport_game_type_id
  name
  description
  
  [sport_game_instance]
  sport_game_instance_id
  sport_game_id
  start_time
  end_time
  
  [sport_game] 1 - M [sport_game_instance]
  
  [sport_game_type]
  sport_game_type_id
  type  -- professional, semi-pro, college..etc
  
  [sport_game] M - 1 [sport_game_type]
  
  [basketball]
  basketball_id
  sport_game_typeid
  basketball_info
  
  [basketball] 1 - 1 [sport_game_type]    
  
  [baseball]
  baseball_id
  sport_game_type_id
  baseball_info
  
  [baseball] 1 - 1 [sport_game_type]  
  </code></pre>
  
  <p>I'm not 100% sure about having the type table linked to specific sports; I sometimes think it works, but am just not sure.</p>
  
  <p>What I want it to be able to have a core set of classes with generic information, such as [sport_game], [sport_game_instance].</p>
  
  <p>With [sport game type] which I can modify and add more sports; its the separate tables I'm not sure about. I was thinking having them separate means anything related specific to a sport I can then join on to these tables, if I need to.</p>
  
  <p>What do you think?</p>