def get_indexes(cursor, table_name):
    cursor.execute("SHOW INDEX FROM %s" % quote_name(table_name))
    indexes = {}
    for row in cursor.fetchall():
        indexes[row[4]] = {'primary_key': (row[2] == 'PRIMARY'), 'unique': not bool(row[1])}
    return indexes
The Repair Details API includes the shipment information
dataset/ETHPy150Open AppScale/appscale/AppServer/lib/django-0.96/django/db/backends/mysql_old/introspection.py/get_indexes--crossover with--dataset/ETHPy150Open filipp/py-gsxws/gsxws/repairs.py/Repair.details