CREATE TABLE IF NOT EXISTS public.ctl_aux_protocolo
(
    usuario integer NOT NULL,
	
    protocolo integer NOT NULL,
	
	data_cadastro date NOT NULL, 
    hora_cadastro time without time zone NOT NULL,
	
	usuario_protocolo_codigo integer NOT NULL,
	usuario_protocolo_nome character varying NOT NULL,
	
	problema_codigo integer NOT NULL,
	problema_descricao character varying NOT NULL,
	
	setor_codigo integer NOT NULL,
	setor_descricao character varying NOT NULL,
	
	situacao character varying NOT NULL,
	descricao_resumida character varying NOT NULL,
    observacao character varying NOT NULL,
	
    CONSTRAINT pk_ctl_aux_protocolo PRIMARY KEY (usuario, protocolo)
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.ctl_aux_protocolo
    OWNER to postgres;