Subversion Repositories Sigmater

Rev

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 &REGMON_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 &REGMON_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);