CREATE TABLE ADMINCARTAO (
	CDADMINCART 	  VARCHAR2(20) NOT NULL,
	NMRAZADMCART 	  VARCHAR2(100) NULL,
	DSENDERECO 		  VARCHAR2(50) NULL,
	NRENDERECO 		  VARCHAR2(10) NULL,
	DSCOMPLEMENTO 	  VARCHAR2(100) NULL,
	DSLOGRADOURO 	  VARCHAR2(40) NULL,
	CDPAIS 			  VARCHAR(4) NULL,
	SGESTADO 		  VARCHAR2(2) NULL,
	CDMUNICIPIO 	  VARCHAR2(4) NULL,
	CDBAIRRO 		  VARCHAR2(10) NULL,
	NRCEP 			  VARCHAR2(15) NULL,
	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_ADMINCARTAO CHECK (IDATIVO IN ('S','N')),
		CONSTRAINT PK_ADMINCARTAO PRIMARY KEY (CDADMINCART)
)
/