def METHOD_NAME(self, index_definition):
    index_definition = index_definition.lower()
    is_unique = "unique" in index_definition
    m = INDEX_DEFINITION_PATTERN.search(index_definition)
    return {
        "columns": m.group(2),
        "unique": is_unique,
        "type": m.group(1),
    }