Subversion Repositories Sigmater

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
6 Andrea 1 
create table WS_ISTANZE_APPL
2 
(
3 
  ISTANZA_APPL_ID NUMBER(10) not null,
4 
  APPLICAZIONE_ID NUMBER(10) not null,
5 
  ISTANZA_APPL    VARCHAR2(255) not null,
6 
  URL_APPL        VARCHAR2(255),
7 
  URL_WS          VARCHAR2(255)
8 
)
9 
tablespace &REGMON_TBS_NAME
10 
  pctfree 10
11 
  initrans 1
12 
  maxtrans 255
13 
  storage
14 
  (
15 
    initial 64K
16 
    minextents 1
17 
    maxextents unlimited
18 
  );
19 
alter table WS_ISTANZE_APPL
20 
  add constraint PK_WS_ISTANZE_APPL primary key (ISTANZA_APPL_ID)
21 
  using index
22 
  tablespace &REGMON_TBS_NAME
23 
  pctfree 10
24 
  initrans 2
25 
  maxtrans 255
26 
  storage
27 
  (
28 
    initial 64K
29 
    minextents 1
30 
    maxextents unlimited
31 
  );
32 
alter table WS_ISTANZE_APPL
33 
  add constraint FK_WS_ISTAN_REFERENCE_WS_APPLI foreign key (APPLICAZIONE_ID)
34 
  references WS_APPLICAZIONI (COD_APPLICAZIONE);
35