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
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 Exchange rates
For the exchange rates only you