Recently, a friend of mine requested me to create a Lookup module for Yii2. So in this regards, I have created a module for Lookup and wrote some steps how it can be used and download the zip version.
Goto the following url: Yii2 Lookup Module download and read how it can be used.
I hope this will be of some help 
You are using ‘latin1’ for your charset. We haven’t been using that for years. You should be using ‘utf8_unicode_ci’ or ‘utf8mb4_unicode_ci’. Yii2 advanced I think uses ‘utf8_unicode_ci’. However, ‘utf8mb4_unicode_ci’ offers full multi-language support for those having international users.
I don’t think ‘code’ or ‘sort_order’ should be int(11).
I encourage you to place your project on GitHub and Packagist so others can install your module with Composer, or at least view the code and see if it does what they want, without having to visit your site or download the file.