12 lines
429 B
SQL
12 lines
429 B
SQL
create table dwh.MNP_DW_REPORT_CAPACITAEVASIONE
|
|
(
|
|
MESE VARCHAR2(8) not null,
|
|
GIORNI_LAVORATIVI NUMBER,
|
|
RICHIESTE_PRESEINCARICO NUMBER,
|
|
RICHIESTE_SCARTATE_WAITLIST NUMBER,
|
|
RICHIESTE_SCARTATE_MANPROGR NUMBER
|
|
) TABLESPACE TAB_SMALL;
|
|
|
|
alter table dwh.MNP_DW_REPORT_CAPACITAEVASIONE
|
|
add constraint PK_MNP_REPORT_CAPACITAEVASIONE primary key (MESE)
|
|
using index tablespace TAB_IDX_SMALL; |