Airline tbl
From UG
mysql> describe tblAirline; +---------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+----------------+ | Id | int(10) | NO | PRI | NULL | auto_increment | | TwoLetterCode | varchar(2) | NO | | NULL | | | Name | varchar(30) | NO | | NULL | | | NumericCode | varchar(3) | NO | | NULL | | +---------------+-------------+------+-----+---------+----------------+ 4 rows in set