[Edi]

Paradox, take a look at the Dom3DB. Once you take a look at the BaseU page and the glossary, the structure should be fairly clear for you. It'll be a lot easier to also plan the rest of the SQL DB that way.

The way regeneration works is a percentage of hit points, rounded up (so HP 10 is regen 1 and HP 11 is regen 2 etc). The percentages weren't too difficult to figure out from the units. Resistances, forge bonuses and other such are also percentages, which means they are between 0 and 1 after you strip the spreadsheet formatting out. All special abilities that are either on or off (like forest, mountain and swamp survival or flying) are 1 or 0.

Not quite all abilities are listed (such as Belial's corrupt commander, those would be in the Special column, which has all sorts of things that did not warrant their own category.

Awe values should default to -1 (unit does not have it) in the SQL DB and fear should default to null.