-- Table: pet_agenda_item
-- DROP TABLE pet_agenda_item;

CREATE TABLE pet_agenda_item(

    agenda integer NOT NULL,
    filial integer NOT NULL,
    servico integer NOT NULL,
    valor numeric(18,6) NOT NULL,

   CONSTRAINT pk_pet_agenda_item PRIMARY KEY (agenda, servico),

    CONSTRAINT fk_pet_agenda_item_agenda FOREIGN KEY (agenda)
        REFERENCES pet_agenda (sequencia) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION,

    CONSTRAINT fk_pet_agenda_item_servico FOREIGN KEY (filial, servico)
        REFERENCES pro_produto (filial_pro, codigo) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION

)

TABLESPACE pg_default;

ALTER TABLE pet_agenda_item OWNER to postgres;
GRANT ALL ON TABLE pet_agenda_item TO postgres;