Currency (tbl)
From UG
mysql> describe tblCurrency; +--------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+----------------+ | Id | int(10) | NO | PRI | NULL | auto_increment | | Name | varchar(50) | NO | | NULL | | | Abbreviation | varchar(3) | NO | | NULL | | | IsMain | tinyint(1) | NO | | 0 | | +--------------+-------------+------+-----+---------+----------------+ 4 rows in set