Neverside

League Database Design

Alright guys,

I'm creating a automated league (based on a football/soccer video game) site. Each member will choose a team (duplicates allowed) and play each other on a schedueled basis. Scores will be recorded per userid.

There will be multiple leagues (league 1 will have 20 teams, league 2 will have 20 teams etc) and multiple seasons (Season 1 will run from april to september, then points reset and season 2 begins). I would like to keep every season data though for archive purposes.

I'm a little stuck on database design so if anyone has done anything similar or has any ideas, that'd be great.

Thanks a lot!

___________________

//damell