DROP TYPE PRATOS_MYMENU_TABLE
/

DROP TYPE PRATOS_MYMENU_TYPE
/

CREATE TYPE PRATOS_MYMENU_TYPE AS OBJECT
  (
   NRGRUPOPRATOPESQ NUMBER,
   NMGRUPOPRATOPESQ VARCHAR2(40),
   NRCARDPME        VARCHAR2(10),
   NRCARDAPIO       VARCHAR2(10),
   CDTIPOPRAT       VARCHAR2(2),
   NMTIPOPRAT       VARCHAR2(40),
   CDFILAUXPRAT     VARCHAR2(04),
   CDPRATO          VARCHAR2(10),
   NMPRATO          VARCHAR2(80),
   NRSEQPRATCAR     NUMBER(3),
   NRORDPRATCAR     NUMBER(15,5),
   CALORIAS_KCAL    FLOAT(126),
   URL_FOTOPRATO    VARCHAR2(2000),
   BLOB_FOTOPRATO   BLOB,
   NRFOTOPRATOBLOB  NUMBER,
   VRAVALIACAO      FLOAT(126),
   QTAVALIACAO      NUMBER,
   IDTIPORECEITA    VARCHAR2(1),
   DSPRATO          VARCHAR2(250),
   IDGLUTEN         VARCHAR2(1),
   IDLACTOSE        VARCHAR2(1),
   IDCONCNFMES      VARCHAR2(1),
   IDRESERVAMYMENU  VARCHAR2(1),
   CDMEDICASE       VARCHAR2(5),
   NMMEDICASE       VARCHAR2(40),
   QTMEDICASE       FLOAT(126),
   IDOPCCNFMES      VARCHAR2(1)
  )
/


CREATE TYPE PRATOS_MYMENU_TABLE AS TABLE OF PRATOS_MYMENU_TYPE
/