Blame | Last modification | View Log | Download | RSS feed
create table WS_CROSS_RAGGR_ENTI
(
ID_RAGG NUMBER not null,
ID_ENTE NUMBER not null
)
tablespace ®MON_TBS_NAME
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table WS_CROSS_RAGGR_ENTI
add constraint PK_CROSS_RAGGR_ENTI primary key (ID_RAGG, ID_ENTE)
using index
tablespace ®MON_TBS_NAME
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table WS_CROSS_RAGGR_ENTI
add constraint FK_CROSS_ENTI_2 foreign key (ID_ENTE)
references WS_ENTI (ID);
alter table WS_CROSS_RAGGR_ENTI
add constraint FK_CROSS_RAGGR_1 foreign key (ID_RAGG)
references WS_RAGGR_ENTI (ID_RAGGR);