Subversion Repositories Sigmater

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
6 Andrea 1 
create table WS_PROFILI_EVENTO
2 
(
3 
  EVENTO_ID     VARCHAR2(30) not null,
4 
  COD_PROFILO_U NUMBER(10) not null,
5 
  TIPO_NOTIFICA VARCHAR2(10),
6 
  EMAIL         VARCHAR2(100)
7 
)
8 
tablespace &REGMON_TBS_NAME
9 
  pctfree 10
10 
  initrans 1
11 
  maxtrans 255
12 
  storage
13 
  (
14 
    initial 64K
15 
    minextents 1
16 
    maxextents unlimited
17 
  );
18 
alter table WS_PROFILI_EVENTO
19 
  add constraint PK_WS_PROFILI_EVENTO primary key (EVENTO_ID, COD_PROFILO_U)
20 
  using index
21 
  tablespace &REGMON_TBS_NAME
22 
  pctfree 10
23 
  initrans 2
24 
  maxtrans 255
25 
  storage
26 
  (
27 
    initial 64K
28 
    minextents 1
29 
    maxextents unlimited
30 
  );
31 
alter table WS_PROFILI_EVENTO
32 
  add constraint FK_WS_PROFI_REF_79_WS_EVENT foreign key (EVENTO_ID)
33 
  references WS_EVENTI (EVENTO_ID);
34 
alter table WS_PROFILI_EVENTO
35 
  add constraint FK_WS_PROFI_REF_83_WS_PROFI foreign key (COD_PROFILO_U)
36 
  references WS_PROFILI_UTENTE (COD_PROFILO_U);
37