--
--     This is the currency code/english name table from ISO 4217.
-- 
CREATE TABLE currencies (
	codea	 char(3) PRIMARY KEY NOT NULL,
	coden	 numeric(65535, 65531),
	minor_unit	 char(1),
	note	 varchar(4000),
	default_name	 varchar(100) NOT NULL
);


-- Tables with foreign keys that refer to currencies:
--currency_names(currency_names_iso_fk)
--iv_costs(iv_costs_currency_fk)
--iv_invoices(iv_invoices_currency_fk)
--iv_invoices(iv_invoices_paid_currency_fk)
--iv_price_lists(iv_prices_currency_fk)
--currency_country_map(currency_country_map_code_fk)
--iv_offers(iv_offers_currency_fk)
--iv_payments(iv_payments_currency_fk)

-- Table size: 0 bytes
-- Table rows: 0

Tables: