fixed datatype for 'id'