Hi, The concept that you are describing, would that be of fetching info from a source site through a data scraper and storing the information into the database. However this is not a very accurate way to gather data as any change of the page structure or change in the source url may lead to erroneous data.
Therefore parsing the data through a valid API or xml feed would be a better way to do things. Having said that, if data scraping has been working for you I have no issues in implementing your ideas. Also, the data tables you have suggested are fine.
So let me know what you think ?
I will be happy to answer if any questions you might have ,
Regards,
Prasun