completed validation for composite primary key like behavior