-- -- PostgreSQL database dump -- -- Dumped from database version 11.5 -- Dumped by pg_dump version 11.3 -- Started on 2019-09-23 14:39:37 UTC SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET xmloption = content; SET client_min_messages = warning; SET row_security = off; SET default_tablespace = ''; SET default_with_oids = false; -- -- TOC entry 196 (class 1259 OID 146156) -- Name: auth_group; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.auth_group ( id integer NOT NULL, name character varying(150) NOT NULL ); ALTER TABLE public.auth_group OWNER TO postgres; -- -- TOC entry 197 (class 1259 OID 146159) -- Name: auth_group_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.auth_group_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.auth_group_id_seq OWNER TO postgres; -- -- TOC entry 3525 (class 0 OID 0) -- Dependencies: 197 -- Name: auth_group_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.auth_group_id_seq OWNED BY public.auth_group.id; -- -- TOC entry 198 (class 1259 OID 146161) -- Name: auth_group_permissions; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.auth_group_permissions ( id integer NOT NULL, group_id integer NOT NULL, permission_id integer NOT NULL ); ALTER TABLE public.auth_group_permissions OWNER TO postgres; -- -- TOC entry 199 (class 1259 OID 146164) -- Name: auth_group_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.auth_group_permissions_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.auth_group_permissions_id_seq OWNER TO postgres; -- -- TOC entry 3526 (class 0 OID 0) -- Dependencies: 199 -- Name: auth_group_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.auth_group_permissions_id_seq OWNED BY public.auth_group_permissions.id; -- -- TOC entry 200 (class 1259 OID 146166) -- Name: auth_permission; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.auth_permission ( id integer NOT NULL, name character varying(255) NOT NULL, content_type_id integer NOT NULL, codename character varying(100) NOT NULL ); ALTER TABLE public.auth_permission OWNER TO postgres; -- -- TOC entry 201 (class 1259 OID 146169) -- Name: auth_permission_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.auth_permission_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.auth_permission_id_seq OWNER TO postgres; -- -- TOC entry 3527 (class 0 OID 0) -- Dependencies: 201 -- Name: auth_permission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.auth_permission_id_seq OWNED BY public.auth_permission.id; -- -- TOC entry 202 (class 1259 OID 146171) -- Name: auth_user; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.auth_user ( id integer NOT NULL, password character varying(128) NOT NULL, last_login timestamp with time zone, is_superuser boolean NOT NULL, username character varying(150) NOT NULL, first_name character varying(30) NOT NULL, last_name character varying(150) NOT NULL, email character varying(254) NOT NULL, is_staff boolean NOT NULL, is_active boolean NOT NULL, date_joined timestamp with time zone NOT NULL ); ALTER TABLE public.auth_user OWNER TO postgres; -- -- TOC entry 203 (class 1259 OID 146177) -- Name: auth_user_groups; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.auth_user_groups ( id integer NOT NULL, user_id integer NOT NULL, group_id integer NOT NULL ); ALTER TABLE public.auth_user_groups OWNER TO postgres; -- -- TOC entry 204 (class 1259 OID 146180) -- Name: auth_user_groups_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.auth_user_groups_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.auth_user_groups_id_seq OWNER TO postgres; -- -- TOC entry 3528 (class 0 OID 0) -- Dependencies: 204 -- Name: auth_user_groups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.auth_user_groups_id_seq OWNED BY public.auth_user_groups.id; -- -- TOC entry 205 (class 1259 OID 146182) -- Name: auth_user_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.auth_user_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.auth_user_id_seq OWNER TO postgres; -- -- TOC entry 3529 (class 0 OID 0) -- Dependencies: 205 -- Name: auth_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.auth_user_id_seq OWNED BY public.auth_user.id; -- -- TOC entry 206 (class 1259 OID 146184) -- Name: auth_user_user_permissions; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.auth_user_user_permissions ( id integer NOT NULL, user_id integer NOT NULL, permission_id integer NOT NULL ); ALTER TABLE public.auth_user_user_permissions OWNER TO postgres; -- -- TOC entry 207 (class 1259 OID 146187) -- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.auth_user_user_permissions_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.auth_user_user_permissions_id_seq OWNER TO postgres; -- -- TOC entry 3530 (class 0 OID 0) -- Dependencies: 207 -- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.auth_user_user_permissions_id_seq OWNED BY public.auth_user_user_permissions.id; -- -- TOC entry 208 (class 1259 OID 146189) -- Name: authtoken_token; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.authtoken_token ( key character varying(40) NOT NULL, created timestamp with time zone NOT NULL, user_id integer NOT NULL ); ALTER TABLE public.authtoken_token OWNER TO postgres; -- -- TOC entry 209 (class 1259 OID 146192) -- Name: celery_results_taskresult; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.celery_results_taskresult ( id integer NOT NULL, task_id character varying(255) NOT NULL, status character varying(50) NOT NULL, content_type character varying(128) NOT NULL, content_encoding character varying(64) NOT NULL, result text, date_done timestamp with time zone NOT NULL, traceback text, hidden boolean NOT NULL, meta text, task_args text, task_kwargs text, task_name character varying(255) ); ALTER TABLE public.celery_results_taskresult OWNER TO postgres; -- -- TOC entry 210 (class 1259 OID 146198) -- Name: celery_results_taskresult_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.celery_results_taskresult_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.celery_results_taskresult_id_seq OWNER TO postgres; -- -- TOC entry 3531 (class 0 OID 0) -- Dependencies: 210 -- Name: celery_results_taskresult_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.celery_results_taskresult_id_seq OWNED BY public.celery_results_taskresult.id; -- -- TOC entry 211 (class 1259 OID 146200) -- Name: chamados_anexo; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.chamados_anexo ( id integer NOT NULL, arquivo character varying(100), created_at timestamp with time zone NOT NULL, atendimento_id integer NOT NULL ); ALTER TABLE public.chamados_anexo OWNER TO postgres; -- -- TOC entry 212 (class 1259 OID 146203) -- Name: chamados_anexo_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.chamados_anexo_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.chamados_anexo_id_seq OWNER TO postgres; -- -- TOC entry 3532 (class 0 OID 0) -- Dependencies: 212 -- Name: chamados_anexo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.chamados_anexo_id_seq OWNED BY public.chamados_anexo.id; -- -- TOC entry 213 (class 1259 OID 146205) -- Name: chamados_atendimento; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.chamados_atendimento ( id integer NOT NULL, status_id integer NOT NULL, observacao text NOT NULL, created_at timestamp with time zone NOT NULL, atendente_id integer NOT NULL, chamado_id integer NOT NULL, tipo_atendimento_id integer NOT NULL, pedir_resposta boolean NOT NULL ); ALTER TABLE public.chamados_atendimento OWNER TO postgres; -- -- TOC entry 214 (class 1259 OID 146211) -- Name: chamados_atendimento_categorias; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.chamados_atendimento_categorias ( id integer NOT NULL, atendimento_id integer NOT NULL, categoria_id integer NOT NULL ); ALTER TABLE public.chamados_atendimento_categorias OWNER TO postgres; -- -- TOC entry 215 (class 1259 OID 146214) -- Name: chamados_atendimento_categorias_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.chamados_atendimento_categorias_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.chamados_atendimento_categorias_id_seq OWNER TO postgres; -- -- TOC entry 3533 (class 0 OID 0) -- Dependencies: 215 -- Name: chamados_atendimento_categorias_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.chamados_atendimento_categorias_id_seq OWNED BY public.chamados_atendimento_categorias.id; -- -- TOC entry 216 (class 1259 OID 146216) -- Name: chamados_atendimento_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.chamados_atendimento_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.chamados_atendimento_id_seq OWNER TO postgres; -- -- TOC entry 3534 (class 0 OID 0) -- Dependencies: 216 -- Name: chamados_atendimento_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.chamados_atendimento_id_seq OWNED BY public.chamados_atendimento.id; -- -- TOC entry 217 (class 1259 OID 146218) -- Name: chamados_categoria; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.chamados_categoria ( id integer NOT NULL, descricao character varying(200) NOT NULL, grupo_responsavel_id integer NOT NULL, is_staff boolean NOT NULL, is_active boolean NOT NULL ); ALTER TABLE public.chamados_categoria OWNER TO postgres; -- -- TOC entry 218 (class 1259 OID 146221) -- Name: chamados_categoria_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.chamados_categoria_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.chamados_categoria_id_seq OWNER TO postgres; -- -- TOC entry 3535 (class 0 OID 0) -- Dependencies: 218 -- Name: chamados_categoria_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.chamados_categoria_id_seq OWNED BY public.chamados_categoria.id; -- -- TOC entry 219 (class 1259 OID 146223) -- Name: chamados_categoria_servidores; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.chamados_categoria_servidores ( id integer NOT NULL, categoria_id integer NOT NULL, servidor_id integer NOT NULL ); ALTER TABLE public.chamados_categoria_servidores OWNER TO postgres; -- -- TOC entry 220 (class 1259 OID 146226) -- Name: chamados_categoria_servidores_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.chamados_categoria_servidores_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.chamados_categoria_servidores_id_seq OWNER TO postgres; -- -- TOC entry 3536 (class 0 OID 0) -- Dependencies: 220 -- Name: chamados_categoria_servidores_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.chamados_categoria_servidores_id_seq OWNED BY public.chamados_categoria_servidores.id; -- -- TOC entry 221 (class 1259 OID 146228) -- Name: chamados_chamado; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.chamados_chamado ( id integer NOT NULL, label character varying(100) NOT NULL, descricao text NOT NULL, telefone character varying(11) NOT NULL, prioridade integer NOT NULL, data_abertura timestamp with time zone NOT NULL, solicitante_id integer NOT NULL, created_at timestamp with time zone NOT NULL, atendente_id integer, regional_responsavel_id integer, local_atendimento character varying(100), screenshot character varying(100) ); ALTER TABLE public.chamados_chamado OWNER TO postgres; -- -- TOC entry 278 (class 1259 OID 147285) -- Name: chamados_chamado_categorias; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.chamados_chamado_categorias ( id integer NOT NULL, atendimento_id integer, categoria_id integer NOT NULL, chamado_id integer NOT NULL ); ALTER TABLE public.chamados_chamado_categorias OWNER TO postgres; -- -- TOC entry 222 (class 1259 OID 146239) -- Name: chamados_chamado_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.chamados_chamado_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.chamados_chamado_id_seq OWNER TO postgres; -- -- TOC entry 3537 (class 0 OID 0) -- Dependencies: 222 -- Name: chamados_chamado_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.chamados_chamado_id_seq OWNED BY public.chamados_chamado.id; -- -- TOC entry 277 (class 1259 OID 147283) -- Name: chamados_chamadocategoria_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.chamados_chamadocategoria_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.chamados_chamadocategoria_id_seq OWNER TO postgres; -- -- TOC entry 3538 (class 0 OID 0) -- Dependencies: 277 -- Name: chamados_chamadocategoria_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.chamados_chamadocategoria_id_seq OWNED BY public.chamados_chamado_categorias.id; -- -- TOC entry 223 (class 1259 OID 146241) -- Name: chamados_resposta; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.chamados_resposta ( id integer NOT NULL, texto text NOT NULL, atendimento_id integer NOT NULL, created_at timestamp with time zone NOT NULL, autor_id integer ); ALTER TABLE public.chamados_resposta OWNER TO postgres; -- -- TOC entry 224 (class 1259 OID 146247) -- Name: chamados_resposta_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.chamados_resposta_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.chamados_resposta_id_seq OWNER TO postgres; -- -- TOC entry 3539 (class 0 OID 0) -- Dependencies: 224 -- Name: chamados_resposta_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.chamados_resposta_id_seq OWNED BY public.chamados_resposta.id; -- -- TOC entry 225 (class 1259 OID 146249) -- Name: chamados_status; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.chamados_status ( id integer NOT NULL, descricao character varying(100) NOT NULL, priority_level integer NOT NULL, message_level character varying(100) NOT NULL, termina_chamado boolean NOT NULL ); ALTER TABLE public.chamados_status OWNER TO postgres; -- -- TOC entry 226 (class 1259 OID 146252) -- Name: chamados_status_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.chamados_status_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.chamados_status_id_seq OWNER TO postgres; -- -- TOC entry 3540 (class 0 OID 0) -- Dependencies: 226 -- Name: chamados_status_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.chamados_status_id_seq OWNED BY public.chamados_status.id; -- -- TOC entry 227 (class 1259 OID 146254) -- Name: chamados_tipoatendimento; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.chamados_tipoatendimento ( id integer NOT NULL, descricao character varying(200) NOT NULL ); ALTER TABLE public.chamados_tipoatendimento OWNER TO postgres; -- -- TOC entry 228 (class 1259 OID 146257) -- Name: chamados_tipoatendimento_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.chamados_tipoatendimento_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.chamados_tipoatendimento_id_seq OWNER TO postgres; -- -- TOC entry 3541 (class 0 OID 0) -- Dependencies: 228 -- Name: chamados_tipoatendimento_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.chamados_tipoatendimento_id_seq OWNED BY public.chamados_tipoatendimento.id; -- -- TOC entry 229 (class 1259 OID 146259) -- Name: core_calendariomanutencao; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.core_calendariomanutencao ( id integer NOT NULL, data_inicio timestamp with time zone NOT NULL, data_termino timestamp with time zone NOT NULL, ativo boolean NOT NULL ); ALTER TABLE public.core_calendariomanutencao OWNER TO postgres; -- -- TOC entry 230 (class 1259 OID 146262) -- Name: core_calendariomanutencao_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.core_calendariomanutencao_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.core_calendariomanutencao_id_seq OWNER TO postgres; -- -- TOC entry 3542 (class 0 OID 0) -- Dependencies: 230 -- Name: core_calendariomanutencao_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.core_calendariomanutencao_id_seq OWNED BY public.core_calendariomanutencao.id; -- -- TOC entry 231 (class 1259 OID 146264) -- Name: core_lotacao; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.core_lotacao ( id integer NOT NULL, nome character varying(200) NOT NULL, codigo character varying(20) NOT NULL, athenas_id integer, regional_id integer ); ALTER TABLE public.core_lotacao OWNER TO postgres; -- -- TOC entry 232 (class 1259 OID 146267) -- Name: core_lotacao_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.core_lotacao_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.core_lotacao_id_seq OWNER TO postgres; -- -- TOC entry 3543 (class 0 OID 0) -- Dependencies: 232 -- Name: core_lotacao_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.core_lotacao_id_seq OWNED BY public.core_lotacao.id; -- -- TOC entry 233 (class 1259 OID 146269) -- Name: core_lotacao_responsavel; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.core_lotacao_responsavel ( id integer NOT NULL, lotacao_id integer NOT NULL, servidor_id integer NOT NULL ); ALTER TABLE public.core_lotacao_responsavel OWNER TO postgres; -- -- TOC entry 234 (class 1259 OID 146272) -- Name: core_lotacao_responsaveis_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.core_lotacao_responsaveis_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.core_lotacao_responsaveis_id_seq OWNER TO postgres; -- -- TOC entry 3544 (class 0 OID 0) -- Dependencies: 234 -- Name: core_lotacao_responsaveis_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.core_lotacao_responsaveis_id_seq OWNED BY public.core_lotacao_responsavel.id; -- -- TOC entry 235 (class 1259 OID 146274) -- Name: core_regional; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.core_regional ( id integer NOT NULL, nome character varying(200) NOT NULL, athenas_id integer NOT NULL ); ALTER TABLE public.core_regional OWNER TO postgres; -- -- TOC entry 236 (class 1259 OID 146277) -- Name: core_regional_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.core_regional_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.core_regional_id_seq OWNER TO postgres; -- -- TOC entry 3545 (class 0 OID 0) -- Dependencies: 236 -- Name: core_regional_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.core_regional_id_seq OWNED BY public.core_regional.id; -- -- TOC entry 237 (class 1259 OID 146279) -- Name: core_servidor; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.core_servidor ( id integer NOT NULL, nome character varying(200) NOT NULL, cpf character varying(11) NOT NULL, matricula integer NOT NULL, lotacao_id integer, user_id integer, ativo boolean NOT NULL, tipo character varying(1) NOT NULL ); ALTER TABLE public.core_servidor OWNER TO postgres; -- -- TOC entry 238 (class 1259 OID 146282) -- Name: core_servidor_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.core_servidor_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.core_servidor_id_seq OWNER TO postgres; -- -- TOC entry 3546 (class 0 OID 0) -- Dependencies: 238 -- Name: core_servidor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.core_servidor_id_seq OWNED BY public.core_servidor.id; -- -- TOC entry 239 (class 1259 OID 146284) -- Name: django_admin_log; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.django_admin_log ( id integer NOT NULL, action_time timestamp with time zone NOT NULL, object_id text, object_repr character varying(200) NOT NULL, action_flag smallint NOT NULL, change_message text NOT NULL, content_type_id integer, user_id integer NOT NULL, CONSTRAINT django_admin_log_action_flag_check CHECK ((action_flag >= 0)) ); ALTER TABLE public.django_admin_log OWNER TO postgres; -- -- TOC entry 240 (class 1259 OID 146291) -- Name: django_admin_log_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.django_admin_log_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.django_admin_log_id_seq OWNER TO postgres; -- -- TOC entry 3547 (class 0 OID 0) -- Dependencies: 240 -- Name: django_admin_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.django_admin_log_id_seq OWNED BY public.django_admin_log.id; -- -- TOC entry 241 (class 1259 OID 146293) -- Name: django_celery_beat_clockedschedule; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.django_celery_beat_clockedschedule ( id integer NOT NULL, clocked_time timestamp with time zone NOT NULL, enabled boolean NOT NULL ); ALTER TABLE public.django_celery_beat_clockedschedule OWNER TO postgres; -- -- TOC entry 242 (class 1259 OID 146296) -- Name: django_celery_beat_clockedschedule_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.django_celery_beat_clockedschedule_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.django_celery_beat_clockedschedule_id_seq OWNER TO postgres; -- -- TOC entry 3548 (class 0 OID 0) -- Dependencies: 242 -- Name: django_celery_beat_clockedschedule_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.django_celery_beat_clockedschedule_id_seq OWNED BY public.django_celery_beat_clockedschedule.id; -- -- TOC entry 243 (class 1259 OID 146298) -- Name: django_celery_beat_crontabschedule; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.django_celery_beat_crontabschedule ( id integer NOT NULL, minute character varying(240) NOT NULL, hour character varying(96) NOT NULL, day_of_week character varying(64) NOT NULL, day_of_month character varying(124) NOT NULL, month_of_year character varying(64) NOT NULL, timezone character varying(63) NOT NULL ); ALTER TABLE public.django_celery_beat_crontabschedule OWNER TO postgres; -- -- TOC entry 244 (class 1259 OID 146304) -- Name: django_celery_beat_crontabschedule_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.django_celery_beat_crontabschedule_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.django_celery_beat_crontabschedule_id_seq OWNER TO postgres; -- -- TOC entry 3549 (class 0 OID 0) -- Dependencies: 244 -- Name: django_celery_beat_crontabschedule_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.django_celery_beat_crontabschedule_id_seq OWNED BY public.django_celery_beat_crontabschedule.id; -- -- TOC entry 245 (class 1259 OID 146306) -- Name: django_celery_beat_intervalschedule; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.django_celery_beat_intervalschedule ( id integer NOT NULL, every integer NOT NULL, period character varying(24) NOT NULL ); ALTER TABLE public.django_celery_beat_intervalschedule OWNER TO postgres; -- -- TOC entry 246 (class 1259 OID 146309) -- Name: django_celery_beat_intervalschedule_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.django_celery_beat_intervalschedule_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.django_celery_beat_intervalschedule_id_seq OWNER TO postgres; -- -- TOC entry 3550 (class 0 OID 0) -- Dependencies: 246 -- Name: django_celery_beat_intervalschedule_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.django_celery_beat_intervalschedule_id_seq OWNED BY public.django_celery_beat_intervalschedule.id; -- -- TOC entry 247 (class 1259 OID 146311) -- Name: django_celery_beat_periodictask; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.django_celery_beat_periodictask ( id integer NOT NULL, name character varying(200) NOT NULL, task character varying(200) NOT NULL, args text NOT NULL, kwargs text NOT NULL, queue character varying(200), exchange character varying(200), routing_key character varying(200), expires timestamp with time zone, enabled boolean NOT NULL, last_run_at timestamp with time zone, total_run_count integer NOT NULL, date_changed timestamp with time zone NOT NULL, description text NOT NULL, crontab_id integer, interval_id integer, solar_id integer, one_off boolean NOT NULL, start_time timestamp with time zone, priority integer, headers text NOT NULL, clocked_id integer, CONSTRAINT django_celery_beat_periodictask_priority_check CHECK ((priority >= 0)), CONSTRAINT django_celery_beat_periodictask_total_run_count_check CHECK ((total_run_count >= 0)) ); ALTER TABLE public.django_celery_beat_periodictask OWNER TO postgres; -- -- TOC entry 248 (class 1259 OID 146319) -- Name: django_celery_beat_periodictask_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.django_celery_beat_periodictask_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.django_celery_beat_periodictask_id_seq OWNER TO postgres; -- -- TOC entry 3551 (class 0 OID 0) -- Dependencies: 248 -- Name: django_celery_beat_periodictask_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.django_celery_beat_periodictask_id_seq OWNED BY public.django_celery_beat_periodictask.id; -- -- TOC entry 249 (class 1259 OID 146321) -- Name: django_celery_beat_periodictasks; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.django_celery_beat_periodictasks ( ident smallint NOT NULL, last_update timestamp with time zone NOT NULL ); ALTER TABLE public.django_celery_beat_periodictasks OWNER TO postgres; -- -- TOC entry 250 (class 1259 OID 146324) -- Name: django_celery_beat_solarschedule; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.django_celery_beat_solarschedule ( id integer NOT NULL, event character varying(24) NOT NULL, latitude numeric(9,6) NOT NULL, longitude numeric(9,6) NOT NULL ); ALTER TABLE public.django_celery_beat_solarschedule OWNER TO postgres; -- -- TOC entry 251 (class 1259 OID 146327) -- Name: django_celery_beat_solarschedule_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.django_celery_beat_solarschedule_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.django_celery_beat_solarschedule_id_seq OWNER TO postgres; -- -- TOC entry 3552 (class 0 OID 0) -- Dependencies: 251 -- Name: django_celery_beat_solarschedule_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.django_celery_beat_solarschedule_id_seq OWNED BY public.django_celery_beat_solarschedule.id; -- -- TOC entry 252 (class 1259 OID 146329) -- Name: django_celery_results_taskresult; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.django_celery_results_taskresult ( id integer NOT NULL, task_id character varying(255) NOT NULL, status character varying(50) NOT NULL, content_type character varying(128) NOT NULL, content_encoding character varying(64) NOT NULL, result text, date_done timestamp with time zone NOT NULL, traceback text, hidden boolean NOT NULL, meta text, task_args text, task_kwargs text, task_name character varying(255) ); ALTER TABLE public.django_celery_results_taskresult OWNER TO postgres; -- -- TOC entry 253 (class 1259 OID 146335) -- Name: django_celery_results_taskresult_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.django_celery_results_taskresult_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.django_celery_results_taskresult_id_seq OWNER TO postgres; -- -- TOC entry 3553 (class 0 OID 0) -- Dependencies: 253 -- Name: django_celery_results_taskresult_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.django_celery_results_taskresult_id_seq OWNED BY public.django_celery_results_taskresult.id; -- -- TOC entry 254 (class 1259 OID 146337) -- Name: django_content_type; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.django_content_type ( id integer NOT NULL, app_label character varying(100) NOT NULL, model character varying(100) NOT NULL ); ALTER TABLE public.django_content_type OWNER TO postgres; -- -- TOC entry 255 (class 1259 OID 146340) -- Name: django_content_type_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.django_content_type_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.django_content_type_id_seq OWNER TO postgres; -- -- TOC entry 3554 (class 0 OID 0) -- Dependencies: 255 -- Name: django_content_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.django_content_type_id_seq OWNED BY public.django_content_type.id; -- -- TOC entry 256 (class 1259 OID 146342) -- Name: django_migrations; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.django_migrations ( id integer NOT NULL, app character varying(255) NOT NULL, name character varying(255) NOT NULL, applied timestamp with time zone NOT NULL ); ALTER TABLE public.django_migrations OWNER TO postgres; -- -- TOC entry 257 (class 1259 OID 146348) -- Name: django_migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.django_migrations_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.django_migrations_id_seq OWNER TO postgres; -- -- TOC entry 3555 (class 0 OID 0) -- Dependencies: 257 -- Name: django_migrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.django_migrations_id_seq OWNED BY public.django_migrations.id; -- -- TOC entry 258 (class 1259 OID 146350) -- Name: django_session; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.django_session ( session_key character varying(40) NOT NULL, session_data text NOT NULL, expire_date timestamp with time zone NOT NULL ); ALTER TABLE public.django_session OWNER TO postgres; -- -- TOC entry 259 (class 1259 OID 146356) -- Name: faq_faq; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.faq_faq ( id integer NOT NULL, question character varying(200) NOT NULL, answer text NOT NULL, grupo_responsavel_id integer NOT NULL ); ALTER TABLE public.faq_faq OWNER TO postgres; -- -- TOC entry 260 (class 1259 OID 146362) -- Name: faq_faq_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.faq_faq_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.faq_faq_id_seq OWNER TO postgres; -- -- TOC entry 3556 (class 0 OID 0) -- Dependencies: 260 -- Name: faq_faq_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.faq_faq_id_seq OWNED BY public.faq_faq.id; -- -- TOC entry 261 (class 1259 OID 146364) -- Name: reversion_revision; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.reversion_revision ( id integer NOT NULL, date_created timestamp with time zone NOT NULL, comment text NOT NULL, user_id integer ); ALTER TABLE public.reversion_revision OWNER TO postgres; -- -- TOC entry 262 (class 1259 OID 146370) -- Name: reversion_revision_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.reversion_revision_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.reversion_revision_id_seq OWNER TO postgres; -- -- TOC entry 3557 (class 0 OID 0) -- Dependencies: 262 -- Name: reversion_revision_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.reversion_revision_id_seq OWNED BY public.reversion_revision.id; -- -- TOC entry 263 (class 1259 OID 146372) -- Name: reversion_version; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.reversion_version ( id integer NOT NULL, object_id character varying(191) NOT NULL, format character varying(255) NOT NULL, serialized_data text NOT NULL, object_repr text NOT NULL, content_type_id integer NOT NULL, revision_id integer NOT NULL, db character varying(191) NOT NULL ); ALTER TABLE public.reversion_version OWNER TO postgres; -- -- TOC entry 264 (class 1259 OID 146378) -- Name: reversion_version_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.reversion_version_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.reversion_version_id_seq OWNER TO postgres; -- -- TOC entry 3558 (class 0 OID 0) -- Dependencies: 264 -- Name: reversion_version_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.reversion_version_id_seq OWNED BY public.reversion_version.id; -- -- TOC entry 265 (class 1259 OID 146380) -- Name: solicitacoes_empresa; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.solicitacoes_empresa ( id integer NOT NULL, razao_social character varying(200) NOT NULL, nome_fantasia character varying(200) NOT NULL, cnpj character varying(14) NOT NULL ); ALTER TABLE public.solicitacoes_empresa OWNER TO postgres; -- -- TOC entry 266 (class 1259 OID 146383) -- Name: solicitacoes_empresa_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.solicitacoes_empresa_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.solicitacoes_empresa_id_seq OWNER TO postgres; -- -- TOC entry 3559 (class 0 OID 0) -- Dependencies: 266 -- Name: solicitacoes_empresa_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.solicitacoes_empresa_id_seq OWNED BY public.solicitacoes_empresa.id; -- -- TOC entry 267 (class 1259 OID 146385) -- Name: solicitacoes_solicitacao; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.solicitacoes_solicitacao ( id integer NOT NULL, label character varying(100) NOT NULL, descricao text NOT NULL, processo_sei character varying(13) NOT NULL, atendida boolean NOT NULL, created_at timestamp with time zone NOT NULL, solicitante_id integer NOT NULL ); ALTER TABLE public.solicitacoes_solicitacao OWNER TO postgres; -- -- TOC entry 268 (class 1259 OID 146391) -- Name: solicitacoes_solicitacao_departamentos; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.solicitacoes_solicitacao_departamentos ( id integer NOT NULL, solicitacao_id integer NOT NULL, lotacao_id integer NOT NULL ); ALTER TABLE public.solicitacoes_solicitacao_departamentos OWNER TO postgres; -- -- TOC entry 269 (class 1259 OID 146394) -- Name: solicitacoes_solicitacao_departamentos_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.solicitacoes_solicitacao_departamentos_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.solicitacoes_solicitacao_departamentos_id_seq OWNER TO postgres; -- -- TOC entry 3560 (class 0 OID 0) -- Dependencies: 269 -- Name: solicitacoes_solicitacao_departamentos_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.solicitacoes_solicitacao_departamentos_id_seq OWNED BY public.solicitacoes_solicitacao_departamentos.id; -- -- TOC entry 270 (class 1259 OID 146396) -- Name: solicitacoes_solicitacao_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.solicitacoes_solicitacao_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.solicitacoes_solicitacao_id_seq OWNER TO postgres; -- -- TOC entry 3561 (class 0 OID 0) -- Dependencies: 270 -- Name: solicitacoes_solicitacao_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.solicitacoes_solicitacao_id_seq OWNED BY public.solicitacoes_solicitacao.id; -- -- TOC entry 271 (class 1259 OID 146398) -- Name: solicitacoes_solicitacaoproduto; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.solicitacoes_solicitacaoproduto ( id integer NOT NULL, processo_licitacao character varying(20) NOT NULL, produto_ti boolean NOT NULL, descricao character varying(200) NOT NULL, possui_estoque_almox boolean NOT NULL, suprimento_fundos boolean NOT NULL, valor numeric(9,2) NOT NULL, previsao_atendimento timestamp with time zone, data_atendimento timestamp with time zone NOT NULL, status integer NOT NULL, empresa_fornecedora_id integer NOT NULL, thread_id integer NOT NULL ); ALTER TABLE public.solicitacoes_solicitacaoproduto OWNER TO postgres; -- -- TOC entry 272 (class 1259 OID 146401) -- Name: solicitacoes_solicitacaoproduto_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.solicitacoes_solicitacaoproduto_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.solicitacoes_solicitacaoproduto_id_seq OWNER TO postgres; -- -- TOC entry 3562 (class 0 OID 0) -- Dependencies: 272 -- Name: solicitacoes_solicitacaoproduto_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.solicitacoes_solicitacaoproduto_id_seq OWNED BY public.solicitacoes_solicitacaoproduto.id; -- -- TOC entry 273 (class 1259 OID 146403) -- Name: solicitacoes_solicitacaoservico; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.solicitacoes_solicitacaoservico ( id integer NOT NULL, processo_licitacao character varying(20) NOT NULL, servico_ti boolean NOT NULL, suprimento_fundos boolean NOT NULL, valor numeric(9,2) NOT NULL, previsao_atendimento timestamp with time zone, data_atendimento timestamp with time zone NOT NULL, status integer NOT NULL, empresa_prestadora_id integer NOT NULL, thread_id integer NOT NULL, descricao character varying(200) NOT NULL ); ALTER TABLE public.solicitacoes_solicitacaoservico OWNER TO postgres; -- -- TOC entry 274 (class 1259 OID 146406) -- Name: solicitacoes_solicitacaoservico_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.solicitacoes_solicitacaoservico_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.solicitacoes_solicitacaoservico_id_seq OWNER TO postgres; -- -- TOC entry 3563 (class 0 OID 0) -- Dependencies: 274 -- Name: solicitacoes_solicitacaoservico_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.solicitacoes_solicitacaoservico_id_seq OWNED BY public.solicitacoes_solicitacaoservico.id; -- -- TOC entry 275 (class 1259 OID 146408) -- Name: solicitacoes_solicitacaothread; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE public.solicitacoes_solicitacaothread ( id integer NOT NULL, descricao text NOT NULL, terminate boolean NOT NULL, created_at timestamp with time zone NOT NULL, atendente_id integer NOT NULL, solicitacao_id integer NOT NULL ); ALTER TABLE public.solicitacoes_solicitacaothread OWNER TO postgres; -- -- TOC entry 276 (class 1259 OID 146414) -- Name: solicitacoes_solicitacaothread_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE public.solicitacoes_solicitacaothread_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.solicitacoes_solicitacaothread_id_seq OWNER TO postgres; -- -- TOC entry 3564 (class 0 OID 0) -- Dependencies: 276 -- Name: solicitacoes_solicitacaothread_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE public.solicitacoes_solicitacaothread_id_seq OWNED BY public.solicitacoes_solicitacaothread.id; -- -- TOC entry 3024 (class 2604 OID 146416) -- Name: auth_group id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.auth_group ALTER COLUMN id SET DEFAULT nextval('public.auth_group_id_seq'::regclass); -- -- TOC entry 3025 (class 2604 OID 146417) -- Name: auth_group_permissions id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.auth_group_permissions ALTER COLUMN id SET DEFAULT nextval('public.auth_group_permissions_id_seq'::regclass); -- -- TOC entry 3026 (class 2604 OID 146418) -- Name: auth_permission id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.auth_permission ALTER COLUMN id SET DEFAULT nextval('public.auth_permission_id_seq'::regclass); -- -- TOC entry 3027 (class 2604 OID 146419) -- Name: auth_user id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.auth_user ALTER COLUMN id SET DEFAULT nextval('public.auth_user_id_seq'::regclass); -- -- TOC entry 3028 (class 2604 OID 146420) -- Name: auth_user_groups id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.auth_user_groups ALTER COLUMN id SET DEFAULT nextval('public.auth_user_groups_id_seq'::regclass); -- -- TOC entry 3029 (class 2604 OID 146421) -- Name: auth_user_user_permissions id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.auth_user_user_permissions ALTER COLUMN id SET DEFAULT nextval('public.auth_user_user_permissions_id_seq'::regclass); -- -- TOC entry 3030 (class 2604 OID 146422) -- Name: celery_results_taskresult id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.celery_results_taskresult ALTER COLUMN id SET DEFAULT nextval('public.celery_results_taskresult_id_seq'::regclass); -- -- TOC entry 3031 (class 2604 OID 146423) -- Name: chamados_anexo id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.chamados_anexo ALTER COLUMN id SET DEFAULT nextval('public.chamados_anexo_id_seq'::regclass); -- -- TOC entry 3032 (class 2604 OID 146424) -- Name: chamados_atendimento id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.chamados_atendimento ALTER COLUMN id SET DEFAULT nextval('public.chamados_atendimento_id_seq'::regclass); -- -- TOC entry 3033 (class 2604 OID 146425) -- Name: chamados_atendimento_categorias id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.chamados_atendimento_categorias ALTER COLUMN id SET DEFAULT nextval('public.chamados_atendimento_categorias_id_seq'::regclass); -- -- TOC entry 3034 (class 2604 OID 146426) -- Name: chamados_categoria id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.chamados_categoria ALTER COLUMN id SET DEFAULT nextval('public.chamados_categoria_id_seq'::regclass); -- -- TOC entry 3035 (class 2604 OID 146427) -- Name: chamados_categoria_servidores id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.chamados_categoria_servidores ALTER COLUMN id SET DEFAULT nextval('public.chamados_categoria_servidores_id_seq'::regclass); -- -- TOC entry 3036 (class 2604 OID 146428) -- Name: chamados_chamado id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.chamados_chamado ALTER COLUMN id SET DEFAULT nextval('public.chamados_chamado_id_seq'::regclass); -- -- TOC entry 3066 (class 2604 OID 147288) -- Name: chamados_chamado_categorias id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.chamados_chamado_categorias ALTER COLUMN id SET DEFAULT nextval('public.chamados_chamadocategoria_id_seq'::regclass); -- -- TOC entry 3037 (class 2604 OID 146430) -- Name: chamados_resposta id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.chamados_resposta ALTER COLUMN id SET DEFAULT nextval('public.chamados_resposta_id_seq'::regclass); -- -- TOC entry 3038 (class 2604 OID 146431) -- Name: chamados_status id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.chamados_status ALTER COLUMN id SET DEFAULT nextval('public.chamados_status_id_seq'::regclass); -- -- TOC entry 3039 (class 2604 OID 146432) -- Name: chamados_tipoatendimento id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.chamados_tipoatendimento ALTER COLUMN id SET DEFAULT nextval('public.chamados_tipoatendimento_id_seq'::regclass); -- -- TOC entry 3040 (class 2604 OID 146433) -- Name: core_calendariomanutencao id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.core_calendariomanutencao ALTER COLUMN id SET DEFAULT nextval('public.core_calendariomanutencao_id_seq'::regclass); -- -- TOC entry 3041 (class 2604 OID 146434) -- Name: core_lotacao id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.core_lotacao ALTER COLUMN id SET DEFAULT nextval('public.core_lotacao_id_seq'::regclass); -- -- TOC entry 3042 (class 2604 OID 146435) -- Name: core_lotacao_responsavel id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.core_lotacao_responsavel ALTER COLUMN id SET DEFAULT nextval('public.core_lotacao_responsaveis_id_seq'::regclass); -- -- TOC entry 3043 (class 2604 OID 146436) -- Name: core_regional id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.core_regional ALTER COLUMN id SET DEFAULT nextval('public.core_regional_id_seq'::regclass); -- -- TOC entry 3044 (class 2604 OID 146437) -- Name: core_servidor id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.core_servidor ALTER COLUMN id SET DEFAULT nextval('public.core_servidor_id_seq'::regclass); -- -- TOC entry 3045 (class 2604 OID 146438) -- Name: django_admin_log id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.django_admin_log ALTER COLUMN id SET DEFAULT nextval('public.django_admin_log_id_seq'::regclass); -- -- TOC entry 3047 (class 2604 OID 146439) -- Name: django_celery_beat_clockedschedule id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.django_celery_beat_clockedschedule ALTER COLUMN id SET DEFAULT nextval('public.django_celery_beat_clockedschedule_id_seq'::regclass); -- -- TOC entry 3048 (class 2604 OID 146440) -- Name: django_celery_beat_crontabschedule id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.django_celery_beat_crontabschedule ALTER COLUMN id SET DEFAULT nextval('public.django_celery_beat_crontabschedule_id_seq'::regclass); -- -- TOC entry 3049 (class 2604 OID 146441) -- Name: django_celery_beat_intervalschedule id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.django_celery_beat_intervalschedule ALTER COLUMN id SET DEFAULT nextval('public.django_celery_beat_intervalschedule_id_seq'::regclass); -- -- TOC entry 3050 (class 2604 OID 146442) -- Name: django_celery_beat_periodictask id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.django_celery_beat_periodictask ALTER COLUMN id SET DEFAULT nextval('public.django_celery_beat_periodictask_id_seq'::regclass); -- -- TOC entry 3053 (class 2604 OID 146443) -- Name: django_celery_beat_solarschedule id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.django_celery_beat_solarschedule ALTER COLUMN id SET DEFAULT nextval('public.django_celery_beat_solarschedule_id_seq'::regclass); -- -- TOC entry 3054 (class 2604 OID 146444) -- Name: django_celery_results_taskresult id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.django_celery_results_taskresult ALTER COLUMN id SET DEFAULT nextval('public.django_celery_results_taskresult_id_seq'::regclass); -- -- TOC entry 3055 (class 2604 OID 146445) -- Name: django_content_type id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.django_content_type ALTER COLUMN id SET DEFAULT nextval('public.django_content_type_id_seq'::regclass); -- -- TOC entry 3056 (class 2604 OID 146446) -- Name: django_migrations id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.django_migrations ALTER COLUMN id SET DEFAULT nextval('public.django_migrations_id_seq'::regclass); -- -- TOC entry 3057 (class 2604 OID 146447) -- Name: faq_faq id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.faq_faq ALTER COLUMN id SET DEFAULT nextval('public.faq_faq_id_seq'::regclass); -- -- TOC entry 3058 (class 2604 OID 146448) -- Name: reversion_revision id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.reversion_revision ALTER COLUMN id SET DEFAULT nextval('public.reversion_revision_id_seq'::regclass); -- -- TOC entry 3059 (class 2604 OID 146449) -- Name: reversion_version id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.reversion_version ALTER COLUMN id SET DEFAULT nextval('public.reversion_version_id_seq'::regclass); -- -- TOC entry 3060 (class 2604 OID 146450) -- Name: solicitacoes_empresa id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.solicitacoes_empresa ALTER COLUMN id SET DEFAULT nextval('public.solicitacoes_empresa_id_seq'::regclass); -- -- TOC entry 3061 (class 2604 OID 146451) -- Name: solicitacoes_solicitacao id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.solicitacoes_solicitacao ALTER COLUMN id SET DEFAULT nextval('public.solicitacoes_solicitacao_id_seq'::regclass); -- -- TOC entry 3062 (class 2604 OID 146452) -- Name: solicitacoes_solicitacao_departamentos id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.solicitacoes_solicitacao_departamentos ALTER COLUMN id SET DEFAULT nextval('public.solicitacoes_solicitacao_departamentos_id_seq'::regclass); -- -- TOC entry 3063 (class 2604 OID 146453) -- Name: solicitacoes_solicitacaoproduto id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.solicitacoes_solicitacaoproduto ALTER COLUMN id SET DEFAULT nextval('public.solicitacoes_solicitacaoproduto_id_seq'::regclass); -- -- TOC entry 3064 (class 2604 OID 146454) -- Name: solicitacoes_solicitacaoservico id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.solicitacoes_solicitacaoservico ALTER COLUMN id SET DEFAULT nextval('public.solicitacoes_solicitacaoservico_id_seq'::regclass); -- -- TOC entry 3065 (class 2604 OID 146455) -- Name: solicitacoes_solicitacaothread id; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.solicitacoes_solicitacaothread ALTER COLUMN id SET DEFAULT nextval('public.solicitacoes_solicitacaothread_id_seq'::regclass); -- Completed on 2019-09-23 14:39:38 UTC -- -- PostgreSQL database dump complete --