Blame | Last modification | View Log | Download | RSS feed
create table WS_CROSS_ATTRIBUTI_FUNZ
(
COD_FUNZIONE NUMBER(10) not null,
COD_ATTRIBUTO NUMBER(10) not null,
VALORE VARCHAR2(255)
)
tablespace ®MON_TBS_NAME
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table WS_CROSS_ATTRIBUTI_FUNZ
add constraint PK_WS_CROSS_ATTRIBUTI_FUNZ primary key (COD_ATTRIBUTO, COD_FUNZIONE)
using index
tablespace ®MON_TBS_NAME
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table WS_CROSS_ATTRIBUTI_FUNZ
add constraint FK_FUNZ_ATTR2ATTR foreign key (COD_ATTRIBUTO)
references WS_ATTRIBUTI_FUNZIONE (COD_ATTRIBUTO);
alter table WS_CROSS_ATTRIBUTI_FUNZ
add constraint FK_FUNZ_ATTR2FUNZ foreign key (COD_FUNZIONE)
references WS_FUNZIONI (COD_FUNZIONE);
create index I_FUNZATTR_ATTRIBUTI on WS_CROSS_ATTRIBUTI_FUNZ (COD_ATTRIBUTO)
tablespace ®MON_TBS_NAME
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
create index I_FUNZATTR_FUNZIONI on WS_CROSS_ATTRIBUTI_FUNZ (COD_FUNZIONE)
tablespace ®MON_TBS_NAME
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);