Hello, I have a table that represents vacations of a user. The table is non-normalized, and there is an embedded list in it. Each year, the user can breake his vacation in 1 to 3 periods. Each period have a beginning an end and a number of days. The talbe is like this (only important columns shown):
VACATION_TABLE: USER_ID VARCHAR2(8) BEGINNING_1ST_PERIOD DATE END_1ST_PERIOD DATE NUM_DAYS_1ST_PERIOD NUMBER(2) BEGINNING_2ND_PERIOD DATE END_2ND_PERIOD DATE NUM_DAYS_2ND_PERIOD NUMBER(2) BEGINNING_3RD_PERIOD DATE END_3RD_PERIOD DATE NUM_DAYS_3RD_PERIOD NUMBER(2)
I whant to map the periods as an embedded list in my Vcation entity. Is there a way to do that with Hibernate?
Thanks for any idea.
|