Hi,

What is the recommended way to map the following:

A User can be Approved,Rejected, Pending etc.

It is possible that more status Codes will be added at some stage.

How should I map this?

Can hbm2java be used to do this ?

Thanks

At least 2 tables:

UserTable

with these properties:
id, name,..., status_id

StatusTable

with at least these properties:
id, description (pending,approved,etc)

Where, id is the key in table StatusTable and a foreign key to UserTable through status_id.


I never used HBM2Java but I think it would work

seemed to fit the bill



Thanks