code: def __extract_col_type_from_tabledata(table_data):
          
  
          typename_table = {
              typepy.Typecode.INTEGER: "INTEGER",
              typepy.Typecode.REAL_NUMBER: "REAL",
              typepy.Typecode.STRING: "TEXT",
          }
  
          return dict(
              [
                  [col_idx, typename_table.get(col_dp.typecode, "TEXT")]
                  for col_idx, col_dp in enumerate(table_data.column_dp_list)
              ]
          )
docs: Extract data type name for each column as SQLite names.
  
          :param tabledata.TableData table_data:
          :return: { column_number : column_data_type }
          :rtype: dictionary