-- Table: public.pet_aux_animal_documento

-- DROP TABLE public.pet_aux_animal_documento;

CREATE TABLE public.pet_aux_animal_documento
(
    usuario integer NOT NULL,
    filial integer NOT NULL,
    animal integer NOT NULL,
    sequencia integer NOT NULL,
    data_cadastro date NOT NULL,
    hora_cadastro time without time zone NOT NULL,
    usuario_cadastro integer NOT NULL,
    tipo_documento integer NOT NULL,
    extensao character varying(10) COLLATE pg_catalog."default" NOT NULL,
    nome_arquivo character varying(500) COLLATE pg_catalog."default" NOT NULL,
    arquivo bytea NOT NULL,
    CONSTRAINT pk_pet_aux_animal_documento PRIMARY KEY (usuario, filial, animal, sequencia),
    CONSTRAINT fk_pet_aux_animal_documento_animal FOREIGN KEY (animal)
        REFERENCES public.pet_animal (codigo) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION,
    CONSTRAINT fk_pet_aux_animal_tipo_documento FOREIGN KEY (tipo_documento)
        REFERENCES public.pet_animal_tipo_documento (codigo) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION
)

TABLESPACE pg_default;

ALTER TABLE public.pet_aux_animal_documento
    OWNER to postgres;

GRANT ALL ON TABLE public.pet_animal_documento TO postgres;