Identifier dependency mapping with hibernate...

P

periket2000

Hi guys, I'd made some mapping with hibernate, but now, I've found a
problem when I've tried to map a table with an identifier dependency,
how can I map it??? This are the tables:

/*==============================================================*/
/* Table: DIMENSION */
/*==============================================================*/
create table DIMENSION (
DIM_ID INTEGER not null,
FNT_ID INTEGER,
DIM_NOMBRE VARCHAR2(100) not null,
DIM_TIPO VARCHAR2(100),
DIM_DESC VARCHAR2(2048),
constraint PK_DIMENSION primary key (DIM_ID),
constraint AK_CAMPO_UNIQUE_DIMENSIO unique (DIM_NOMBRE),
constraint FK_DIMENSION_FUENTE foreign key (FNT_ID)
references FUENTE (FNT_ID)
);

/*==============================================================*/
/* Table: DIM_ATRIBUTOS */
/*==============================================================*/
create table DIM_ATRIBUTOS (
DIM_ID INTEGER not null,
ATRIB_ID INTEGER not null,
ATRIB_NOMBRE VARCHAR2(100) not null,
ATRIB_VALORES VARCHAR2(2048),
ATRIB_DESC VARCHAR2(2048),
ATRIB_NIVEL INTEGER,
constraint PK_DIM_ATRIBUTOS primary key (DIM_ID, ATRIB_ID),
constraint AK_CAMPO_UNIQUE_DIM_ATRI unique (ATRIB_NOMBRE),
constraint "FK_DIM_ATRI-DIM" foreign key (DIM_ID)
references DIMENSION (DIM_ID)
);

Regards.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
474,432
Messages
2,571,680
Members
48,796
Latest member
Greg L.

Latest Threads

Top