CREATE TABLE public.bas_api_adm_licenca
(
    filial integer NOT NULL,
    usuario_api character varying(100) NOT NULL,
    senha_api character varying(100) NOT NULL,
    host_api character varying(100) NOT NULL,
    CONSTRAINT pk_bas_api_adm_licenca PRIMARY KEY (filial),
    CONSTRAINT fk_bas_api_adm_licenca_filial FOREIGN KEY (filial)
        REFERENCES public.bas_filial (codigo) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT
)

TABLESPACE pg_default;

ALTER TABLE public.bas_api_adm_licenca
    OWNER to postgres;