29 lines
647 B
SQL
29 lines
647 B
SQL
--Eseguire come utente MNP
|
|
|
|
-- TABELLA NOTIFICA DBCFX --
|
|
|
|
CREATE TABLE MNP_DBCFX_DPP_OUT (
|
|
UNIQUE_ID NUMBER NOT NULL,
|
|
ID_RICHIESTA VARCHAR2(23) NOT NULL,
|
|
DATA_CREAZIONE DATE DEFAULT SYSDATE NOT NULL,
|
|
DATA_NOTIFICA DATE,
|
|
DA_SCODARE NUMBER(1) NOT NULL,
|
|
PROCESSO VARCHAR2(1) NOT NULL,
|
|
DCO VARCHAR2(10) NOT NULL,
|
|
MSISDN VARCHAR2(13) NOT NULL,
|
|
CODICE_OPERATORE_RECIPIENT VARCHAR2(4) NOT NULL,
|
|
RGN_RECIPIENT VARCHAR2(3) NOT NULL
|
|
)
|
|
TABLESPACE TAB_HUGE_2;
|
|
|
|
ALTER TABLE MNP_DBCFX_DPP_OUT ADD
|
|
CONSTRAINT PK_MNP_DBCFX_DPP_OUT
|
|
PRIMARY KEY
|
|
(UNIQUE_ID)
|
|
USING INDEX
|
|
TABLESPACE TAB_IDX_HUGE_2_2;
|
|
|
|
|
|
-- SEQUENCE --
|
|
|
|
CREATE SEQUENCE SEQ_DBCFX_DPP_OUT; |