CREATE TABLE INTG_VIAEMAIL 
( 
	DSSERVEMAIL 	VARCHAR2(40), 
	DSLOGINEMAIL 	VARCHAR2(120), 
	CDSENHAEMAIL 	VARCHAR2(20), 
	NRPORTAEMAIL 	VARCHAR2(6), 
	IDUTTLSEMAIL 	VARCHAR2(1) 	DEFAULT 'N' NOT NULL, 
	IDUTSSLEMAIL 	VARCHAR2(1) 	DEFAULT 'N' NOT NULL, 
	NRPERIODEMAIL 	VARCHAR2(3), 
	DSARQEXTENSAO 	VARCHAR2(20),
	DIRPHP 			VARCHAR2(100), 
	JENKINSPATH 	VARCHAR2(200), 
	CALLSERVPATH 	VARCHAR2(200), 
	NRORG           NUMBER 	      	DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') 		NOT NULL,
    IDATIVO         VARCHAR2(1)     DEFAULT 'S'										NOT NULL,
    DTINCLUSAO      DATE            DEFAULT SYSDATE,
    DTULTATU        DATE            DEFAULT SYSDATE,
    NRORGINCLUSAO   NUMBER          DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg')		NULL,
    CDOPERINCLUSAO  VARCHAR2(12)    DEFAULT '1' 									NULL,
    NRORGULTATU     NUMBER          DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg')		NULL,
    CDOPERULTATU    VARCHAR2(12)    DEFAULT '1',
		CONSTRAINT CKC_IDATIVO_INTG_VIAEMAIL CHECK (IDATIVO IN ('S','N'))
)
/