I actually just copied that directly from something I found online... so any clever references are (unfortunately) not my responsibility! 
So, that table is mapping our types to the database types. You can pretty much pull them directly from that first table you posted. We tend to just use "integer" for the main integer number types, but you can try using the more specific types. So, it looks like you would use the following:
I1=TINYINT
I2=SMALLINT
I4=INTEGER
I8=INTEGER? Maybe NUMERIC
Boolean=BIT
Datetime=TIMESTAMP
R4=REAL
R8=DOUBLE
String=VARCHAR
Binary=LONGVARBINARY
Hope this helps,