Details | Last modification | View Log | RSS feed
Rev | Author | Line No. | Line |
---|---|---|---|
6 | Andrea | 1 | create table WS_RUOLI |
2 | ( |
||
3 | COD_PROFILO_U NUMBER(10) not null, |
||
4 | USERNAME VARCHAR2(20) not null, |
||
5 | FLG_NOTIFICA_EVENTI NUMBER(1) |
||
6 | ) |
||
7 | tablespace ®MON_TBS_NAME |
||
8 | pctfree 10 |
||
9 | initrans 1 |
||
10 | maxtrans 255 |
||
11 | storage |
||
12 | ( |
||
13 | initial 64K |
||
14 | minextents 1 |
||
15 | maxextents unlimited |
||
16 | ); |
||
17 | alter table WS_RUOLI |
||
18 | add constraint PK_WS_RUOLI primary key (COD_PROFILO_U, USERNAME) |
||
19 | using index |
||
20 | tablespace ®MON_TBS_NAME |
||
21 | pctfree 10 |
||
22 | initrans 2 |
||
23 | maxtrans 255 |
||
24 | storage |
||
25 | ( |
||
26 | initial 64K |
||
27 | minextents 1 |
||
28 | maxextents unlimited |
||
29 | ); |
||
30 | alter table WS_RUOLI |
||
31 | add constraint FK_WS_RUOLI_REF_13_WS_PROFI foreign key (COD_PROFILO_U) |
||
32 | references WS_PROFILI_UTENTE (COD_PROFILO_U); |
||
33 | alter table WS_RUOLI |
||
34 | add constraint FK_WS_RUOLI_REF_9_WS_UTENT foreign key (USERNAME) |
||
35 | references WS_UTENTI (USERNAME); |
||
36 |