remove index flags and duplicate PKs
map sequences for primary keys