Hibernate AutoIncrement non primary key based on f

Question

I'm working with a table that has an integer column and a foreign key. This integer has to be incremental, but it has to start again in 1 when the foreign key is changed.

Example:

Foreign 1, int col : 1 , 2 , 3...

Foreign 2, int col: 1 ,2 , 3, 4, 5 ...

Foreign 3, int col: 1, 2

This is my mapping so far: (Of course this doesn't does the trick)

public class Documento implements ModelEntity{

private static final long serialVersionUID = 11233L;

/*PK*/
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.AUTO)
private Integer id;

/*FK*/
@Man yToOne(fetch = FetchType.EAGER)
@JoinColumn(name = "type_id")
@Cascade({})
private Type type;

/* This is the value that has to be AUTO-INCREMENT BASED ON FOREIGN_ID */
@Basic
private Integer idx;


}    

Is there a way to do this with Hibernate (Oracle DB) ?