CREATE TABLE FRIGOBAR (
    ID_FRIGOBAR        INTEGER NOT NULL,
    FK_PRODUTO INTEGER, 
    DATA_HORA_LANCTO  TIMESTAMP,
    QTD           INTEGER,
    NUM_QUARTO       INTEGER,
    NUM_NFCE INTEGER
);


ALTER TABLE FRIGOBAR ADD CONSTRAINT PK_FRIGOBAR PRIMARY KEY (ID_FRIGOBAR);

CREATE GENERATOR GEN_FRIGOBAR;

ALTER TABLE FRIGOBAR ADD VAL_UNITARIO NUMERIC(18,2);
ALTER TABLE FRIGOBAR ADD TOTAL_ITEM NUMERIC(18,2);


CREATE TABLE FRIGOBAR_NFCE (
    NUM_NFCE       INTEGER NOT NULL,
    CHAVE_NFCE       VARCHAR(50),
    PROTOCOLO_NFCE   VARCHAR(50),
    PROTOCOLO_NFCE_CANC   VARCHAR(50)
);

ALTER TABLE FRIGOBAR_NFCE ADD CONSTRAINT PK_FRIGOBAR_NFCE PRIMARY KEY (NUM_NFCE);



ALTER TABLE FRIGOBAR_NFCE ADD DATAHORA TIMESTAMP;
ALTER TABLE FRIGOBAR_NFCE ADD VALORTOTAL NUMERIC(15,2) ;