changed all table PKs to 'id'