Hi Sohail,
If it is the case even @ManyToOne has same constarint on foreign key like
"Table A contains a foreign key to table B. The foreign key column name is formed as the concatenation
of the following: the name of the relationship property or field of entity A; "_"; the
name of the primary key column in table B. The foreign key column has the same type as the
primary key of table B." refer to section
2.1.8.3.2 of ejb-3_0-fr-spec-persistence.
so for my knowledge Both B,C are correct.
Correct me If I am wrong.
Thanks,
Deepak