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.
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.