def get_schema_table_column_triples(database):
    """
    Return a list of all (schema_name, table_name, column_name)-combinations.

    *database* must have the same structure as obtained from
    :func:`get_database`.
    """
    res = []
    for schema in database:
        schema_name = schema['datapackage']
        for table in schema['resources']:
            table_name = table['name']
            for column in table['fields']:
                res.append((schema_name, table_name, column['name']))
    return res
