I'm working on a small project where I will parse a live XML feed to store college football matchups, including odds, into a database. I then want to subscribe to a live results feed that will also be stored in a database. I want to show the matchups and odds on a web page, and have the results automatically update whether somebody picked the winner by the spread or not. So far, I have one table in my database where I will parse and store the live XML feed containing matchups and odds. Here is what that looks like so far:
Matchups Table
Match ID (primary key) (Unique Identifier)
Away_Team VARCHAR (56)
Away_Odds VARCHAR (5)
Home_Team VARCHAR (56)
Home_Odds VARCHAR (5)
Does anybody have any experience on how I would store the results portion of this project? Would it be in the same table?