CodeKit - Universal Code Description Lookup Table

CodeKit - Universal Code Description Lookup Table
Home Page

CodeKit is an interface to a master code description lookup table. CodeKit takes all of the programming work out of maintaining multiple database code definition sets.

Doing internationalization work? Check out BabelKit, the multilingual code description lookup table.

CodeKit Administration Live Data Entry Demo

A live demo is worth 2^10 words:

Main Page
All Code Sets
and Counts Add a New Code Set
Add a New
Code Set Edit Country Codes
Edit Country
Codes Edit Currency Codes
Edit Currency
Codes

The code administration page lets you define new virtual code tables and enter all codes and their descriptions. Perl and PHP classes retrieve the code descriptions and automatically generate HTML code selection elements.

Do some live data entry! Make up new code sets. Enter some new codes. Have fun. Cleaned up automatically once a day.

CodeKit HTML Select Demo

Currency Code
Dropdown

Day of Week
Radio Box

Select Multiple
Countries

Submit to View
Selected Codes

This shows off HTML select elements. Make some selections and watch CodeKit strut its stuff! All without an ounce of programming. Well, maybe one ounce. You do have to call CodeKit :-)

CodeKit Downloads

CodeKit is available here as free software in PHP and Perl.

The current version is CodeKit-1.07.

Contact the author to report bugs, request features, or for database design and programming assistance.

CodeKit Documentation Set

Here is the index, the requirements and FAQ and the concepts and features overview.

CodeKit Administration Page

Take a look at the code administration interface in read only mode with clean data.

About Code Description Lookup Tables

Code description lookup tables are an important part of any database. They define the choices available for codified fields and supply the human readable descriptions for display purposes.

However, the naive approach of creating one new database table for each code description set involves a large software complexity overhead.

I have designed and programmed many universal code tables during my career. A universal code table places all of the code tables into a single database table. That single universal database code table hosts as many virtual code tables as desired with no schema changes or coding.