Is there a way to map this schema by using hibernate annotations?

Of course.
I would advise you to use reverse engineering from an existing schema,
otherwise it could be tricky if you are new to annotations.

Thank you; but I want to map it to a specific class structure;
Lets take just the item and the ItemLocale classes;
suppose I have defined the classes like this:

public class Item{
private Integer id;
private Integer SellerId;
private Integer Price;

// Geters and Setters
}

and the ItemLocale class as follows (extending Item class)

public class ItemLocale extends Item {
private Culture culture;
private String name;
private String description;

// Geters and Setters
}

is it possible to map this to the db schema; the reverse Enginnering tool does not help in this case :)

Are you really sure ItemLocal has to extend Item?
This is not reflected by your schema, you're going to inherited the other properties too.

The class structure is not really different than the schema. If you have the following Annotation on the Item class; then you get the schema I mentioned:
@Inheritance(strategy=InheritanceType.JOINED)

but the problem is that the ItemLocale class has a different primary key (keys) than ist superclass (Item).

Is there a way to override the primary keys? How can I map the schema to this class structure?

thanks in advance

Ok, now I understand you problem better;
unfortunately I don't have an answer, I should try with @IdClass, but I'm not sure it is possible.

You can't change either the classes or the shema? I've had a similar problem also for i18N
but I solved it using Maps; you could add something like this to your Item:

or

The second results in your mapping, but I prefer the first one as it generates java code I like better. I don't think you could make ItemLocale extend Item in this case though.

Sorry if I am in the worst, but I think that you don´t do it. For get it you should duplicate in the database every field of the table Item.

But if you what to get the fields of Item you should to map this on Item_Locale


Then you only need to get the Item date with the getter method.