Hi Phil
Yep, it looks like that will do.
Thanks
>> -Original Message-
>> From: freedc@gmail.com [mailto:freedc@gmail.com] On Behalf Of
>> Phil
>> Sent: 10 May 2010 13:53
>> To: mysql@lists.mysql.com
>> Subject: Re: Database tables for Ex
For the exchange rates only you don't really need more than one table. I
work with an enterprise financial system and we have exchange rate tables
which are updated with data every day.
Something like
BASE_CURR char(3)
NONBASE_CURR char(3)
EFF_DATE DATE
EXCH_RATE DECIMAL(15,6)-- or however
I am designing a database to store exchange rates and other information. The
tables fro the exchange rates will store exchange rates fro all currencies.
Can I have any suggestions about the number of tables to use for the
exchange rate? I think I will need at least 2 tables, but I am looking for
