Pinyin table list all pinyin symbol, its English letter for keyboard input, type(Initial-I, Finals-F, Unique PinYin rule-U), its sequence order in that type, and further we group them for beginner to memorize them.

It has the following fields :

Pinyin symbol  Text field Yes  
English letter  Text field Yes  
Type  Menu field I F or U
Group  Menu field No  
Audio  File field No  
Ordering  Number field No
Spelling_rule  Text field No

Pinyin symbol: ying
English letter: YING
Type: U
Group: 4
Audio: Audio file (MP3) ying.mp3
Ordering: 11
Spelling_rule: YING is U when ing has no initial