|
duhaas
Constraint Violating Yak Guru
308 Posts |
 Posted - 09/06/2006 : 08:54:02
|
| I will try and explain this the best I can. I have a customers table that I want to store monthly historical data for. Currently the table consists of about 12 colums, with a large number of them being foreign keys. If I want to store historical data, meaning some of these foreign key entry values could change month/month, should i just add like a month end data column to the customer table, and just import the data fresh each month, this way i can always reference what an account looked like on a given month end date? Or is there a better method of doing this? |
|
Historical Database Design
