Blame | Last modification | View Log | Download | RSS feed
create table WS_RUOLI
(
COD_PROFILO_U NUMBER(10) not null,
USERNAME VARCHAR2(20) not null,
FLG_NOTIFICA_EVENTI NUMBER(1)
)
tablespace ®MON_TBS_NAME
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table WS_RUOLI
add constraint PK_WS_RUOLI primary key (COD_PROFILO_U, USERNAME)
using index
tablespace ®MON_TBS_NAME
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table WS_RUOLI
add constraint FK_WS_RUOLI_REF_13_WS_PROFI foreign key (COD_PROFILO_U)
references WS_PROFILI_UTENTE (COD_PROFILO_U);
alter table WS_RUOLI
add constraint FK_WS_RUOLI_REF_9_WS_UTENT foreign key (USERNAME)
references WS_UTENTI (USERNAME);