Blame | Last modification | View Log | Download | RSS feed
create table WS_CROSS_ENTI_UTENTI
(
USERNAME VARCHAR2(20) not null,
ID NUMBER not null
)
tablespace ®MON_TBS_NAME
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table WS_CROSS_ENTI_UTENTI
add constraint PK_CROSS_ENTI_UTENTI primary key (USERNAME, ID)
using index
tablespace ®MON_TBS_NAME
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table WS_CROSS_ENTI_UTENTI
add constraint FK_CROSS_ENTI_1 foreign key (ID)
references WS_ENTI (ID);
alter table WS_CROSS_ENTI_UTENTI
add constraint FK_CROSS_UTENTI_1 foreign key (USERNAME)
references WS_UTENTI (USERNAME);
create index ENTI on WS_CROSS_ENTI_UTENTI (ID)
tablespace ®MON_TBS_NAME
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
create index UTENTI on WS_CROSS_ENTI_UTENTI (USERNAME)
tablespace ®MON_TBS_NAME
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);