ALTER TABLE AVALIACAOPRATO MODIFY NRCARDAPIO VARCHAR2(10) NULL
/

CREATE TABLE AVALIACAOSERVICO (
   NRAVALIACAOSERVICO 	NUMBER 		NOT NULL,
   IDCONSUMO 		VARCHAR2(2) 	NOT NULL,
   CDFILCENTPME 		VARCHAR2(4) 	NULL,
   CDTIPOCARD 		VARCHAR2(10) 	NULL,
   NRCARDPME 		VARCHAR2(10) 	NULL,
   CDFILIAL 		VARCHAR2(4) 	NOT NULL,
   CDSERVFILI 		VARCHAR2(5) 	NOT NULL,
   NRCARDAPIO 		VARCHAR2(10) 	NULL,
   CDDIETPAD 		VARCHAR2(3) 	NULL,
   VRAVALIACAOSERVICO 	FLOAT(126) 	NULL,
   DSAVALIACAOSERVICO 	VARCHAR2(2000) 	NULL,
   NRUSUARIOAPP 		NUMBER 		NULL,
   DTCARDAPIO 		DATE 		NULL,
   NRORG                       	NUMBER 		DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL,
   IDATIVO                    	VARCHAR2(1)     	DEFAULT 'S' NOT NULL
	CONSTRAINT CKC_IDATIVO_AVALIACAOSERV  CHECK (IDATIVO IN ('S','N')),
   DTINCLUSAO             	DATE                   	NULL,
   DTULTATU                  	DATE                  	NULL,
   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 PK_AVALIACAOSERVICO PRIMARY KEY (NRAVALIACAOSERVICO)
)