design tables to hold historical data. #4

I need to redesign the tables used to hold historical data.

I believe the best way to do this is to recreate the standard AACT tables, but with a date indexing scheme.

I also believe that something I'll need to do is create an SQL file that constructs this automatically.

I need to redesign the tables used to hold historical data. I believe the best way to do this is to recreate the standard AACT tables, but with a date indexing scheme. I also believe that something I'll need to do is create an SQL file that constructs this automatically.

Currently spread over a couple of schemas:

The HTTP schema handles requests and raw html returns.

The history schema is where I'll be putting the parsed data responses.

Currently spread over a couple of schemas: The HTTP schema handles requests and raw html returns. The history schema is where I'll be putting the parsed data responses.

Labels Milestones

design tables to hold historical data. #4