import sqlite3
from typing import Dict


def get_types(conn: sqlite3.Connection) -> Dict[str, str]:
    """Get types for each column in the database.

    :param conn: Connection to the database
    :type conn: sqlite3.Connection
    :return: A dictionary mapping names of columns to SQL names of their types
    :rtype: Dict[str, str]
    """

    types = {}
    cur = conn.cursor()
    cur.execute("PRAGMA table_info(data)")
    data = cur.fetchall()
    for row in data:
        types[row[1]] = row[2]
    return types