Subversion Repositories Sigmater

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
6 Andrea 1 
create table WS_CROSS_RAGGR_ENTI
2 
(
3 
  ID_RAGG NUMBER not null,
4 
  ID_ENTE NUMBER not null
5 
)
6 
tablespace &REGMON_TBS_NAME
7 
  pctfree 10
8 
  initrans 1
9 
  maxtrans 255
10 
  storage
11 
  (
12 
    initial 64K
13 
    minextents 1
14 
    maxextents unlimited
15 
  );
16 
alter table WS_CROSS_RAGGR_ENTI
17 
  add constraint PK_CROSS_RAGGR_ENTI primary key (ID_RAGG, ID_ENTE)
18 
  using index
19 
  tablespace &REGMON_TBS_NAME
20 
  pctfree 10
21 
  initrans 2
22 
  maxtrans 255
23 
  storage
24 
  (
25 
    initial 64K
26 
    minextents 1
27 
    maxextents unlimited
28 
  );
29 
alter table WS_CROSS_RAGGR_ENTI
30 
  add constraint FK_CROSS_ENTI_2 foreign key (ID_ENTE)
31 
  references WS_ENTI (ID);
32 
alter table WS_CROSS_RAGGR_ENTI
33 
  add constraint FK_CROSS_RAGGR_1 foreign key (ID_RAGG)
34 
  references WS_RAGGR_ENTI (ID_RAGGR);
35