assign ID to generated column