Hi all,

In my project of billing system, there is a table of long distance call rate, tb_ldrate, since the rate changes with time, the user need to create a new tb_ldrate when the rate changes. in that case the table name would be like tb_ldrate_20090101_20100630 to indicate the valid time peroid.

In hibernate the mapping between PO and the SQL table is pre-configured, it seems to me that it is impossible to manage table dynamically, so I have to add two columns to the original tb_ldrate indicating the start time and end time, for example, for the rate for long distance call to UNITED KINGDOM by Skype, after adding these two columns, the table will have many records of different time peroid for the call rate to UNITED KINGDOM , the bad side of this solution is that the table grows fast and error-prone.

Does anybody have any idea? Thanks in advance!

Lucy