Blame | Last modification | View Log | Download | RSS feed
create table WS_LOG_EVENTI
(
LOG_EVENTI_ID NUMBER(20) not null,
EVENTO_ID VARCHAR2(30),
TIME VARCHAR2(100),
OPERATORE VARCHAR2(50),
DESCRIZIONE VARCHAR2(100),
SUBJECT VARCHAR2(100),
DESCRIZIONE_BLOB CLOB,
COD_PROFILO_U NUMBER(10)
)
tablespace ®MON_TBS_NAME
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table WS_LOG_EVENTI
add constraint PK_WS_LOG_EVENTI primary key (LOG_EVENTI_ID)
using index
tablespace ®MON_TBS_NAME
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table WS_LOG_EVENTI
add constraint FK_WS_LOG_E_REF_93_WS_EVENT foreign key (EVENTO_ID)
references WS_EVENTI (EVENTO_ID);
alter table WS_LOG_EVENTI
add constraint FK_WS_LOG_E_WS_PROF_UTENTE foreign key (COD_PROFILO_U)
references WS_PROFILI_UTENTE (COD_PROFILO_U);