CREATE TABLE INFORMATIVOMYMENU (
  NRINFORMATIVO NUMBER(10) NOT NULL, 
  CDFILIAL VARCHAR2(4) NOT NULL, 
  NRLOCALPESQ NUMBER(10) DEFAULT NULL NULL, 
  DSTITULO VARCHAR2(2000) NOT NULL, 
  TXCONTEUDO CLOB DEFAULT NULL NULL, 
  URLIMAGEM VARCHAR2(2000) DEFAULT NULL NULL, 
  DTEXPIRA DATE DEFAULT NULL NULL, 
  IDEXIBICAO VARCHAR2(1) DEFAULT 'A' NOT NULL, 
  DTINFORMATIVO DATE NOT NULL, 
  NRORG NUMBER(10) DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL, 
  IDATIVO VARCHAR2(1) DEFAULT 'S' NOT NULL, 
  DTINCLUSAO DATE DEFAULT NULL NULL, 
  DTULTATU DATE DEFAULT NULL NULL, 
  NRORGINCLUSAO NUMBER(10) DEFAULT 1 NULL, 
  CDOPERINCLUSAO VARCHAR2(12) DEFAULT '1' NULL, 
  NRORGULTATU NUMBER(10) DEFAULT 1 NULL, 
  CDOPERULTATU VARCHAR2(12) DEFAULT '1' NULL,
  CONSTRAINT PK_INFORMATIVOMYMENU PRIMARY KEY(NRINFORMATIVO)
)
/
ALTER TABLE INFORMATIVOMYMENU ADD CONSTRAINT CKC_IDEXIBICAO_INFORMATIVOMYM CHECK (IDEXIBICAO IN ('A', 'M', 'Q'))
/
ALTER TABLE INFORMATIVOMYMENU ADD CONSTRAINT CKC_IDATIVO_INFORMATIVOMYMENU CHECK (IDATIVO IN ('S', 'N'))