dzhiukx8

1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 9.6.6
6-- Dumped by pg_dump version 9.6.6
7
8SET statement_timeout = 0;
9SET lock_timeout = 0;
10SET idle_in_transaction_session_timeout = 0;
11SET client_encoding = 'UTF8';
12SET standard_conforming_strings = on;
13SET check_function_bodies = false;
14SET client_min_messages = warning;
15SET row_security = off;
16
17--
18-- Name: auditing; Type: SCHEMA; Schema: -; Owner: vidafacil
19--
20
21CREATE SCHEMA auditing;
22
23
24ALTER SCHEMA auditing OWNER TO vidafacil;
25
26--
27-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
28--
29
30CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
31
32
33--
34-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
35--
36
37COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
38
39
40--
41-- Name: hstore; Type: EXTENSION; Schema: -; Owner: 
42--
43
44CREATE EXTENSION IF NOT EXISTS hstore WITH SCHEMA public;
45
46
47--
48-- Name: EXTENSION hstore; Type: COMMENT; Schema: -; Owner: 
49--
50
51COMMENT ON EXTENSION hstore IS 'data type for storing sets of (key, value) pairs';
52
53
54--
55-- Name: unaccent; Type: EXTENSION; Schema: -; Owner: 
56--
57
58CREATE EXTENSION IF NOT EXISTS unaccent WITH SCHEMA public;
59
60
61--
62-- Name: EXTENSION unaccent; Type: COMMENT; Schema: -; Owner: 
63--
64
65COMMENT ON EXTENSION unaccent IS 'text search dictionary that removes accents';
66
67
68SET search_path = public, pg_catalog;
69
70--
71-- Name: filter(text, text[]); Type: FUNCTION; Schema: public; Owner: vidafacil
72--
73
74CREATE FUNCTION filter(needles text, VARIADIC haystacks text[]) RETURNS boolean
75    LANGUAGE sql
76    AS $$
77SELECT needles IS NULL OR trim(needles) = '' OR EXISTS(
78    SELECT DISTINCT 1
79    FROM unnest(haystacks) haystack,
80          unnest(string_to_array(needles, ',')) needle
81    WHERE unaccent(haystack) ILIKE '%' || unaccent(needle) || '%');
82$$;
83
84
85ALTER FUNCTION public.filter(needles text, VARIADIC haystacks text[]) OWNER TO vidafacil;
86
87--
88-- Name: intl_filter(text, character varying, hstore[]); Type: FUNCTION; Schema: public; Owner: vidafacil
89--
90
91CREATE FUNCTION intl_filter(needles text, lang character varying, VARIADIC haystacks hstore[]) RETURNS boolean
92    LANGUAGE sql
93    AS $$
94SELECT needles IS NULL OR trim(needles) = '' OR EXISTS(
95SELECT DISTINCT 1
96FROM unnest(haystacks) haystack,
97unnest(string_to_array(needles, ',')) needle
98WHERE unaccent(cast((haystack -> lang) AS text)) ILIKE '%' || unaccent(needle) || '%');
99$$;
100
101
102ALTER FUNCTION public.intl_filter(needles text, lang character varying, VARIADIC haystacks hstore[]) OWNER TO vidafacil;
103
104SET search_path = auditing, pg_catalog;
105
106SET default_tablespace = '';
107
108SET default_with_oids = false;
109
110--
111-- Name: agente_audited; Type: TABLE; Schema: auditing; Owner: vidafacil
112--
113
114CREATE TABLE agente_audited (
115    id bigint NOT NULL,
116    revision bigint NOT NULL,
117    revision_type smallint,
118    user_id bigint
119);
120
121
122ALTER TABLE agente_audited OWNER TO vidafacil;
123
124--
125-- Name: agente_audited_id_seq; Type: SEQUENCE; Schema: auditing; Owner: vidafacil
126--
127
128CREATE SEQUENCE agente_audited_id_seq
129    START WITH 1
130    INCREMENT BY 1
131    NO MINVALUE
132    NO MAXVALUE
133    CACHE 1;
134
135
136ALTER TABLE agente_audited_id_seq OWNER TO vidafacil;
137
138--
139-- Name: agente_audited_id_seq; Type: SEQUENCE OWNED BY; Schema: auditing; Owner: vidafacil
140--
141
142ALTER SEQUENCE agente_audited_id_seq OWNED BY agente_audited.id;
143
144
145--
146-- Name: apolice_seguro_audited; Type: TABLE; Schema: auditing; Owner: vidafacil
147--
148
149CREATE TABLE apolice_seguro_audited (
150    id bigint NOT NULL,
151    revision bigint NOT NULL,
152    revision_type smallint,
153    forma_pagamento integer NOT NULL,
154    incluir_conjuge_na_cobertura boolean,
155    numero_apolice character varying(255),
156    valor_mensal numeric(19,2),
157    agente_id bigint,
158    cartao_credito_id bigint,
159    cliente_id bigint,
160    executivo_id bigint,
161    grupo_empresa_id bigint,
162    plano_seguro_id bigint,
163    uso_de_motocicleta boolean,
164    status_apolice_seguro integer,
165    solicitacao_cotacao_seguro_id bigint NOT NULL
166);
167
168
169ALTER TABLE apolice_seguro_audited OWNER TO vidafacil;
170
171--
172-- Name: apolice_seguro_audited_id_seq; Type: SEQUENCE; Schema: auditing; Owner: vidafacil
173--
174
175CREATE SEQUENCE apolice_seguro_audited_id_seq
176    START WITH 1
177    INCREMENT BY 1
178    NO MINVALUE
179    NO MAXVALUE
180    CACHE 1;
181
182
183ALTER TABLE apolice_seguro_audited_id_seq OWNER TO vidafacil;
184
185--
186-- Name: apolice_seguro_audited_id_seq; Type: SEQUENCE OWNED BY; Schema: auditing; Owner: vidafacil
187--
188
189ALTER SEQUENCE apolice_seguro_audited_id_seq OWNED BY apolice_seguro_audited.id;
190
191
192--
193-- Name: beneficiario_audited; Type: TABLE; Schema: auditing; Owner: vidafacil
194--
195
196CREATE TABLE beneficiario_audited (
197    id bigint NOT NULL,
198    revision bigint NOT NULL,
199    revision_type smallint,
200    data_nascimento timestamp without time zone,
201    documento character varying(20),
202    grau_parentesco integer,
203    nome_completo character varying(144),
204    numero bigint NOT NULL,
205    percentual_participacao integer,
206    tipo_documento integer,
207    solicitacao_cotacao_seguro_id bigint,
208    tutor_id bigint,
209    apolice_seguro_id bigint
210);
211
212
213ALTER TABLE beneficiario_audited OWNER TO vidafacil;
214
215--
216-- Name: beneficiario_audited_id_seq; Type: SEQUENCE; Schema: auditing; Owner: vidafacil
217--
218
219CREATE SEQUENCE beneficiario_audited_id_seq
220    START WITH 1
221    INCREMENT BY 1
222    NO MINVALUE
223    NO MAXVALUE
224    CACHE 1;
225
226
227ALTER TABLE beneficiario_audited_id_seq OWNER TO vidafacil;
228
229--
230-- Name: beneficiario_audited_id_seq; Type: SEQUENCE OWNED BY; Schema: auditing; Owner: vidafacil
231--
232
233ALTER SEQUENCE beneficiario_audited_id_seq OWNED BY beneficiario_audited.id;
234
235
236--
237-- Name: beneficiario_audited_numero_seq; Type: SEQUENCE; Schema: auditing; Owner: vidafacil
238--
239
240CREATE SEQUENCE beneficiario_audited_numero_seq
241    START WITH 1
242    INCREMENT BY 1
243    NO MINVALUE
244    NO MAXVALUE
245    CACHE 1;
246
247
248ALTER TABLE beneficiario_audited_numero_seq OWNER TO vidafacil;
249
250--
251-- Name: beneficiario_audited_numero_seq; Type: SEQUENCE OWNED BY; Schema: auditing; Owner: vidafacil
252--
253
254ALTER SEQUENCE beneficiario_audited_numero_seq OWNED BY beneficiario_audited.numero;
255
256
257--
258-- Name: cartao_credito_audited; Type: TABLE; Schema: auditing; Owner: vidafacil
259--
260
261CREATE TABLE cartao_credito_audited (
262    id bigint NOT NULL,
263    revision bigint NOT NULL,
264    revision_type smallint,
265    bandeira_cartao integer,
266    codigo_seguranca character varying(5),
267    documento_titular character varying(20),
268    nome_titular character varying(144),
269    numero character varying(16),
270    processadora_cartao integer,
271    mes character varying(2),
272    ano character varying(2)
273);
274
275
276ALTER TABLE cartao_credito_audited OWNER TO vidafacil;
277
278--
279-- Name: cartao_credito_audited_id_seq; Type: SEQUENCE; Schema: auditing; Owner: vidafacil
280--
281
282CREATE SEQUENCE cartao_credito_audited_id_seq
283    START WITH 1
284    INCREMENT BY 1
285    NO MINVALUE
286    NO MAXVALUE
287    CACHE 1;
288
289
290ALTER TABLE cartao_credito_audited_id_seq OWNER TO vidafacil;
291
292--
293-- Name: cartao_credito_audited_id_seq; Type: SEQUENCE OWNED BY; Schema: auditing; Owner: vidafacil
294--
295
296ALTER SEQUENCE cartao_credito_audited_id_seq OWNED BY cartao_credito_audited.id;
297
298
299--
300-- Name: cidade_audited; Type: TABLE; Schema: auditing; Owner: vidafacil
301--
302
303CREATE TABLE cidade_audited (
304    id bigint NOT NULL,
305    revision bigint NOT NULL,
306    revision_type smallint,
307    nome public.hstore,
308    estado_id bigint
309);
310
311
312ALTER TABLE cidade_audited OWNER TO vidafacil;
313
314--
315-- Name: cidade_audited_id_seq; Type: SEQUENCE; Schema: auditing; Owner: vidafacil
316--
317
318CREATE SEQUENCE cidade_audited_id_seq
319    START WITH 1
320    INCREMENT BY 1
321    NO MINVALUE
322    NO MAXVALUE
323    CACHE 1;
324
325
326ALTER TABLE cidade_audited_id_seq OWNER TO vidafacil;
327
328--
329-- Name: cidade_audited_id_seq; Type: SEQUENCE OWNED BY; Schema: auditing; Owner: vidafacil
330--
331
332ALTER SEQUENCE cidade_audited_id_seq OWNED BY cidade_audited.id;
333
334
335--
336-- Name: cliente_audited; Type: TABLE; Schema: auditing; Owner: vidafacil
337--
338
339CREATE TABLE cliente_audited (
340    id bigint NOT NULL,
341    revision bigint NOT NULL,
342    revision_type smallint,
343    estado_civil integer,
344    sexo integer,
345    tipo_documento integer,
346    versao_anterior bytea,
347    conjuge_id bigint,
348    endereco_id bigint,
349    profissao_id bigint,
350    user_id bigint,
351    celular character varying(15) NOT NULL,
352    data_nascimento timestamp without time zone NOT NULL,
353    documento character varying(20) NOT NULL,
354    especificacao_profissao_outro character varying(144),
355    telefone_residencial character varying(15),
356    whatsapp character varying(15),
357    telefone_trabalho character varying(15),
358    endereco_trabalho_id bigint NOT NULL
359);
360
361
362ALTER TABLE cliente_audited OWNER TO vidafacil;
363
364--
365-- Name: cliente_audited_id_seq; Type: SEQUENCE; Schema: auditing; Owner: vidafacil
366--
367
368CREATE SEQUENCE cliente_audited_id_seq
369    START WITH 1
370    INCREMENT BY 1
371    NO MINVALUE
372    NO MAXVALUE
373    CACHE 1;
374
375
376ALTER TABLE cliente_audited_id_seq OWNER TO vidafacil;
377
378--
379-- Name: cliente_audited_id_seq; Type: SEQUENCE OWNED BY; Schema: auditing; Owner: vidafacil
380--
381
382ALTER SEQUENCE cliente_audited_id_seq OWNED BY cliente_audited.id;
383
384
385--
386-- Name: cobertura_plano_seguro_audited; Type: TABLE; Schema: auditing; Owner: vidafacil
387--
388
389CREATE TABLE cobertura_plano_seguro_audited (
390    id bigint NOT NULL,
391    revision bigint NOT NULL,
392    revision_type smallint,
393    cobertura_relevante boolean,
394    descricao public.hstore,
395    ordem_relevancia integer,
396    valor numeric,
397    plano_seguro_id bigint
398);
399
400
401ALTER TABLE cobertura_plano_seguro_audited OWNER TO vidafacil;
402
403--
404-- Name: cobertura_plano_seguro_audited_id_seq; Type: SEQUENCE; Schema: auditing; Owner: vidafacil
405--
406
407CREATE SEQUENCE cobertura_plano_seguro_audited_id_seq
408    START WITH 1
409    INCREMENT BY 1
410    NO MINVALUE
411    NO MAXVALUE
412    CACHE 1;
413
414
415ALTER TABLE cobertura_plano_seguro_audited_id_seq OWNER TO vidafacil;
416
417--
418-- Name: cobertura_plano_seguro_audited_id_seq; Type: SEQUENCE OWNED BY; Schema: auditing; Owner: vidafacil
419--
420
421ALTER SEQUENCE cobertura_plano_seguro_audited_id_seq OWNED BY cobertura_plano_seguro_audited.id;
422
423
424--
425-- Name: configuracao_perfil_usuario_plano_seguro_audited; Type: TABLE; Schema: auditing; Owner: vidafacil
426--
427
428CREATE TABLE configuracao_perfil_usuario_plano_seguro_audited (
429    id bigint NOT NULL,
430    revision bigint NOT NULL,
431    revision_type smallint,
432    perfil_usuario_plano_seguro integer,
433    plano_seguro_id bigint
434);
435
436
437ALTER TABLE configuracao_perfil_usuario_plano_seguro_audited OWNER TO vidafacil;
438
439--
440-- Name: configuracao_perfil_usuario_plano_seguro_audited_id_seq; Type: SEQUENCE; Schema: auditing; Owner: vidafacil
441--
442
443CREATE SEQUENCE configuracao_perfil_usuario_plano_seguro_audited_id_seq
444    START WITH 1
445    INCREMENT BY 1
446    NO MINVALUE
447    NO MAXVALUE
448    CACHE 1;
449
450
451ALTER TABLE configuracao_perfil_usuario_plano_seguro_audited_id_seq OWNER TO vidafacil;
452
453--
454-- Name: configuracao_perfil_usuario_plano_seguro_audited_id_seq; Type: SEQUENCE OWNED BY; Schema: auditing; Owner: vidafacil
455--
456
457ALTER SEQUENCE configuracao_perfil_usuario_plano_seguro_audited_id_seq OWNED BY configuracao_perfil_usuario_plano_seguro_audited.id;
458
459
460--
461-- Name: configuracao_plataforma_audited; Type: TABLE; Schema: auditing; Owner: vidafacil
462--
463
464CREATE TABLE configuracao_plataforma_audited (
465    id bigint NOT NULL,
466    revision bigint NOT NULL,
467    revision_type smallint,
468    limite_reenvio_email_rejeicao_cotacao integer,
469    tempo_reenvio_email_rejeicao_cotacao integer
470);
471
472
473ALTER TABLE configuracao_plataforma_audited OWNER TO vidafacil;
474
475--
476-- Name: configuracao_plataforma_audited_id_seq; Type: SEQUENCE; Schema: auditing; Owner: vidafacil
477--
478
479CREATE SEQUENCE configuracao_plataforma_audited_id_seq
480    START WITH 1
481    INCREMENT BY 1
482    NO MINVALUE
483    NO MAXVALUE
484    CACHE 1;
485
486
487ALTER TABLE configuracao_plataforma_audited_id_seq OWNER TO vidafacil;
488
489--
490-- Name: configuracao_plataforma_audited_id_seq; Type: SEQUENCE OWNED BY; Schema: auditing; Owner: vidafacil
491--
492
493ALTER SEQUENCE configuracao_plataforma_audited_id_seq OWNED BY configuracao_plataforma_audited.id;
494
495
496--
497-- Name: conjuge_audited; Type: TABLE; Schema: auditing; Owner: vidafacil
498--
499
500CREATE TABLE conjuge_audited (
501    id bigint NOT NULL,
502    revision bigint NOT NULL,
503    revision_type smallint,
504    data_nascimento timestamp without time zone,
505    documento character varying(20),
506    nome_completo character varying(144),
507    tipo_documento integer,
508    especificacao_profissao_outro_conjuge character varying(144),
509    profissao_id bigint
510);
511
512
513ALTER TABLE conjuge_audited OWNER TO vidafacil;
514
515--
516-- Name: conjuge_audited_id_seq; Type: SEQUENCE; Schema: auditing; Owner: vidafacil
517--
518
519CREATE SEQUENCE conjuge_audited_id_seq
520    START WITH 1
521    INCREMENT BY 1
522    NO MINVALUE
523    NO MAXVALUE
524    CACHE 1;
525
526
527ALTER TABLE conjuge_audited_id_seq OWNER TO vidafacil;
528
529--
530-- Name: conjuge_audited_id_seq; Type: SEQUENCE OWNED BY; Schema: auditing; Owner: vidafacil
531--
532
533ALTER SEQUENCE conjuge_audited_id_seq OWNED BY conjuge_audited.id;
534
535
536--
537-- Name: endereco_audited; Type: TABLE; Schema: auditing; Owner: vidafacil
538--
539
540CREATE TABLE endereco_audited (
541    id bigint NOT NULL,
542    revision bigint NOT NULL,
543    revision_type smallint,
544    bairro character varying(144),
545    codigo_postal character varying(20),
546    complemento character varying(144),
547    logradouro character varying(144),
548    numero character varying(6),
549    cidade_id bigint
550);
551
552
553ALTER TABLE endereco_audited OWNER TO vidafacil;
554
555--
556-- Name: endereco_audited_id_seq; Type: SEQUENCE; Schema: auditing; Owner: vidafacil
557--
558
559CREATE SEQUENCE endereco_audited_id_seq
560    START WITH 1
561    INCREMENT BY 1
562    NO MINVALUE
563    NO MAXVALUE
564    CACHE 1;
565
566
567ALTER TABLE endereco_audited_id_seq OWNER TO vidafacil;
568
569--
570-- Name: endereco_audited_id_seq; Type: SEQUENCE OWNED BY; Schema: auditing; Owner: vidafacil
571--
572
573ALTER SEQUENCE endereco_audited_id_seq OWNED BY endereco_audited.id;
574
575
576--
577-- Name: estado_audited; Type: TABLE; Schema: auditing; Owner: vidafacil
578--
579
580CREATE TABLE estado_audited (
581    id bigint NOT NULL,
582    revision bigint NOT NULL,
583    revision_type smallint,
584    nome public.hstore,
585    pais_id bigint
586);
587
588
589ALTER TABLE estado_audited OWNER TO vidafacil;
590
591--
592-- Name: estado_audited_id_seq; Type: SEQUENCE; Schema: auditing; Owner: vidafacil
593--
594
595CREATE SEQUENCE estado_audited_id_seq
596    START WITH 1
597    INCREMENT BY 1
598    NO MINVALUE
599    NO MAXVALUE
600    CACHE 1;
601
602
603ALTER TABLE estado_audited_id_seq OWNER TO vidafacil;
604
605--
606-- Name: estado_audited_id_seq; Type: SEQUENCE OWNED BY; Schema: auditing; Owner: vidafacil
607--
608
609ALTER SEQUENCE estado_audited_id_seq OWNED BY estado_audited.id;
610
611
612--
613-- Name: executivo_audited; Type: TABLE; Schema: auditing; Owner: vidafacil
614--
615
616CREATE TABLE executivo_audited (
617    id bigint NOT NULL,
618    revision bigint NOT NULL,
619    revision_type smallint,
620    agente_id bigint,
621    user_id bigint
622);
623
624
625ALTER TABLE executivo_audited OWNER TO vidafacil;
626
627--
628-- Name: executivo_audited_id_seq; Type: SEQUENCE; Schema: auditing; Owner: vidafacil
629--
630
631CREATE SEQUENCE executivo_audited_id_seq
632    START WITH 1
633    INCREMENT BY 1
634    NO MINVALUE
635    NO MAXVALUE
636    CACHE 1;
637
638
639ALTER TABLE executivo_audited_id_seq OWNER TO vidafacil;
640
641--
642-- Name: executivo_audited_id_seq; Type: SEQUENCE OWNED BY; Schema: auditing; Owner: vidafacil
643--
644
645ALTER SEQUENCE executivo_audited_id_seq OWNED BY executivo_audited.id;
646
647
648--
649-- Name: formulario_perfil_usuario_cotacao_seguro_audited; Type: TABLE; Schema: auditing; Owner: vidafacil
650--
651
652CREATE TABLE formulario_perfil_usuario_cotacao_seguro_audited (
653    id bigint NOT NULL,
654    revision bigint NOT NULL,
655    revision_type smallint,
656    formulario_cotacao_plano_seguro integer,
657    configuracao_perfil_usuario_plano_seguro_id bigint
658);
659
660
661ALTER TABLE formulario_perfil_usuario_cotacao_seguro_audited OWNER TO vidafacil;
662
663--
664-- Name: formulario_perfil_usuario_cotacao_seguro_audited_id_seq; Type: SEQUENCE; Schema: auditing; Owner: vidafacil
665--
666
667CREATE SEQUENCE formulario_perfil_usuario_cotacao_seguro_audited_id_seq
668    START WITH 1
669    INCREMENT BY 1
670    NO MINVALUE
671    NO MAXVALUE
672    CACHE 1;
673
674
675ALTER TABLE formulario_perfil_usuario_cotacao_seguro_audited_id_seq OWNER TO vidafacil;
676
677--
678-- Name: formulario_perfil_usuario_cotacao_seguro_audited_id_seq; Type: SEQUENCE OWNED BY; Schema: auditing; Owner: vidafacil
679--
680
681ALTER SEQUENCE formulario_perfil_usuario_cotacao_seguro_audited_id_seq OWNED BY formulario_perfil_usuario_cotacao_seguro_audited.id;
682
683
684--
685-- Name: grupo_empresa_audited; Type: TABLE; Schema: auditing; Owner: vidafacil
686--
687
688CREATE TABLE grupo_empresa_audited (
689    id bigint NOT NULL,
690    revision bigint NOT NULL,
691    revision_type smallint,
692    nome_fantasia character varying(144),
693    responsavel_rh_id bigint,
694    pagamento_comum boolean
695);
696
697
698ALTER TABLE grupo_empresa_audited OWNER TO vidafacil;
699
700--
701-- Name: grupo_empresa_audited_id_seq; Type: SEQUENCE; Schema: auditing; Owner: vidafacil
702--
703
704CREATE SEQUENCE grupo_empresa_audited_id_seq
705    START WITH 1
706    INCREMENT BY 1
707    NO MINVALUE
708    NO MAXVALUE
709    CACHE 1;
710
711
712ALTER TABLE grupo_empresa_audited_id_seq OWNER TO vidafacil;
713
714--
715-- Name: grupo_empresa_audited_id_seq; Type: SEQUENCE OWNED BY; Schema: auditing; Owner: vidafacil
716--
717
718ALTER SEQUENCE grupo_empresa_audited_id_seq OWNED BY grupo_empresa_audited.id;
719
720
721--
722-- Name: historico_apolice_seguro_audited; Type: TABLE; Schema: auditing; Owner: vidafacil
723--
724
725CREATE TABLE historico_apolice_seguro_audited (
726    id bigint NOT NULL,
727    revision bigint NOT NULL,
728    revision_type smallint,
729    data_operacao timestamp without time zone,
730    operacao_troca_status_apolice_seguro integer,
731    apolice_seguro_id bigint,
732    user_id bigint,
733    observacao character varying
734);
735
736
737ALTER TABLE historico_apolice_seguro_audited OWNER TO vidafacil;
738
739--
740-- Name: historico_apolice_seguro_audited_id_seq; Type: SEQUENCE; Schema: auditing; Owner: vidafacil
741--
742
743CREATE SEQUENCE historico_apolice_seguro_audited_id_seq
744    START WITH 1
745    INCREMENT BY 1
746    NO MINVALUE
747    NO MAXVALUE
748    CACHE 1;
749
750
751ALTER TABLE historico_apolice_seguro_audited_id_seq OWNER TO vidafacil;
752
753--
754-- Name: historico_apolice_seguro_audited_id_seq; Type: SEQUENCE OWNED BY; Schema: auditing; Owner: vidafacil
755--
756
757ALTER SEQUENCE historico_apolice_seguro_audited_id_seq OWNED BY historico_apolice_seguro_audited.id;
758
759
760--
761-- Name: historico_solicitacao_cotacao_seguro_audited; Type: TABLE; Schema: auditing; Owner: vidafacil
762--
763
764CREATE TABLE historico_solicitacao_cotacao_seguro_audited (
765    id bigint NOT NULL,
766    revision bigint NOT NULL,
767    revision_type smallint,
768    data_operacao timestamp without time zone,
769    operacao_troca_status_solicitacao_seguro integer,
770    solicitacao_cotacao_seguro_id bigint,
771    observacao character varying(255),
772    user_id bigint
773);
774
775
776ALTER TABLE historico_solicitacao_cotacao_seguro_audited OWNER TO vidafacil;
777
778--
779-- Name: historico_solicitacao_cotacao_seguro_audited_id_seq; Type: SEQUENCE; Schema: auditing; Owner: vidafacil
780--
781
782CREATE SEQUENCE historico_solicitacao_cotacao_seguro_audited_id_seq
783    START WITH 1
784    INCREMENT BY 1
785    NO MINVALUE
786    NO MAXVALUE
787    CACHE 1;
788
789
790ALTER TABLE historico_solicitacao_cotacao_seguro_audited_id_seq OWNER TO vidafacil;
791
792--
793-- Name: historico_solicitacao_cotacao_seguro_audited_id_seq; Type: SEQUENCE OWNED BY; Schema: auditing; Owner: vidafacil
794--
795
796ALTER SEQUENCE historico_solicitacao_cotacao_seguro_audited_id_seq OWNED BY historico_solicitacao_cotacao_seguro_audited.id;
797
798
799--
800-- Name: pais_audited; Type: TABLE; Schema: auditing; Owner: vidafacil
801--
802
803CREATE TABLE pais_audited (
804    id bigint NOT NULL,
805    revision bigint NOT NULL,
806    revision_type smallint,
807    nome public.hstore
808);
809
810
811ALTER TABLE pais_audited OWNER TO vidafacil;
812
813--
814-- Name: pais_audited_id_seq; Type: SEQUENCE; Schema: auditing; Owner: vidafacil
815--
816
817CREATE SEQUENCE pais_audited_id_seq
818    START WITH 1
819    INCREMENT BY 1
820    NO MINVALUE
821    NO MAXVALUE
822    CACHE 1;
823
824
825ALTER TABLE pais_audited_id_seq OWNER TO vidafacil;
826
827--
828-- Name: pais_audited_id_seq; Type: SEQUENCE OWNED BY; Schema: auditing; Owner: vidafacil
829--
830
831ALTER SEQUENCE pais_audited_id_seq OWNED BY pais_audited.id;
832
833
834--
835-- Name: perfil_acesso_audited; Type: TABLE; Schema: auditing; Owner: vidafacil
836--
837
838CREATE TABLE perfil_acesso_audited (
839    id bigint NOT NULL,
840    revision bigint NOT NULL,
841    revision_type smallint,
842    descricao public.hstore,
843    editavel boolean,
844    nome public.hstore,
845    removivel boolean
846);
847
848
849ALTER TABLE perfil_acesso_audited OWNER TO vidafacil;
850
851--
852-- Name: perfil_acesso_audited_id_seq; Type: SEQUENCE; Schema: auditing; Owner: vidafacil
853--
854
855CREATE SEQUENCE perfil_acesso_audited_id_seq
856    START WITH 1
857    INCREMENT BY 1
858    NO MINVALUE
859    NO MAXVALUE
860    CACHE 1;
861
862
863ALTER TABLE perfil_acesso_audited_id_seq OWNER TO vidafacil;
864
865--
866-- Name: perfil_acesso_audited_id_seq; Type: SEQUENCE OWNED BY; Schema: auditing; Owner: vidafacil
867--
868
869ALTER SEQUENCE perfil_acesso_audited_id_seq OWNED BY perfil_acesso_audited.id;
870
871
872--
873-- Name: perfil_acesso_permissao_audited; Type: TABLE; Schema: auditing; Owner: vidafacil
874--
875
876CREATE TABLE perfil_acesso_permissao_audited (
877    id bigint NOT NULL,
878    revision bigint NOT NULL,
879    revision_type smallint,
880    permissao_identificador character varying(255),
881    perfil_acesso_id bigint
882);
883
884
885ALTER TABLE perfil_acesso_permissao_audited OWNER TO vidafacil;
886
887--
888-- Name: perfil_acesso_permissao_audited_id_seq; Type: SEQUENCE; Schema: auditing; Owner: vidafacil
889--
890
891CREATE SEQUENCE perfil_acesso_permissao_audited_id_seq
892    START WITH 1
893    INCREMENT BY 1
894    NO MINVALUE
895    NO MAXVALUE
896    CACHE 1;
897
898
899ALTER TABLE perfil_acesso_permissao_audited_id_seq OWNER TO vidafacil;
900
901--
902-- Name: perfil_acesso_permissao_audited_id_seq; Type: SEQUENCE OWNED BY; Schema: auditing; Owner: vidafacil
903--
904
905ALTER SEQUENCE perfil_acesso_permissao_audited_id_seq OWNED BY perfil_acesso_permissao_audited.id;
906
907
908--
909-- Name: plano_seguro_audited; Type: TABLE; Schema: auditing; Owner: vidafacil
910--
911
912CREATE TABLE plano_seguro_audited (
913    id bigint NOT NULL,
914    revision bigint NOT NULL,
915    revision_type smallint,
916    descricao public.hstore,
917    nome public.hstore,
918    ordem_relevancia integer,
919    permite_incluir_conjuge boolean,
920    valor numeric,
921    produto_seguro_id bigint
922);
923
924
925ALTER TABLE plano_seguro_audited OWNER TO vidafacil;
926
927--
928-- Name: plano_seguro_audited_id_seq; Type: SEQUENCE; Schema: auditing; Owner: vidafacil
929--
930
931CREATE SEQUENCE plano_seguro_audited_id_seq
932    START WITH 1
933    INCREMENT BY 1
934    NO MINVALUE
935    NO MAXVALUE
936    CACHE 1;
937
938
939ALTER TABLE plano_seguro_audited_id_seq OWNER TO vidafacil;
940
941--
942-- Name: plano_seguro_audited_id_seq; Type: SEQUENCE OWNED BY; Schema: auditing; Owner: vidafacil
943--
944
945ALTER SEQUENCE plano_seguro_audited_id_seq OWNED BY plano_seguro_audited.id;
946
947
948--
949-- Name: produto_seguro_audited; Type: TABLE; Schema: auditing; Owner: vidafacil
950--
951
952CREATE TABLE produto_seguro_audited (
953    id bigint NOT NULL,
954    revision bigint NOT NULL,
955    revision_type smallint,
956    nome public.hstore,
957    ordem_relevancia integer
958);
959
960
961ALTER TABLE produto_seguro_audited OWNER TO vidafacil;
962
963--
964-- Name: produto_seguro_audited_id_seq; Type: SEQUENCE; Schema: auditing; Owner: vidafacil
965--
966
967CREATE SEQUENCE produto_seguro_audited_id_seq
968    START WITH 1
969    INCREMENT BY 1
970    NO MINVALUE
971    NO MAXVALUE
972    CACHE 1;
973
974
975ALTER TABLE produto_seguro_audited_id_seq OWNER TO vidafacil;
976
977--
978-- Name: produto_seguro_audited_id_seq; Type: SEQUENCE OWNED BY; Schema: auditing; Owner: vidafacil
979--
980
981ALTER SEQUENCE produto_seguro_audited_id_seq OWNED BY produto_seguro_audited.id;
982
983
984--
985-- Name: profissao_audited; Type: TABLE; Schema: auditing; Owner: vidafacil
986--
987
988CREATE TABLE profissao_audited (
989    id bigint NOT NULL,
990    revision bigint NOT NULL,
991    revision_type smallint,
992    descricao public.hstore
993);
994
995
996ALTER TABLE profissao_audited OWNER TO vidafacil;
997
998--
999-- Name: profissao_audited_id_seq; Type: SEQUENCE; Schema: auditing; Owner: vidafacil
1000--
1001
1002CREATE SEQUENCE profissao_audited_id_seq
1003    START WITH 1
1004    INCREMENT BY 1
1005    NO MINVALUE
1006    NO MAXVALUE
1007    CACHE 1;
1008
1009
1010ALTER TABLE profissao_audited_id_seq OWNER TO vidafacil;
1011
1012--
1013-- Name: profissao_audited_id_seq; Type: SEQUENCE OWNED BY; Schema: auditing; Owner: vidafacil
1014--
1015
1016ALTER SEQUENCE profissao_audited_id_seq OWNED BY profissao_audited.id;
1017
1018
1019--
1020-- Name: profissao_restricao_plano_seguro_audited; Type: TABLE; Schema: auditing; Owner: vidafacil
1021--
1022
1023CREATE TABLE profissao_restricao_plano_seguro_audited (
1024    id bigint NOT NULL,
1025    revision bigint NOT NULL,
1026    revision_type smallint,
1027    plano_seguro_id bigint,
1028    profissao_id bigint
1029);
1030
1031
1032ALTER TABLE profissao_restricao_plano_seguro_audited OWNER TO vidafacil;
1033
1034--
1035-- Name: profissao_restricao_plano_seguro_audited_id_seq; Type: SEQUENCE; Schema: auditing; Owner: vidafacil
1036--
1037
1038CREATE SEQUENCE profissao_restricao_plano_seguro_audited_id_seq
1039    START WITH 1
1040    INCREMENT BY 1
1041    NO MINVALUE
1042    NO MAXVALUE
1043    CACHE 1;
1044
1045
1046ALTER TABLE profissao_restricao_plano_seguro_audited_id_seq OWNER TO vidafacil;
1047
1048--
1049-- Name: profissao_restricao_plano_seguro_audited_id_seq; Type: SEQUENCE OWNED BY; Schema: auditing; Owner: vidafacil
1050--
1051
1052ALTER SEQUENCE profissao_restricao_plano_seguro_audited_id_seq OWNED BY profissao_restricao_plano_seguro_audited.id;
1053
1054
1055--
1056-- Name: revision; Type: TABLE; Schema: auditing; Owner: vidafacil
1057--
1058
1059CREATE TABLE revision (
1060    id bigint NOT NULL,
1061    "timestamp" bigint NOT NULL,
1062    user_id bigint
1063);
1064
1065
1066ALTER TABLE revision OWNER TO vidafacil;
1067
1068--
1069-- Name: revision_id_seq; Type: SEQUENCE; Schema: auditing; Owner: vidafacil
1070--
1071
1072CREATE SEQUENCE revision_id_seq
1073    START WITH 1
1074    INCREMENT BY 1
1075    NO MINVALUE
1076    NO MAXVALUE
1077    CACHE 1;
1078
1079
1080ALTER TABLE revision_id_seq OWNER TO vidafacil;
1081
1082--
1083-- Name: revision_id_seq; Type: SEQUENCE OWNED BY; Schema: auditing; Owner: vidafacil
1084--
1085
1086ALTER SEQUENCE revision_id_seq OWNED BY revision.id;
1087
1088
1089--
1090-- Name: solicitacao_cotacao_seguro_audited; Type: TABLE; Schema: auditing; Owner: vidafacil
1091--
1092
1093CREATE TABLE solicitacao_cotacao_seguro_audited (
1094    id bigint NOT NULL,
1095    revision bigint NOT NULL,
1096    revision_type smallint,
1097    celular character varying(15),
1098    data_nascimento timestamp without time zone,
1099    documento character varying(20),
1100    email character varying(50),
1101    estado_civil integer,
1102    forma_pagamento integer,
1103    incluir_conjuge_cobertura boolean,
1104    nome character varying(144),
1105    numero_solicitacao character varying(144),
1106    sexo integer,
1107    situacao_solicitacao_cotacao_seguro integer,
1108    sobrenome character varying(144),
1109    telefone_residencial character varying(15),
1110    telefone_trabalho character varying(15),
1111    tipo_documento integer NOT NULL,
1112    uso_de_motocicleta boolean,
1113    valor_mensal numeric(19,2),
1114    whatsapp character varying(15),
1115    agente_autorizado_id bigint,
1116    apolice_seguro_id bigint,
1117    cartao_credito_id bigint,
1118    conjuge_id bigint,
1119    endereco_residencial_id bigint,
1120    endereco_trabalho_id bigint,
1121    executivo_id bigint,
1122    grupo_empresa_id bigint,
1123    plano_seguro_id bigint,
1124    profissao_id bigint,
1125    edit_token character varying(144),
1126    especificacao_profissao_outro character varying(144)
1127);
1128
1129
1130ALTER TABLE solicitacao_cotacao_seguro_audited OWNER TO vidafacil;
1131
1132--
1133-- Name: solicitacao_cotacao_seguro_audited_id_seq; Type: SEQUENCE; Schema: auditing; Owner: vidafacil
1134--
1135
1136CREATE SEQUENCE solicitacao_cotacao_seguro_audited_id_seq
1137    START WITH 1
1138    INCREMENT BY 1
1139    NO MINVALUE
1140    NO MAXVALUE
1141    CACHE 1;
1142
1143
1144ALTER TABLE solicitacao_cotacao_seguro_audited_id_seq OWNER TO vidafacil;
1145
1146--
1147-- Name: solicitacao_cotacao_seguro_audited_id_seq; Type: SEQUENCE OWNED BY; Schema: auditing; Owner: vidafacil
1148--
1149
1150ALTER SEQUENCE solicitacao_cotacao_seguro_audited_id_seq OWNED BY solicitacao_cotacao_seguro_audited.id;
1151
1152
1153--
1154-- Name: tutor_audited; Type: TABLE; Schema: auditing; Owner: vidafacil
1155--
1156
1157CREATE TABLE tutor_audited (
1158    id bigint NOT NULL,
1159    revision bigint NOT NULL,
1160    revision_type smallint,
1161    documento character varying(20),
1162    grau_parentesco integer,
1163    nome_completo character varying(144),
1164    tipo_documento integer,
1165    data_nascimento timestamp without time zone
1166);
1167
1168
1169ALTER TABLE tutor_audited OWNER TO vidafacil;
1170
1171--
1172-- Name: tutor_audited_id_seq; Type: SEQUENCE; Schema: auditing; Owner: vidafacil
1173--
1174
1175CREATE SEQUENCE tutor_audited_id_seq
1176    START WITH 1
1177    INCREMENT BY 1
1178    NO MINVALUE
1179    NO MAXVALUE
1180    CACHE 1;
1181
1182
1183ALTER TABLE tutor_audited_id_seq OWNER TO vidafacil;
1184
1185--
1186-- Name: tutor_audited_id_seq; Type: SEQUENCE OWNED BY; Schema: auditing; Owner: vidafacil
1187--
1188
1189ALTER SEQUENCE tutor_audited_id_seq OWNED BY tutor_audited.id;
1190
1191
1192--
1193-- Name: user_audited; Type: TABLE; Schema: auditing; Owner: vidafacil
1194--
1195
1196CREATE TABLE user_audited (
1197    id bigint NOT NULL,
1198    revision bigint NOT NULL,
1199    revision_type smallint,
1200    disabled boolean,
1201    email character varying(144),
1202    last_login timestamp with time zone,
1203    name character varying(50),
1204    password character varying(100),
1205    sobrenome character varying(144),
1206    role integer,
1207    password_reset_token character varying,
1208    password_reset_token_expiration timestamp with time zone
1209);
1210
1211
1212ALTER TABLE user_audited OWNER TO vidafacil;
1213
1214--
1215-- Name: usuario_perfil_acesso_audited; Type: TABLE; Schema: auditing; Owner: vidafacil
1216--
1217
1218CREATE TABLE usuario_perfil_acesso_audited (
1219    id bigint NOT NULL,
1220    revision bigint NOT NULL,
1221    revision_type smallint,
1222    perfil_acesso_id bigint,
1223    user_id bigint
1224);
1225
1226
1227ALTER TABLE usuario_perfil_acesso_audited OWNER TO vidafacil;
1228
1229--
1230-- Name: usuario_perfil_acesso_audited_id_seq; Type: SEQUENCE; Schema: auditing; Owner: vidafacil
1231--
1232
1233CREATE SEQUENCE usuario_perfil_acesso_audited_id_seq
1234    START WITH 1
1235    INCREMENT BY 1
1236    NO MINVALUE
1237    NO MAXVALUE
1238    CACHE 1;
1239
1240
1241ALTER TABLE usuario_perfil_acesso_audited_id_seq OWNER TO vidafacil;
1242
1243--
1244-- Name: usuario_perfil_acesso_audited_id_seq; Type: SEQUENCE OWNED BY; Schema: auditing; Owner: vidafacil
1245--
1246
1247ALTER SEQUENCE usuario_perfil_acesso_audited_id_seq OWNED BY usuario_perfil_acesso_audited.id;
1248
1249
1250SET search_path = public, pg_catalog;
1251
1252--
1253-- Name: agente; Type: TABLE; Schema: public; Owner: vidafacil
1254--
1255
1256CREATE TABLE agente (
1257    id bigint NOT NULL,
1258    created timestamp without time zone NOT NULL,
1259    updated timestamp without time zone,
1260    user_id bigint NOT NULL
1261);
1262
1263
1264ALTER TABLE agente OWNER TO vidafacil;
1265
1266--
1267-- Name: agente_id_seq; Type: SEQUENCE; Schema: public; Owner: vidafacil
1268--
1269
1270CREATE SEQUENCE agente_id_seq
1271    START WITH 1
1272    INCREMENT BY 1
1273    NO MINVALUE
1274    NO MAXVALUE
1275    CACHE 1;
1276
1277
1278ALTER TABLE agente_id_seq OWNER TO vidafacil;
1279
1280--
1281-- Name: agente_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vidafacil
1282--
1283
1284ALTER SEQUENCE agente_id_seq OWNED BY agente.id;
1285
1286
1287--
1288-- Name: apolice_seguro; Type: TABLE; Schema: public; Owner: vidafacil
1289--
1290
1291CREATE TABLE apolice_seguro (
1292    id bigint NOT NULL,
1293    created timestamp without time zone NOT NULL,
1294    updated timestamp without time zone,
1295    forma_pagamento integer NOT NULL,
1296    incluir_conjuge_na_cobertura boolean,
1297    numero_apolice character varying(255),
1298    valor_mensal numeric(19,2),
1299    agente_id bigint,
1300    cartao_credito_id bigint,
1301    cliente_id bigint,
1302    executivo_id bigint,
1303    grupo_empresa_id bigint,
1304    plano_seguro_id bigint,
1305    uso_de_motocicleta boolean,
1306    status_apolice_seguro integer,
1307    solicitacao_cotacao_seguro_id bigint NOT NULL
1308);
1309
1310
1311ALTER TABLE apolice_seguro OWNER TO vidafacil;
1312
1313--
1314-- Name: apolice_seguro_id_seq; Type: SEQUENCE; Schema: public; Owner: vidafacil
1315--
1316
1317CREATE SEQUENCE apolice_seguro_id_seq
1318    START WITH 1
1319    INCREMENT BY 1
1320    NO MINVALUE
1321    NO MAXVALUE
1322    CACHE 1;
1323
1324
1325ALTER TABLE apolice_seguro_id_seq OWNER TO vidafacil;
1326
1327--
1328-- Name: apolice_seguro_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vidafacil
1329--
1330
1331ALTER SEQUENCE apolice_seguro_id_seq OWNED BY apolice_seguro.id;
1332
1333
1334--
1335-- Name: beneficiario; Type: TABLE; Schema: public; Owner: vidafacil
1336--
1337
1338CREATE TABLE beneficiario (
1339    id bigint NOT NULL,
1340    created timestamp without time zone NOT NULL,
1341    updated timestamp without time zone,
1342    data_nascimento timestamp without time zone NOT NULL,
1343    documento character varying(20) NOT NULL,
1344    grau_parentesco integer NOT NULL,
1345    nome_completo character varying(144) NOT NULL,
1346    numero bigint NOT NULL,
1347    percentual_participacao integer NOT NULL,
1348    tipo_documento integer NOT NULL,
1349    solicitacao_cotacao_seguro_id bigint NOT NULL,
1350    tutor_id bigint,
1351    apolice_seguro_id bigint
1352);
1353
1354
1355ALTER TABLE beneficiario OWNER TO vidafacil;
1356
1357--
1358-- Name: beneficiario_id_seq; Type: SEQUENCE; Schema: public; Owner: vidafacil
1359--
1360
1361CREATE SEQUENCE beneficiario_id_seq
1362    START WITH 1
1363    INCREMENT BY 1
1364    NO MINVALUE
1365    NO MAXVALUE
1366    CACHE 1;
1367
1368
1369ALTER TABLE beneficiario_id_seq OWNER TO vidafacil;
1370
1371--
1372-- Name: beneficiario_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vidafacil
1373--
1374
1375ALTER SEQUENCE beneficiario_id_seq OWNED BY beneficiario.id;
1376
1377
1378--
1379-- Name: beneficiario_numero_seq; Type: SEQUENCE; Schema: public; Owner: vidafacil
1380--
1381
1382CREATE SEQUENCE beneficiario_numero_seq
1383    START WITH 1
1384    INCREMENT BY 1
1385    NO MINVALUE
1386    NO MAXVALUE
1387    CACHE 1;
1388
1389
1390ALTER TABLE beneficiario_numero_seq OWNER TO vidafacil;
1391
1392--
1393-- Name: beneficiario_numero_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vidafacil
1394--
1395
1396ALTER SEQUENCE beneficiario_numero_seq OWNED BY beneficiario.numero;
1397
1398
1399--
1400-- Name: cartao_credito; Type: TABLE; Schema: public; Owner: vidafacil
1401--
1402
1403CREATE TABLE cartao_credito (
1404    id bigint NOT NULL,
1405    created timestamp without time zone NOT NULL,
1406    updated timestamp without time zone,
1407    bandeira_cartao integer NOT NULL,
1408    codigo_seguranca character varying(5) NOT NULL,
1409    documento_titular character varying(20) NOT NULL,
1410    nome_titular character varying(144) NOT NULL,
1411    numero character varying(16) NOT NULL,
1412    processadora_cartao integer NOT NULL,
1413    mes character varying(2) NOT NULL,
1414    ano character varying(2) NOT NULL
1415);
1416
1417
1418ALTER TABLE cartao_credito OWNER TO vidafacil;
1419
1420--
1421-- Name: cartao_credito_id_seq; Type: SEQUENCE; Schema: public; Owner: vidafacil
1422--
1423
1424CREATE SEQUENCE cartao_credito_id_seq
1425    START WITH 1
1426    INCREMENT BY 1
1427    NO MINVALUE
1428    NO MAXVALUE
1429    CACHE 1;
1430
1431
1432ALTER TABLE cartao_credito_id_seq OWNER TO vidafacil;
1433
1434--
1435-- Name: cartao_credito_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vidafacil
1436--
1437
1438ALTER SEQUENCE cartao_credito_id_seq OWNED BY cartao_credito.id;
1439
1440
1441--
1442-- Name: cidade; Type: TABLE; Schema: public; Owner: vidafacil
1443--
1444
1445CREATE TABLE cidade (
1446    id bigint NOT NULL,
1447    created timestamp without time zone NOT NULL,
1448    updated timestamp without time zone,
1449    nome hstore NOT NULL,
1450    estado_id bigint NOT NULL
1451);
1452
1453
1454ALTER TABLE cidade OWNER TO vidafacil;
1455
1456--
1457-- Name: cidade_id_seq; Type: SEQUENCE; Schema: public; Owner: vidafacil
1458--
1459
1460CREATE SEQUENCE cidade_id_seq
1461    START WITH 1
1462    INCREMENT BY 1
1463    NO MINVALUE
1464    NO MAXVALUE
1465    CACHE 1;
1466
1467
1468ALTER TABLE cidade_id_seq OWNER TO vidafacil;
1469
1470--
1471-- Name: cidade_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vidafacil
1472--
1473
1474ALTER SEQUENCE cidade_id_seq OWNED BY cidade.id;
1475
1476
1477--
1478-- Name: cliente; Type: TABLE; Schema: public; Owner: vidafacil
1479--
1480
1481CREATE TABLE cliente (
1482    id bigint NOT NULL,
1483    created timestamp without time zone NOT NULL,
1484    updated timestamp without time zone,
1485    estado_civil integer NOT NULL,
1486    sexo integer NOT NULL,
1487    tipo_documento integer NOT NULL,
1488    versao_anterior bytea,
1489    conjuge_id bigint,
1490    endereco_id bigint NOT NULL,
1491    profissao_id bigint NOT NULL,
1492    user_id bigint NOT NULL,
1493    celular character varying(15) NOT NULL,
1494    data_nascimento timestamp without time zone NOT NULL,
1495    documento character varying(20) NOT NULL,
1496    especificacao_profissao_outro character varying(144),
1497    telefone_residencial character varying(15),
1498    whatsapp character varying(15),
1499    telefone_trabalho character varying(15),
1500    endereco_trabalho_id bigint NOT NULL
1501);
1502
1503
1504ALTER TABLE cliente OWNER TO vidafacil;
1505
1506--
1507-- Name: cliente_id_seq; Type: SEQUENCE; Schema: public; Owner: vidafacil
1508--
1509
1510CREATE SEQUENCE cliente_id_seq
1511    START WITH 1
1512    INCREMENT BY 1
1513    NO MINVALUE
1514    NO MAXVALUE
1515    CACHE 1;
1516
1517
1518ALTER TABLE cliente_id_seq OWNER TO vidafacil;
1519
1520--
1521-- Name: cliente_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vidafacil
1522--
1523
1524ALTER SEQUENCE cliente_id_seq OWNED BY cliente.id;
1525
1526
1527--
1528-- Name: cobertura_plano_seguro; Type: TABLE; Schema: public; Owner: vidafacil
1529--
1530
1531CREATE TABLE cobertura_plano_seguro (
1532    id bigint NOT NULL,
1533    created timestamp without time zone NOT NULL,
1534    updated timestamp without time zone,
1535    cobertura_relevante boolean,
1536    descricao hstore NOT NULL,
1537    ordem_relevancia integer,
1538    valor numeric,
1539    plano_seguro_id bigint NOT NULL
1540);
1541
1542
1543ALTER TABLE cobertura_plano_seguro OWNER TO vidafacil;
1544
1545--
1546-- Name: cobertura_plano_seguro_id_seq; Type: SEQUENCE; Schema: public; Owner: vidafacil
1547--
1548
1549CREATE SEQUENCE cobertura_plano_seguro_id_seq
1550    START WITH 1
1551    INCREMENT BY 1
1552    NO MINVALUE
1553    NO MAXVALUE
1554    CACHE 1;
1555
1556
1557ALTER TABLE cobertura_plano_seguro_id_seq OWNER TO vidafacil;
1558
1559--
1560-- Name: cobertura_plano_seguro_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vidafacil
1561--
1562
1563ALTER SEQUENCE cobertura_plano_seguro_id_seq OWNED BY cobertura_plano_seguro.id;
1564
1565
1566--
1567-- Name: configuracao_perfil_usuario_plano_seguro; Type: TABLE; Schema: public; Owner: vidafacil
1568--
1569
1570CREATE TABLE configuracao_perfil_usuario_plano_seguro (
1571    id bigint NOT NULL,
1572    created timestamp without time zone NOT NULL,
1573    updated timestamp without time zone,
1574    perfil_usuario_plano_seguro integer NOT NULL,
1575    plano_seguro_id bigint
1576);
1577
1578
1579ALTER TABLE configuracao_perfil_usuario_plano_seguro OWNER TO vidafacil;
1580
1581--
1582-- Name: configuracao_perfil_usuario_plano_seguro_id_seq; Type: SEQUENCE; Schema: public; Owner: vidafacil
1583--
1584
1585CREATE SEQUENCE configuracao_perfil_usuario_plano_seguro_id_seq
1586    START WITH 1
1587    INCREMENT BY 1
1588    NO MINVALUE
1589    NO MAXVALUE
1590    CACHE 1;
1591
1592
1593ALTER TABLE configuracao_perfil_usuario_plano_seguro_id_seq OWNER TO vidafacil;
1594
1595--
1596-- Name: configuracao_perfil_usuario_plano_seguro_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vidafacil
1597--
1598
1599ALTER SEQUENCE configuracao_perfil_usuario_plano_seguro_id_seq OWNED BY configuracao_perfil_usuario_plano_seguro.id;
1600
1601
1602--
1603-- Name: configuracao_plataforma; Type: TABLE; Schema: public; Owner: vidafacil
1604--
1605
1606CREATE TABLE configuracao_plataforma (
1607    id bigint NOT NULL,
1608    created timestamp without time zone NOT NULL,
1609    updated timestamp without time zone,
1610    limite_reenvio_email_rejeicao_cotacao integer,
1611    tempo_reenvio_email_rejeicao_cotacao integer
1612);
1613
1614
1615ALTER TABLE configuracao_plataforma OWNER TO vidafacil;
1616
1617--
1618-- Name: configuracao_plataforma_id_seq; Type: SEQUENCE; Schema: public; Owner: vidafacil
1619--
1620
1621CREATE SEQUENCE configuracao_plataforma_id_seq
1622    START WITH 1
1623    INCREMENT BY 1
1624    NO MINVALUE
1625    NO MAXVALUE
1626    CACHE 1;
1627
1628
1629ALTER TABLE configuracao_plataforma_id_seq OWNER TO vidafacil;
1630
1631--
1632-- Name: configuracao_plataforma_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vidafacil
1633--
1634
1635ALTER SEQUENCE configuracao_plataforma_id_seq OWNED BY configuracao_plataforma.id;
1636
1637
1638--
1639-- Name: conjuge; Type: TABLE; Schema: public; Owner: vidafacil
1640--
1641
1642CREATE TABLE conjuge (
1643    id bigint NOT NULL,
1644    created timestamp without time zone NOT NULL,
1645    updated timestamp without time zone,
1646    data_nascimento timestamp without time zone NOT NULL,
1647    documento character varying(20) NOT NULL,
1648    nome_completo character varying(144) NOT NULL,
1649    especificacao_profissao_outro_conjuge character varying(144),
1650    tipo_documento integer NOT NULL,
1651    profissao_id bigint NOT NULL
1652);
1653
1654
1655ALTER TABLE conjuge OWNER TO vidafacil;
1656
1657--
1658-- Name: conjuge_id_seq; Type: SEQUENCE; Schema: public; Owner: vidafacil
1659--
1660
1661CREATE SEQUENCE conjuge_id_seq
1662    START WITH 1
1663    INCREMENT BY 1
1664    NO MINVALUE
1665    NO MAXVALUE
1666    CACHE 1;
1667
1668
1669ALTER TABLE conjuge_id_seq OWNER TO vidafacil;
1670
1671--
1672-- Name: conjuge_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vidafacil
1673--
1674
1675ALTER SEQUENCE conjuge_id_seq OWNED BY conjuge.id;
1676
1677
1678--
1679-- Name: endereco; Type: TABLE; Schema: public; Owner: vidafacil
1680--
1681
1682CREATE TABLE endereco (
1683    id bigint NOT NULL,
1684    created timestamp without time zone NOT NULL,
1685    updated timestamp without time zone,
1686    bairro character varying(144),
1687    codigo_postal character varying(20),
1688    complemento character varying(144),
1689    logradouro character varying(144) NOT NULL,
1690    numero character varying(6),
1691    cidade_id bigint NOT NULL
1692);
1693
1694
1695ALTER TABLE endereco OWNER TO vidafacil;
1696
1697--
1698-- Name: endereco_id_seq; Type: SEQUENCE; Schema: public; Owner: vidafacil
1699--
1700
1701CREATE SEQUENCE endereco_id_seq
1702    START WITH 1
1703    INCREMENT BY 1
1704    NO MINVALUE
1705    NO MAXVALUE
1706    CACHE 1;
1707
1708
1709ALTER TABLE endereco_id_seq OWNER TO vidafacil;
1710
1711--
1712-- Name: endereco_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vidafacil
1713--
1714
1715ALTER SEQUENCE endereco_id_seq OWNED BY endereco.id;
1716
1717
1718--
1719-- Name: estado; Type: TABLE; Schema: public; Owner: vidafacil
1720--
1721
1722CREATE TABLE estado (
1723    id bigint NOT NULL,
1724    created timestamp without time zone NOT NULL,
1725    updated timestamp without time zone,
1726    nome hstore NOT NULL,
1727    pais_id bigint NOT NULL
1728);
1729
1730
1731ALTER TABLE estado OWNER TO vidafacil;
1732
1733--
1734-- Name: estado_id_seq; Type: SEQUENCE; Schema: public; Owner: vidafacil
1735--
1736
1737CREATE SEQUENCE estado_id_seq
1738    START WITH 1
1739    INCREMENT BY 1
1740    NO MINVALUE
1741    NO MAXVALUE
1742    CACHE 1;
1743
1744
1745ALTER TABLE estado_id_seq OWNER TO vidafacil;
1746
1747--
1748-- Name: estado_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vidafacil
1749--
1750
1751ALTER SEQUENCE estado_id_seq OWNED BY estado.id;
1752
1753
1754--
1755-- Name: executivo; Type: TABLE; Schema: public; Owner: vidafacil
1756--
1757
1758CREATE TABLE executivo (
1759    id bigint NOT NULL,
1760    created timestamp without time zone NOT NULL,
1761    updated timestamp without time zone,
1762    agente_id bigint NOT NULL,
1763    user_id bigint NOT NULL
1764);
1765
1766
1767ALTER TABLE executivo OWNER TO vidafacil;
1768
1769--
1770-- Name: executivo_id_seq; Type: SEQUENCE; Schema: public; Owner: vidafacil
1771--
1772
1773CREATE SEQUENCE executivo_id_seq
1774    START WITH 1
1775    INCREMENT BY 1
1776    NO MINVALUE
1777    NO MAXVALUE
1778    CACHE 1;
1779
1780
1781ALTER TABLE executivo_id_seq OWNER TO vidafacil;
1782
1783--
1784-- Name: executivo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vidafacil
1785--
1786
1787ALTER SEQUENCE executivo_id_seq OWNED BY executivo.id;
1788
1789
1790--
1791-- Name: formulario_perfil_usuario_cotacao_seguro; Type: TABLE; Schema: public; Owner: vidafacil
1792--
1793
1794CREATE TABLE formulario_perfil_usuario_cotacao_seguro (
1795    id bigint NOT NULL,
1796    created timestamp without time zone NOT NULL,
1797    updated timestamp without time zone,
1798    formulario_cotacao_plano_seguro integer NOT NULL,
1799    configuracao_perfil_usuario_plano_seguro_id bigint NOT NULL
1800);
1801
1802
1803ALTER TABLE formulario_perfil_usuario_cotacao_seguro OWNER TO vidafacil;
1804
1805--
1806-- Name: formulario_perfil_usuario_cotacao_seguro_id_seq; Type: SEQUENCE; Schema: public; Owner: vidafacil
1807--
1808
1809CREATE SEQUENCE formulario_perfil_usuario_cotacao_seguro_id_seq
1810    START WITH 1
1811    INCREMENT BY 1
1812    NO MINVALUE
1813    NO MAXVALUE
1814    CACHE 1;
1815
1816
1817ALTER TABLE formulario_perfil_usuario_cotacao_seguro_id_seq OWNER TO vidafacil;
1818
1819--
1820-- Name: formulario_perfil_usuario_cotacao_seguro_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vidafacil
1821--
1822
1823ALTER SEQUENCE formulario_perfil_usuario_cotacao_seguro_id_seq OWNED BY formulario_perfil_usuario_cotacao_seguro.id;
1824
1825
1826--
1827-- Name: grupo_empresa; Type: TABLE; Schema: public; Owner: vidafacil
1828--
1829
1830CREATE TABLE grupo_empresa (
1831    id bigint NOT NULL,
1832    created timestamp without time zone NOT NULL,
1833    updated timestamp without time zone,
1834    nome_fantasia character varying(144) NOT NULL,
1835    responsavel_rh_id bigint NOT NULL,
1836    pagamento_comum boolean NOT NULL
1837);
1838
1839
1840ALTER TABLE grupo_empresa OWNER TO vidafacil;
1841
1842--
1843-- Name: grupo_empresa_id_seq; Type: SEQUENCE; Schema: public; Owner: vidafacil
1844--
1845
1846CREATE SEQUENCE grupo_empresa_id_seq
1847    START WITH 1
1848    INCREMENT BY 1
1849    NO MINVALUE
1850    NO MAXVALUE
1851    CACHE 1;
1852
1853
1854ALTER TABLE grupo_empresa_id_seq OWNER TO vidafacil;
1855
1856--
1857-- Name: grupo_empresa_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vidafacil
1858--
1859
1860ALTER SEQUENCE grupo_empresa_id_seq OWNED BY grupo_empresa.id;
1861
1862
1863--
1864-- Name: historico_apolice_seguro; Type: TABLE; Schema: public; Owner: vidafacil
1865--
1866
1867CREATE TABLE historico_apolice_seguro (
1868    id bigint NOT NULL,
1869    created timestamp without time zone NOT NULL,
1870    updated timestamp without time zone,
1871    data_operacao timestamp without time zone,
1872    operacao_troca_status_apolice_seguro integer NOT NULL,
1873    apolice_seguro_id bigint,
1874    user_id bigint,
1875    observacao character varying
1876);
1877
1878
1879ALTER TABLE historico_apolice_seguro OWNER TO vidafacil;
1880
1881--
1882-- Name: historico_apolice_seguro_id_seq; Type: SEQUENCE; Schema: public; Owner: vidafacil
1883--
1884
1885CREATE SEQUENCE historico_apolice_seguro_id_seq
1886    START WITH 1
1887    INCREMENT BY 1
1888    NO MINVALUE
1889    NO MAXVALUE
1890    CACHE 1;
1891
1892
1893ALTER TABLE historico_apolice_seguro_id_seq OWNER TO vidafacil;
1894
1895--
1896-- Name: historico_apolice_seguro_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vidafacil
1897--
1898
1899ALTER SEQUENCE historico_apolice_seguro_id_seq OWNED BY historico_apolice_seguro.id;
1900
1901
1902--
1903-- Name: historico_solicitacao_cotacao_seguro; Type: TABLE; Schema: public; Owner: vidafacil
1904--
1905
1906CREATE TABLE historico_solicitacao_cotacao_seguro (
1907    id bigint NOT NULL,
1908    created timestamp without time zone NOT NULL,
1909    updated timestamp without time zone,
1910    data_operacao timestamp without time zone,
1911    operacao_troca_status_solicitacao_seguro integer NOT NULL,
1912    observacao character varying(255),
1913    solicitacao_cotacao_seguro_id bigint,
1914    user_id bigint
1915);
1916
1917
1918ALTER TABLE historico_solicitacao_cotacao_seguro OWNER TO vidafacil;
1919
1920--
1921-- Name: historico_solicitacao_cotacao_seguro_id_seq; Type: SEQUENCE; Schema: public; Owner: vidafacil
1922--
1923
1924CREATE SEQUENCE historico_solicitacao_cotacao_seguro_id_seq
1925    START WITH 1
1926    INCREMENT BY 1
1927    NO MINVALUE
1928    NO MAXVALUE
1929    CACHE 1;
1930
1931
1932ALTER TABLE historico_solicitacao_cotacao_seguro_id_seq OWNER TO vidafacil;
1933
1934--
1935-- Name: historico_solicitacao_cotacao_seguro_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vidafacil
1936--
1937
1938ALTER SEQUENCE historico_solicitacao_cotacao_seguro_id_seq OWNED BY historico_solicitacao_cotacao_seguro.id;
1939
1940
1941--
1942-- Name: pais; Type: TABLE; Schema: public; Owner: vidafacil
1943--
1944
1945CREATE TABLE pais (
1946    id bigint NOT NULL,
1947    created timestamp without time zone NOT NULL,
1948    updated timestamp without time zone,
1949    nome hstore NOT NULL
1950);
1951
1952
1953ALTER TABLE pais OWNER TO vidafacil;
1954
1955--
1956-- Name: pais_id_seq; Type: SEQUENCE; Schema: public; Owner: vidafacil
1957--
1958
1959CREATE SEQUENCE pais_id_seq
1960    START WITH 1
1961    INCREMENT BY 1
1962    NO MINVALUE
1963    NO MAXVALUE
1964    CACHE 1;
1965
1966
1967ALTER TABLE pais_id_seq OWNER TO vidafacil;
1968
1969--
1970-- Name: pais_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vidafacil
1971--
1972
1973ALTER SEQUENCE pais_id_seq OWNED BY pais.id;
1974
1975
1976--
1977-- Name: perfil_acesso; Type: TABLE; Schema: public; Owner: vidafacil
1978--
1979
1980CREATE TABLE perfil_acesso (
1981    id bigint NOT NULL,
1982    created timestamp without time zone NOT NULL,
1983    updated timestamp without time zone,
1984    descricao hstore,
1985    editavel boolean NOT NULL,
1986    nome hstore NOT NULL,
1987    removivel boolean NOT NULL
1988);
1989
1990
1991ALTER TABLE perfil_acesso OWNER TO vidafacil;
1992
1993--
1994-- Name: perfil_acesso_id_seq; Type: SEQUENCE; Schema: public; Owner: vidafacil
1995--
1996
1997CREATE SEQUENCE perfil_acesso_id_seq
1998    START WITH 1
1999    INCREMENT BY 1
2000    NO MINVALUE
2001    NO MAXVALUE
2002    CACHE 1;
2003
2004
2005ALTER TABLE perfil_acesso_id_seq OWNER TO vidafacil;
2006
2007--
2008-- Name: perfil_acesso_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vidafacil
2009--
2010
2011ALTER SEQUENCE perfil_acesso_id_seq OWNED BY perfil_acesso.id;
2012
2013
2014--
2015-- Name: perfil_acesso_permissao; Type: TABLE; Schema: public; Owner: vidafacil
2016--
2017
2018CREATE TABLE perfil_acesso_permissao (
2019    id bigint NOT NULL,
2020    created timestamp without time zone NOT NULL,
2021    updated timestamp without time zone,
2022    permissao_identificador character varying(255) NOT NULL,
2023    perfil_acesso_id bigint
2024);
2025
2026
2027ALTER TABLE perfil_acesso_permissao OWNER TO vidafacil;
2028
2029--
2030-- Name: perfil_acesso_permissao_id_seq; Type: SEQUENCE; Schema: public; Owner: vidafacil
2031--
2032
2033CREATE SEQUENCE perfil_acesso_permissao_id_seq
2034    START WITH 1
2035    INCREMENT BY 1
2036    NO MINVALUE
2037    NO MAXVALUE
2038    CACHE 1;
2039
2040
2041ALTER TABLE perfil_acesso_permissao_id_seq OWNER TO vidafacil;
2042
2043--
2044-- Name: perfil_acesso_permissao_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vidafacil
2045--
2046
2047ALTER SEQUENCE perfil_acesso_permissao_id_seq OWNED BY perfil_acesso_permissao.id;
2048
2049
2050--
2051-- Name: plano_seguro; Type: TABLE; Schema: public; Owner: vidafacil
2052--
2053
2054CREATE TABLE plano_seguro (
2055    id bigint NOT NULL,
2056    created timestamp without time zone NOT NULL,
2057    updated timestamp without time zone,
2058    descricao hstore,
2059    nome hstore NOT NULL,
2060    ordem_relevancia integer,
2061    permite_incluir_conjuge boolean,
2062    valor numeric,
2063    produto_seguro_id bigint NOT NULL
2064);
2065
2066
2067ALTER TABLE plano_seguro OWNER TO vidafacil;
2068
2069--
2070-- Name: plano_seguro_id_seq; Type: SEQUENCE; Schema: public; Owner: vidafacil
2071--
2072
2073CREATE SEQUENCE plano_seguro_id_seq
2074    START WITH 1
2075    INCREMENT BY 1
2076    NO MINVALUE
2077    NO MAXVALUE
2078    CACHE 1;
2079
2080
2081ALTER TABLE plano_seguro_id_seq OWNER TO vidafacil;
2082
2083--
2084-- Name: plano_seguro_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vidafacil
2085--
2086
2087ALTER SEQUENCE plano_seguro_id_seq OWNED BY plano_seguro.id;
2088
2089
2090--
2091-- Name: produto_seguro; Type: TABLE; Schema: public; Owner: vidafacil
2092--
2093
2094CREATE TABLE produto_seguro (
2095    id bigint NOT NULL,
2096    created timestamp without time zone NOT NULL,
2097    updated timestamp without time zone,
2098    nome hstore NOT NULL,
2099    ordem_relevancia integer
2100);
2101
2102
2103ALTER TABLE produto_seguro OWNER TO vidafacil;
2104
2105--
2106-- Name: produto_seguro_id_seq; Type: SEQUENCE; Schema: public; Owner: vidafacil
2107--
2108
2109CREATE SEQUENCE produto_seguro_id_seq
2110    START WITH 1
2111    INCREMENT BY 1
2112    NO MINVALUE
2113    NO MAXVALUE
2114    CACHE 1;
2115
2116
2117ALTER TABLE produto_seguro_id_seq OWNER TO vidafacil;
2118
2119--
2120-- Name: produto_seguro_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vidafacil
2121--
2122
2123ALTER SEQUENCE produto_seguro_id_seq OWNED BY produto_seguro.id;
2124
2125
2126--
2127-- Name: profissao; Type: TABLE; Schema: public; Owner: vidafacil
2128--
2129
2130CREATE TABLE profissao (
2131    id bigint NOT NULL,
2132    created timestamp without time zone NOT NULL,
2133    updated timestamp without time zone,
2134    descricao hstore NOT NULL
2135);
2136
2137
2138ALTER TABLE profissao OWNER TO vidafacil;
2139
2140--
2141-- Name: profissao_id_seq; Type: SEQUENCE; Schema: public; Owner: vidafacil
2142--
2143
2144CREATE SEQUENCE profissao_id_seq
2145    START WITH 1
2146    INCREMENT BY 1
2147    NO MINVALUE
2148    NO MAXVALUE
2149    CACHE 1;
2150
2151
2152ALTER TABLE profissao_id_seq OWNER TO vidafacil;
2153
2154--
2155-- Name: profissao_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vidafacil
2156--
2157
2158ALTER SEQUENCE profissao_id_seq OWNED BY profissao.id;
2159
2160
2161--
2162-- Name: profissao_restricao_plano_seguro; Type: TABLE; Schema: public; Owner: vidafacil
2163--
2164
2165CREATE TABLE profissao_restricao_plano_seguro (
2166    id bigint NOT NULL,
2167    created timestamp without time zone NOT NULL,
2168    updated timestamp without time zone,
2169    plano_seguro_id bigint,
2170    profissao_id bigint
2171);
2172
2173
2174ALTER TABLE profissao_restricao_plano_seguro OWNER TO vidafacil;
2175
2176--
2177-- Name: profissao_restricao_plano_seguro_id_seq; Type: SEQUENCE; Schema: public; Owner: vidafacil
2178--
2179
2180CREATE SEQUENCE profissao_restricao_plano_seguro_id_seq
2181    START WITH 1
2182    INCREMENT BY 1
2183    NO MINVALUE
2184    NO MAXVALUE
2185    CACHE 1;
2186
2187
2188ALTER TABLE profissao_restricao_plano_seguro_id_seq OWNER TO vidafacil;
2189
2190--
2191-- Name: profissao_restricao_plano_seguro_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vidafacil
2192--
2193
2194ALTER SEQUENCE profissao_restricao_plano_seguro_id_seq OWNED BY profissao_restricao_plano_seguro.id;
2195
2196
2197--
2198-- Name: schema_version; Type: TABLE; Schema: public; Owner: vidafacil
2199--
2200
2201CREATE TABLE schema_version (
2202    installed_rank integer NOT NULL,
2203    version character varying(50),
2204    description character varying(200) NOT NULL,
2205    type character varying(20) NOT NULL,
2206    script character varying(1000) NOT NULL,
2207    checksum integer,
2208    installed_by character varying(100) NOT NULL,
2209    installed_on timestamp without time zone DEFAULT now() NOT NULL,
2210    execution_time integer NOT NULL,
2211    success boolean NOT NULL
2212);
2213
2214
2215ALTER TABLE schema_version OWNER TO vidafacil;
2216
2217--
2218-- Name: solicitacao_cotacao_seguro; Type: TABLE; Schema: public; Owner: vidafacil
2219--
2220
2221CREATE TABLE solicitacao_cotacao_seguro (
2222    id bigint NOT NULL,
2223    created timestamp without time zone NOT NULL,
2224    updated timestamp without time zone,
2225    celular character varying(15) NOT NULL,
2226    data_nascimento timestamp without time zone NOT NULL,
2227    documento character varying(20) NOT NULL,
2228    email character varying(50) NOT NULL,
2229    estado_civil integer NOT NULL,
2230    forma_pagamento integer,
2231    incluir_conjuge_cobertura boolean,
2232    nome character varying(144) NOT NULL,
2233    numero_solicitacao character varying(144),
2234    sexo integer NOT NULL,
2235    situacao_solicitacao_cotacao_seguro integer NOT NULL,
2236    sobrenome character varying(144) NOT NULL,
2237    telefone_residencial character varying(15),
2238    telefone_trabalho character varying(15),
2239    tipo_documento integer NOT NULL,
2240    uso_de_motocicleta boolean,
2241    valor_mensal numeric(19,2),
2242    whatsapp character varying(15),
2243    agente_autorizado_id bigint,
2244    apolice_seguro_id bigint,
2245    cartao_credito_id bigint,
2246    conjuge_id bigint,
2247    endereco_residencial_id bigint,
2248    endereco_trabalho_id bigint,
2249    executivo_id bigint,
2250    grupo_empresa_id bigint,
2251    plano_seguro_id bigint NOT NULL,
2252    profissao_id bigint,
2253    edit_token character varying(144),
2254    especificacao_profissao_outro character varying(144),
2255    especificacao_profissao_outro_conjuge character varying(144)
2256);
2257
2258
2259ALTER TABLE solicitacao_cotacao_seguro OWNER TO vidafacil;
2260
2261--
2262-- Name: solicitacao_cotacao_seguro_id_seq; Type: SEQUENCE; Schema: public; Owner: vidafacil
2263--
2264
2265CREATE SEQUENCE solicitacao_cotacao_seguro_id_seq
2266    START WITH 1
2267    INCREMENT BY 1
2268    NO MINVALUE
2269    NO MAXVALUE
2270    CACHE 1;
2271
2272
2273ALTER TABLE solicitacao_cotacao_seguro_id_seq OWNER TO vidafacil;
2274
2275--
2276-- Name: solicitacao_cotacao_seguro_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vidafacil
2277--
2278
2279ALTER SEQUENCE solicitacao_cotacao_seguro_id_seq OWNED BY solicitacao_cotacao_seguro.id;
2280
2281
2282--
2283-- Name: tutor; Type: TABLE; Schema: public; Owner: vidafacil
2284--
2285
2286CREATE TABLE tutor (
2287    id bigint NOT NULL,
2288    created timestamp without time zone NOT NULL,
2289    updated timestamp without time zone,
2290    documento character varying(20) NOT NULL,
2291    grau_parentesco integer NOT NULL,
2292    nome_completo character varying(144) NOT NULL,
2293    tipo_documento integer NOT NULL,
2294    data_nascimento timestamp without time zone NOT NULL
2295);
2296
2297
2298ALTER TABLE tutor OWNER TO vidafacil;
2299
2300--
2301-- Name: tutor_id_seq; Type: SEQUENCE; Schema: public; Owner: vidafacil
2302--
2303
2304CREATE SEQUENCE tutor_id_seq
2305    START WITH 1
2306    INCREMENT BY 1
2307    NO MINVALUE
2308    NO MAXVALUE
2309    CACHE 1;
2310
2311
2312ALTER TABLE tutor_id_seq OWNER TO vidafacil;
2313
2314--
2315-- Name: tutor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vidafacil
2316--
2317
2318ALTER SEQUENCE tutor_id_seq OWNED BY tutor.id;
2319
2320
2321--
2322-- Name: user; Type: TABLE; Schema: public; Owner: vidafacil
2323--
2324
2325CREATE TABLE "user" (
2326    id bigint NOT NULL,
2327    created timestamp with time zone NOT NULL,
2328    updated timestamp with time zone,
2329    disabled boolean NOT NULL,
2330    email character varying(144) NOT NULL,
2331    last_login timestamp with time zone,
2332    name character varying(50) NOT NULL,
2333    password character varying(100) NOT NULL,
2334    sobrenome character varying(144),
2335    role integer NOT NULL,
2336    password_reset_token character varying,
2337    password_reset_token_expiration timestamp with time zone
2338);
2339
2340
2341ALTER TABLE "user" OWNER TO vidafacil;
2342
2343--
2344-- Name: user_id_seq; Type: SEQUENCE; Schema: public; Owner: vidafacil
2345--
2346
2347CREATE SEQUENCE user_id_seq
2348    START WITH 1
2349    INCREMENT BY 1
2350    NO MINVALUE
2351    NO MAXVALUE
2352    CACHE 1;
2353
2354
2355ALTER TABLE user_id_seq OWNER TO vidafacil;
2356
2357--
2358-- Name: user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vidafacil
2359--
2360
2361ALTER SEQUENCE user_id_seq OWNED BY "user".id;
2362
2363
2364--
2365-- Name: usuario_perfil_acesso; Type: TABLE; Schema: public; Owner: vidafacil
2366--
2367
2368CREATE TABLE usuario_perfil_acesso (
2369    id bigint NOT NULL,
2370    created timestamp without time zone NOT NULL,
2371    updated timestamp without time zone,
2372    perfil_acesso_id bigint,
2373    user_id bigint
2374);
2375
2376
2377ALTER TABLE usuario_perfil_acesso OWNER TO vidafacil;
2378
2379--
2380-- Name: usuario_perfil_acesso_id_seq; Type: SEQUENCE; Schema: public; Owner: vidafacil
2381--
2382
2383CREATE SEQUENCE usuario_perfil_acesso_id_seq
2384    START WITH 1
2385    INCREMENT BY 1
2386    NO MINVALUE
2387    NO MAXVALUE
2388    CACHE 1;
2389
2390
2391ALTER TABLE usuario_perfil_acesso_id_seq OWNER TO vidafacil;
2392
2393--
2394-- Name: usuario_perfil_acesso_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: vidafacil
2395--
2396
2397ALTER SEQUENCE usuario_perfil_acesso_id_seq OWNED BY usuario_perfil_acesso.id;
2398
2399
2400SET search_path = auditing, pg_catalog;
2401
2402--
2403-- Name: agente_audited id; Type: DEFAULT; Schema: auditing; Owner: vidafacil
2404--
2405
2406ALTER TABLE ONLY agente_audited ALTER COLUMN id SET DEFAULT nextval('agente_audited_id_seq'::regclass);
2407
2408
2409--
2410-- Name: apolice_seguro_audited id; Type: DEFAULT; Schema: auditing; Owner: vidafacil
2411--
2412
2413ALTER TABLE ONLY apolice_seguro_audited ALTER COLUMN id SET DEFAULT nextval('apolice_seguro_audited_id_seq'::regclass);
2414
2415
2416--
2417-- Name: beneficiario_audited id; Type: DEFAULT; Schema: auditing; Owner: vidafacil
2418--
2419
2420ALTER TABLE ONLY beneficiario_audited ALTER COLUMN id SET DEFAULT nextval('beneficiario_audited_id_seq'::regclass);
2421
2422
2423--
2424-- Name: beneficiario_audited numero; Type: DEFAULT; Schema: auditing; Owner: vidafacil
2425--
2426
2427ALTER TABLE ONLY beneficiario_audited ALTER COLUMN numero SET DEFAULT nextval('beneficiario_audited_numero_seq'::regclass);
2428
2429
2430--
2431-- Name: cartao_credito_audited id; Type: DEFAULT; Schema: auditing; Owner: vidafacil
2432--
2433
2434ALTER TABLE ONLY cartao_credito_audited ALTER COLUMN id SET DEFAULT nextval('cartao_credito_audited_id_seq'::regclass);
2435
2436
2437--
2438-- Name: cidade_audited id; Type: DEFAULT; Schema: auditing; Owner: vidafacil
2439--
2440
2441ALTER TABLE ONLY cidade_audited ALTER COLUMN id SET DEFAULT nextval('cidade_audited_id_seq'::regclass);
2442
2443
2444--
2445-- Name: cliente_audited id; Type: DEFAULT; Schema: auditing; Owner: vidafacil
2446--
2447
2448ALTER TABLE ONLY cliente_audited ALTER COLUMN id SET DEFAULT nextval('cliente_audited_id_seq'::regclass);
2449
2450
2451--
2452-- Name: cobertura_plano_seguro_audited id; Type: DEFAULT; Schema: auditing; Owner: vidafacil
2453--
2454
2455ALTER TABLE ONLY cobertura_plano_seguro_audited ALTER COLUMN id SET DEFAULT nextval('cobertura_plano_seguro_audited_id_seq'::regclass);
2456
2457
2458--
2459-- Name: configuracao_perfil_usuario_plano_seguro_audited id; Type: DEFAULT; Schema: auditing; Owner: vidafacil
2460--
2461
2462ALTER TABLE ONLY configuracao_perfil_usuario_plano_seguro_audited ALTER COLUMN id SET DEFAULT nextval('configuracao_perfil_usuario_plano_seguro_audited_id_seq'::regclass);
2463
2464
2465--
2466-- Name: configuracao_plataforma_audited id; Type: DEFAULT; Schema: auditing; Owner: vidafacil
2467--
2468
2469ALTER TABLE ONLY configuracao_plataforma_audited ALTER COLUMN id SET DEFAULT nextval('configuracao_plataforma_audited_id_seq'::regclass);
2470
2471
2472--
2473-- Name: conjuge_audited id; Type: DEFAULT; Schema: auditing; Owner: vidafacil
2474--
2475
2476ALTER TABLE ONLY conjuge_audited ALTER COLUMN id SET DEFAULT nextval('conjuge_audited_id_seq'::regclass);
2477
2478
2479--
2480-- Name: endereco_audited id; Type: DEFAULT; Schema: auditing; Owner: vidafacil
2481--
2482
2483ALTER TABLE ONLY endereco_audited ALTER COLUMN id SET DEFAULT nextval('endereco_audited_id_seq'::regclass);
2484
2485
2486--
2487-- Name: estado_audited id; Type: DEFAULT; Schema: auditing; Owner: vidafacil
2488--
2489
2490ALTER TABLE ONLY estado_audited ALTER COLUMN id SET DEFAULT nextval('estado_audited_id_seq'::regclass);
2491
2492
2493--
2494-- Name: executivo_audited id; Type: DEFAULT; Schema: auditing; Owner: vidafacil
2495--
2496
2497ALTER TABLE ONLY executivo_audited ALTER COLUMN id SET DEFAULT nextval('executivo_audited_id_seq'::regclass);
2498
2499
2500--
2501-- Name: formulario_perfil_usuario_cotacao_seguro_audited id; Type: DEFAULT; Schema: auditing; Owner: vidafacil
2502--
2503
2504ALTER TABLE ONLY formulario_perfil_usuario_cotacao_seguro_audited ALTER COLUMN id SET DEFAULT nextval('formulario_perfil_usuario_cotacao_seguro_audited_id_seq'::regclass);
2505
2506
2507--
2508-- Name: grupo_empresa_audited id; Type: DEFAULT; Schema: auditing; Owner: vidafacil
2509--
2510
2511ALTER TABLE ONLY grupo_empresa_audited ALTER COLUMN id SET DEFAULT nextval('grupo_empresa_audited_id_seq'::regclass);
2512
2513
2514--
2515-- Name: historico_apolice_seguro_audited id; Type: DEFAULT; Schema: auditing; Owner: vidafacil
2516--
2517
2518ALTER TABLE ONLY historico_apolice_seguro_audited ALTER COLUMN id SET DEFAULT nextval('historico_apolice_seguro_audited_id_seq'::regclass);
2519
2520
2521--
2522-- Name: historico_solicitacao_cotacao_seguro_audited id; Type: DEFAULT; Schema: auditing; Owner: vidafacil
2523--
2524
2525ALTER TABLE ONLY historico_solicitacao_cotacao_seguro_audited ALTER COLUMN id SET DEFAULT nextval('historico_solicitacao_cotacao_seguro_audited_id_seq'::regclass);
2526
2527
2528--
2529-- Name: pais_audited id; Type: DEFAULT; Schema: auditing; Owner: vidafacil
2530--
2531
2532ALTER TABLE ONLY pais_audited ALTER COLUMN id SET DEFAULT nextval('pais_audited_id_seq'::regclass);
2533
2534
2535--
2536-- Name: perfil_acesso_audited id; Type: DEFAULT; Schema: auditing; Owner: vidafacil
2537--
2538
2539ALTER TABLE ONLY perfil_acesso_audited ALTER COLUMN id SET DEFAULT nextval('perfil_acesso_audited_id_seq'::regclass);
2540
2541
2542--
2543-- Name: perfil_acesso_permissao_audited id; Type: DEFAULT; Schema: auditing; Owner: vidafacil
2544--
2545
2546ALTER TABLE ONLY perfil_acesso_permissao_audited ALTER COLUMN id SET DEFAULT nextval('perfil_acesso_permissao_audited_id_seq'::regclass);
2547
2548
2549--
2550-- Name: plano_seguro_audited id; Type: DEFAULT; Schema: auditing; Owner: vidafacil
2551--
2552
2553ALTER TABLE ONLY plano_seguro_audited ALTER COLUMN id SET DEFAULT nextval('plano_seguro_audited_id_seq'::regclass);
2554
2555
2556--
2557-- Name: produto_seguro_audited id; Type: DEFAULT; Schema: auditing; Owner: vidafacil
2558--
2559
2560ALTER TABLE ONLY produto_seguro_audited ALTER COLUMN id SET DEFAULT nextval('produto_seguro_audited_id_seq'::regclass);
2561
2562
2563--
2564-- Name: profissao_audited id; Type: DEFAULT; Schema: auditing; Owner: vidafacil
2565--
2566
2567ALTER TABLE ONLY profissao_audited ALTER COLUMN id SET DEFAULT nextval('profissao_audited_id_seq'::regclass);
2568
2569
2570--
2571-- Name: profissao_restricao_plano_seguro_audited id; Type: DEFAULT; Schema: auditing; Owner: vidafacil
2572--
2573
2574ALTER TABLE ONLY profissao_restricao_plano_seguro_audited ALTER COLUMN id SET DEFAULT nextval('profissao_restricao_plano_seguro_audited_id_seq'::regclass);
2575
2576
2577--
2578-- Name: revision id; Type: DEFAULT; Schema: auditing; Owner: vidafacil
2579--
2580
2581ALTER TABLE ONLY revision ALTER COLUMN id SET DEFAULT nextval('revision_id_seq'::regclass);
2582
2583
2584--
2585-- Name: solicitacao_cotacao_seguro_audited id; Type: DEFAULT; Schema: auditing; Owner: vidafacil
2586--
2587
2588ALTER TABLE ONLY solicitacao_cotacao_seguro_audited ALTER COLUMN id SET DEFAULT nextval('solicitacao_cotacao_seguro_audited_id_seq'::regclass);
2589
2590
2591--
2592-- Name: tutor_audited id; Type: DEFAULT; Schema: auditing; Owner: vidafacil
2593--
2594
2595ALTER TABLE ONLY tutor_audited ALTER COLUMN id SET DEFAULT nextval('tutor_audited_id_seq'::regclass);
2596
2597
2598--
2599-- Name: usuario_perfil_acesso_audited id; Type: DEFAULT; Schema: auditing; Owner: vidafacil
2600--
2601
2602ALTER TABLE ONLY usuario_perfil_acesso_audited ALTER COLUMN id SET DEFAULT nextval('usuario_perfil_acesso_audited_id_seq'::regclass);
2603
2604
2605SET search_path = public, pg_catalog;
2606
2607--
2608-- Name: agente id; Type: DEFAULT; Schema: public; Owner: vidafacil
2609--
2610
2611ALTER TABLE ONLY agente ALTER COLUMN id SET DEFAULT nextval('agente_id_seq'::regclass);
2612
2613
2614--
2615-- Name: apolice_seguro id; Type: DEFAULT; Schema: public; Owner: vidafacil
2616--
2617
2618ALTER TABLE ONLY apolice_seguro ALTER COLUMN id SET DEFAULT nextval('apolice_seguro_id_seq'::regclass);
2619
2620
2621--
2622-- Name: beneficiario id; Type: DEFAULT; Schema: public; Owner: vidafacil
2623--
2624
2625ALTER TABLE ONLY beneficiario ALTER COLUMN id SET DEFAULT nextval('beneficiario_id_seq'::regclass);
2626
2627
2628--
2629-- Name: beneficiario numero; Type: DEFAULT; Schema: public; Owner: vidafacil
2630--
2631
2632ALTER TABLE ONLY beneficiario ALTER COLUMN numero SET DEFAULT nextval('beneficiario_numero_seq'::regclass);
2633
2634
2635--
2636-- Name: cartao_credito id; Type: DEFAULT; Schema: public; Owner: vidafacil
2637--
2638
2639ALTER TABLE ONLY cartao_credito ALTER COLUMN id SET DEFAULT nextval('cartao_credito_id_seq'::regclass);
2640
2641
2642--
2643-- Name: cidade id; Type: DEFAULT; Schema: public; Owner: vidafacil
2644--
2645
2646ALTER TABLE ONLY cidade ALTER COLUMN id SET DEFAULT nextval('cidade_id_seq'::regclass);
2647
2648
2649--
2650-- Name: cliente id; Type: DEFAULT; Schema: public; Owner: vidafacil
2651--
2652
2653ALTER TABLE ONLY cliente ALTER COLUMN id SET DEFAULT nextval('cliente_id_seq'::regclass);
2654
2655
2656--
2657-- Name: cobertura_plano_seguro id; Type: DEFAULT; Schema: public; Owner: vidafacil
2658--
2659
2660ALTER TABLE ONLY cobertura_plano_seguro ALTER COLUMN id SET DEFAULT nextval('cobertura_plano_seguro_id_seq'::regclass);
2661
2662
2663--
2664-- Name: configuracao_perfil_usuario_plano_seguro id; Type: DEFAULT; Schema: public; Owner: vidafacil
2665--
2666
2667ALTER TABLE ONLY configuracao_perfil_usuario_plano_seguro ALTER COLUMN id SET DEFAULT nextval('configuracao_perfil_usuario_plano_seguro_id_seq'::regclass);
2668
2669
2670--
2671-- Name: configuracao_plataforma id; Type: DEFAULT; Schema: public; Owner: vidafacil
2672--
2673
2674ALTER TABLE ONLY configuracao_plataforma ALTER COLUMN id SET DEFAULT nextval('configuracao_plataforma_id_seq'::regclass);
2675
2676
2677--
2678-- Name: conjuge id; Type: DEFAULT; Schema: public; Owner: vidafacil
2679--
2680
2681ALTER TABLE ONLY conjuge ALTER COLUMN id SET DEFAULT nextval('conjuge_id_seq'::regclass);
2682
2683
2684--
2685-- Name: endereco id; Type: DEFAULT; Schema: public; Owner: vidafacil
2686--
2687
2688ALTER TABLE ONLY endereco ALTER COLUMN id SET DEFAULT nextval('endereco_id_seq'::regclass);
2689
2690
2691--
2692-- Name: estado id; Type: DEFAULT; Schema: public; Owner: vidafacil
2693--
2694
2695ALTER TABLE ONLY estado ALTER COLUMN id SET DEFAULT nextval('estado_id_seq'::regclass);
2696
2697
2698--
2699-- Name: executivo id; Type: DEFAULT; Schema: public; Owner: vidafacil
2700--
2701
2702ALTER TABLE ONLY executivo ALTER COLUMN id SET DEFAULT nextval('executivo_id_seq'::regclass);
2703
2704
2705--
2706-- Name: formulario_perfil_usuario_cotacao_seguro id; Type: DEFAULT; Schema: public; Owner: vidafacil
2707--
2708
2709ALTER TABLE ONLY formulario_perfil_usuario_cotacao_seguro ALTER COLUMN id SET DEFAULT nextval('formulario_perfil_usuario_cotacao_seguro_id_seq'::regclass);
2710
2711
2712--
2713-- Name: grupo_empresa id; Type: DEFAULT; Schema: public; Owner: vidafacil
2714--
2715
2716ALTER TABLE ONLY grupo_empresa ALTER COLUMN id SET DEFAULT nextval('grupo_empresa_id_seq'::regclass);
2717
2718
2719--
2720-- Name: historico_apolice_seguro id; Type: DEFAULT; Schema: public; Owner: vidafacil
2721--
2722
2723ALTER TABLE ONLY historico_apolice_seguro ALTER COLUMN id SET DEFAULT nextval('historico_apolice_seguro_id_seq'::regclass);
2724
2725
2726--
2727-- Name: historico_solicitacao_cotacao_seguro id; Type: DEFAULT; Schema: public; Owner: vidafacil
2728--
2729
2730ALTER TABLE ONLY historico_solicitacao_cotacao_seguro ALTER COLUMN id SET DEFAULT nextval('historico_solicitacao_cotacao_seguro_id_seq'::regclass);
2731
2732
2733--
2734-- Name: pais id; Type: DEFAULT; Schema: public; Owner: vidafacil
2735--
2736
2737ALTER TABLE ONLY pais ALTER COLUMN id SET DEFAULT nextval('pais_id_seq'::regclass);
2738
2739
2740--
2741-- Name: perfil_acesso id; Type: DEFAULT; Schema: public; Owner: vidafacil
2742--
2743
2744ALTER TABLE ONLY perfil_acesso ALTER COLUMN id SET DEFAULT nextval('perfil_acesso_id_seq'::regclass);
2745
2746
2747--
2748-- Name: perfil_acesso_permissao id; Type: DEFAULT; Schema: public; Owner: vidafacil
2749--
2750
2751ALTER TABLE ONLY perfil_acesso_permissao ALTER COLUMN id SET DEFAULT nextval('perfil_acesso_permissao_id_seq'::regclass);
2752
2753
2754--
2755-- Name: plano_seguro id; Type: DEFAULT; Schema: public; Owner: vidafacil
2756--
2757
2758ALTER TABLE ONLY plano_seguro ALTER COLUMN id SET DEFAULT nextval('plano_seguro_id_seq'::regclass);
2759
2760
2761--
2762-- Name: produto_seguro id; Type: DEFAULT; Schema: public; Owner: vidafacil
2763--
2764
2765ALTER TABLE ONLY produto_seguro ALTER COLUMN id SET DEFAULT nextval('produto_seguro_id_seq'::regclass);
2766
2767
2768--
2769-- Name: profissao id; Type: DEFAULT; Schema: public; Owner: vidafacil
2770--
2771
2772ALTER TABLE ONLY profissao ALTER COLUMN id SET DEFAULT nextval('profissao_id_seq'::regclass);
2773
2774
2775--
2776-- Name: profissao_restricao_plano_seguro id; Type: DEFAULT; Schema: public; Owner: vidafacil
2777--
2778
2779ALTER TABLE ONLY profissao_restricao_plano_seguro ALTER COLUMN id SET DEFAULT nextval('profissao_restricao_plano_seguro_id_seq'::regclass);
2780
2781
2782--
2783-- Name: solicitacao_cotacao_seguro id; Type: DEFAULT; Schema: public; Owner: vidafacil
2784--
2785
2786ALTER TABLE ONLY solicitacao_cotacao_seguro ALTER COLUMN id SET DEFAULT nextval('solicitacao_cotacao_seguro_id_seq'::regclass);
2787
2788
2789--
2790-- Name: tutor id; Type: DEFAULT; Schema: public; Owner: vidafacil
2791--
2792
2793ALTER TABLE ONLY tutor ALTER COLUMN id SET DEFAULT nextval('tutor_id_seq'::regclass);
2794
2795
2796--
2797-- Name: user id; Type: DEFAULT; Schema: public; Owner: vidafacil
2798--
2799
2800ALTER TABLE ONLY "user" ALTER COLUMN id SET DEFAULT nextval('user_id_seq'::regclass);
2801
2802
2803--
2804-- Name: usuario_perfil_acesso id; Type: DEFAULT; Schema: public; Owner: vidafacil
2805--
2806
2807ALTER TABLE ONLY usuario_perfil_acesso ALTER COLUMN id SET DEFAULT nextval('usuario_perfil_acesso_id_seq'::regclass);
2808
2809
2810SET search_path = auditing, pg_catalog;
2811
2812--
2813-- Data for Name: agente_audited; Type: TABLE DATA; Schema: auditing; Owner: vidafacil
2814--
2815
2816COPY agente_audited (id, revision, revision_type, user_id) FROM stdin;
2817\.
2818
2819
2820--
2821-- Name: agente_audited_id_seq; Type: SEQUENCE SET; Schema: auditing; Owner: vidafacil
2822--
2823
2824SELECT pg_catalog.setval('agente_audited_id_seq', 1, false);
2825
2826
2827--
2828-- Data for Name: apolice_seguro_audited; Type: TABLE DATA; Schema: auditing; Owner: vidafacil
2829--
2830
2831COPY apolice_seguro_audited (id, revision, revision_type, forma_pagamento, incluir_conjuge_na_cobertura, numero_apolice, valor_mensal, agente_id, cartao_credito_id, cliente_id, executivo_id, grupo_empresa_id, plano_seguro_id, uso_de_motocicleta, status_apolice_seguro, solicitacao_cotacao_seguro_id) FROM stdin;
28321001	12	1	1	f	1011	8989.00	9999	\N	1000	1001	1000	1000	f	1	1000
28331	18	0	1	f	\N	30.00	\N	\N	1	1002	\N	1007	f	0	1001
2834\.
2835
2836
2837--
2838-- Name: apolice_seguro_audited_id_seq; Type: SEQUENCE SET; Schema: auditing; Owner: vidafacil
2839--
2840
2841SELECT pg_catalog.setval('apolice_seguro_audited_id_seq', 1, false);
2842
2843
2844--
2845-- Data for Name: beneficiario_audited; Type: TABLE DATA; Schema: auditing; Owner: vidafacil
2846--
2847
2848COPY beneficiario_audited (id, revision, revision_type, data_nascimento, documento, grau_parentesco, nome_completo, numero, percentual_participacao, tipo_documento, solicitacao_cotacao_seguro_id, tutor_id, apolice_seguro_id) FROM stdin;
28491006	18	1	2018-03-29 15:14:36.104139	123456789	0	Bela	1	11	1	1001	1001	1
28505	24	0	1962-04-01 03:00:00	64565546546	1	Gilberto	5	100	0	3	\N	\N
28517	49	0	1992-12-29 23:00:00	1231231232	2	Beneficiario Teste	6	100	0	4	\N	\N
285210	55	0	1962-04-01 18:00:00	12321231123123	1	Gilberto Fracaroli	9	100	0	5	\N	\N
285311	57	0	1992-11-19 07:00:00	2312312312312	0	Smiles Sil	10	100	1	6	\N	\N
2854\.
2855
2856
2857--
2858-- Name: beneficiario_audited_id_seq; Type: SEQUENCE SET; Schema: auditing; Owner: vidafacil
2859--
2860
2861SELECT pg_catalog.setval('beneficiario_audited_id_seq', 1, false);
2862
2863
2864--
2865-- Name: beneficiario_audited_numero_seq; Type: SEQUENCE SET; Schema: auditing; Owner: vidafacil
2866--
2867
2868SELECT pg_catalog.setval('beneficiario_audited_numero_seq', 1, false);
2869
2870
2871--
2872-- Data for Name: cartao_credito_audited; Type: TABLE DATA; Schema: auditing; Owner: vidafacil
2873--
2874
2875COPY cartao_credito_audited (id, revision, revision_type, bandeira_cartao, codigo_seguranca, documento_titular, nome_titular, numero, processadora_cartao, mes, ano) FROM stdin;
2876\.
2877
2878
2879--
2880-- Name: cartao_credito_audited_id_seq; Type: SEQUENCE SET; Schema: auditing; Owner: vidafacil
2881--
2882
2883SELECT pg_catalog.setval('cartao_credito_audited_id_seq', 1, false);
2884
2885
2886--
2887-- Data for Name: cidade_audited; Type: TABLE DATA; Schema: auditing; Owner: vidafacil
2888--
2889
2890COPY cidade_audited (id, revision, revision_type, nome, estado_id) FROM stdin;
2891\.
2892
2893
2894--
2895-- Name: cidade_audited_id_seq; Type: SEQUENCE SET; Schema: auditing; Owner: vidafacil
2896--
2897
2898SELECT pg_catalog.setval('cidade_audited_id_seq', 1, false);
2899
2900
2901--
2902-- Data for Name: cliente_audited; Type: TABLE DATA; Schema: auditing; Owner: vidafacil
2903--
2904
2905COPY cliente_audited (id, revision, revision_type, estado_civil, sexo, tipo_documento, versao_anterior, conjuge_id, endereco_id, profissao_id, user_id, celular, data_nascimento, documento, especificacao_profissao_outro, telefone_residencial, whatsapp, telefone_trabalho, endereco_trabalho_id) FROM stdin;
29061	18	0	0	0	0	\N	\N	1000	1	2	45991919191	2018-03-29 15:14:36.104139	123456789	\N	2222222	12321231213	12312213132	1000
2907\.
2908
2909
2910--
2911-- Name: cliente_audited_id_seq; Type: SEQUENCE SET; Schema: auditing; Owner: vidafacil
2912--
2913
2914SELECT pg_catalog.setval('cliente_audited_id_seq', 1, false);
2915
2916
2917--
2918-- Data for Name: cobertura_plano_seguro_audited; Type: TABLE DATA; Schema: auditing; Owner: vidafacil
2919--
2920
2921COPY cobertura_plano_seguro_audited (id, revision, revision_type, cobertura_relevante, descricao, ordem_relevancia, valor, plano_seguro_id) FROM stdin;
2922\.
2923
2924
2925--
2926-- Name: cobertura_plano_seguro_audited_id_seq; Type: SEQUENCE SET; Schema: auditing; Owner: vidafacil
2927--
2928
2929SELECT pg_catalog.setval('cobertura_plano_seguro_audited_id_seq', 1, false);
2930
2931
2932--
2933-- Data for Name: configuracao_perfil_usuario_plano_seguro_audited; Type: TABLE DATA; Schema: auditing; Owner: vidafacil
2934--
2935
2936COPY configuracao_perfil_usuario_plano_seguro_audited (id, revision, revision_type, perfil_usuario_plano_seguro, plano_seguro_id) FROM stdin;
2937\.
2938
2939
2940--
2941-- Name: configuracao_perfil_usuario_plano_seguro_audited_id_seq; Type: SEQUENCE SET; Schema: auditing; Owner: vidafacil
2942--
2943
2944SELECT pg_catalog.setval('configuracao_perfil_usuario_plano_seguro_audited_id_seq', 1, false);
2945
2946
2947--
2948-- Data for Name: configuracao_plataforma_audited; Type: TABLE DATA; Schema: auditing; Owner: vidafacil
2949--
2950
2951COPY configuracao_plataforma_audited (id, revision, revision_type, limite_reenvio_email_rejeicao_cotacao, tempo_reenvio_email_rejeicao_cotacao) FROM stdin;
2952\.
2953
2954
2955--
2956-- Name: configuracao_plataforma_audited_id_seq; Type: SEQUENCE SET; Schema: auditing; Owner: vidafacil
2957--
2958
2959SELECT pg_catalog.setval('configuracao_plataforma_audited_id_seq', 1, false);
2960
2961
2962--
2963-- Data for Name: conjuge_audited; Type: TABLE DATA; Schema: auditing; Owner: vidafacil
2964--
2965
2966COPY conjuge_audited (id, revision, revision_type, data_nascimento, documento, nome_completo, tipo_documento, especificacao_profissao_outro_conjuge, profissao_id) FROM stdin;
2967\.
2968
2969
2970--
2971-- Name: conjuge_audited_id_seq; Type: SEQUENCE SET; Schema: auditing; Owner: vidafacil
2972--
2973
2974SELECT pg_catalog.setval('conjuge_audited_id_seq', 1, false);
2975
2976
2977--
2978-- Data for Name: endereco_audited; Type: TABLE DATA; Schema: auditing; Owner: vidafacil
2979--
2980
2981COPY endereco_audited (id, revision, revision_type, bairro, codigo_postal, complemento, logradouro, numero, cidade_id) FROM stdin;
29829	24	0	\N	\N	\N	Rua Edmundo de Barros	1849	4
298310	24	0	\N	\N	\N	Rua Edmundo de Barros	1849	4
298411	49	0	\N	\N	\N	Rua Teste	\N	3
298512	49	0	\N	\N	\N	Rua Teste	\N	3
298617	55	0	\N	\N	\N	Rua Teste	\N	4
298718	55	0	\N	\N	\N	Rua Teste	\N	4
298819	57	0	\N	\N	\N	Rua Teste	\N	5
298920	57	0	\N	\N	\N	Rua Teste	\N	5
2990\.
2991
2992
2993--
2994-- Name: endereco_audited_id_seq; Type: SEQUENCE SET; Schema: auditing; Owner: vidafacil
2995--
2996
2997SELECT pg_catalog.setval('endereco_audited_id_seq', 1, false);
2998
2999
3000--
3001-- Data for Name: estado_audited; Type: TABLE DATA; Schema: auditing; Owner: vidafacil
3002--
3003
3004COPY estado_audited (id, revision, revision_type, nome, pais_id) FROM stdin;
3005\.
3006
3007
3008--
3009-- Name: estado_audited_id_seq; Type: SEQUENCE SET; Schema: auditing; Owner: vidafacil
3010--
3011
3012SELECT pg_catalog.setval('estado_audited_id_seq', 1, false);
3013
3014
3015--
3016-- Data for Name: executivo_audited; Type: TABLE DATA; Schema: auditing; Owner: vidafacil
3017--
3018
3019COPY executivo_audited (id, revision, revision_type, agente_id, user_id) FROM stdin;
3020\.
3021
3022
3023--
3024-- Name: executivo_audited_id_seq; Type: SEQUENCE SET; Schema: auditing; Owner: vidafacil
3025--
3026
3027SELECT pg_catalog.setval('executivo_audited_id_seq', 1, false);
3028
3029
3030--
3031-- Data for Name: formulario_perfil_usuario_cotacao_seguro_audited; Type: TABLE DATA; Schema: auditing; Owner: vidafacil
3032--
3033
3034COPY formulario_perfil_usuario_cotacao_seguro_audited (id, revision, revision_type, formulario_cotacao_plano_seguro, configuracao_perfil_usuario_plano_seguro_id) FROM stdin;
3035\.
3036
3037
3038--
3039-- Name: formulario_perfil_usuario_cotacao_seguro_audited_id_seq; Type: SEQUENCE SET; Schema: auditing; Owner: vidafacil
3040--
3041
3042SELECT pg_catalog.setval('formulario_perfil_usuario_cotacao_seguro_audited_id_seq', 1, false);
3043
3044
3045--
3046-- Data for Name: grupo_empresa_audited; Type: TABLE DATA; Schema: auditing; Owner: vidafacil
3047--
3048
3049COPY grupo_empresa_audited (id, revision, revision_type, nome_fantasia, responsavel_rh_id, pagamento_comum) FROM stdin;
3050\.
3051
3052
3053--
3054-- Name: grupo_empresa_audited_id_seq; Type: SEQUENCE SET; Schema: auditing; Owner: vidafacil
3055--
3056
3057SELECT pg_catalog.setval('grupo_empresa_audited_id_seq', 1, false);
3058
3059
3060--
3061-- Data for Name: historico_apolice_seguro_audited; Type: TABLE DATA; Schema: auditing; Owner: vidafacil
3062--
3063
3064COPY historico_apolice_seguro_audited (id, revision, revision_type, data_operacao, operacao_troca_status_apolice_seguro, apolice_seguro_id, user_id, observacao) FROM stdin;
30651	12	0	2018-03-29 18:08:19.095	0	1001	\N	Teste
30662	18	0	2018-03-29 19:03:18.033	1	1	\N	\N
3067\.
3068
3069
3070--
3071-- Name: historico_apolice_seguro_audited_id_seq; Type: SEQUENCE SET; Schema: auditing; Owner: vidafacil
3072--
3073
3074SELECT pg_catalog.setval('historico_apolice_seguro_audited_id_seq', 1, false);
3075
3076
3077--
3078-- Data for Name: historico_solicitacao_cotacao_seguro_audited; Type: TABLE DATA; Schema: auditing; Owner: vidafacil
3079--
3080
3081COPY historico_solicitacao_cotacao_seguro_audited (id, revision, revision_type, data_operacao, operacao_troca_status_solicitacao_seguro, solicitacao_cotacao_seguro_id, observacao, user_id) FROM stdin;
30826	15	0	2018-03-29 18:48:56.867	2	1004	Teste	\N
30837	16	0	2018-03-29 18:50:24.27	2	1002	Teste	\N
30848	18	0	2018-03-29 19:03:17.999	6	1001	\N	\N
30859	20	0	2018-03-29 23:08:02.705	0	1	\N	\N
308614	23	0	2018-04-02 10:45:37.617	0	3	\N	\N
308715	24	0	2018-04-02 10:47:20.21	4	3	\N	\N
308814	24	2	\N	\N	\N	\N	\N
308916	48	0	2018-04-02 15:45:11.224	0	4	\N	\N
309017	49	0	2018-04-02 15:47:15.414	4	4	\N	\N
309116	49	2	\N	\N	\N	\N	\N
309220	53	0	2018-04-02 15:56:33.105	0	5	\N	\N
309321	55	0	2018-04-02 15:59:47.192	4	5	\N	\N
309420	55	2	\N	\N	\N	\N	\N
309522	56	0	2018-04-02 16:04:55.468	0	6	\N	\N
309623	57	0	2018-04-02 16:05:57.784	4	6	\N	\N
309724	59	0	2018-04-02 16:09:51.158	0	7	\N	\N
309825	60	0	2018-04-02 16:11:47.922	0	8	\N	\N
3099\.
3100
3101
3102--
3103-- Name: historico_solicitacao_cotacao_seguro_audited_id_seq; Type: SEQUENCE SET; Schema: auditing; Owner: vidafacil
3104--
3105
3106SELECT pg_catalog.setval('historico_solicitacao_cotacao_seguro_audited_id_seq', 1, false);
3107
3108
3109--
3110-- Data for Name: pais_audited; Type: TABLE DATA; Schema: auditing; Owner: vidafacil
3111--
3112
3113COPY pais_audited (id, revision, revision_type, nome) FROM stdin;
3114\.
3115
3116
3117--
3118-- Name: pais_audited_id_seq; Type: SEQUENCE SET; Schema: auditing; Owner: vidafacil
3119--
3120
3121SELECT pg_catalog.setval('pais_audited_id_seq', 1, false);
3122
3123
3124--
3125-- Data for Name: perfil_acesso_audited; Type: TABLE DATA; Schema: auditing; Owner: vidafacil
3126--
3127
3128COPY perfil_acesso_audited (id, revision, revision_type, descricao, editavel, nome, removivel) FROM stdin;
3129\.
3130
3131
3132--
3133-- Name: perfil_acesso_audited_id_seq; Type: SEQUENCE SET; Schema: auditing; Owner: vidafacil
3134--
3135
3136SELECT pg_catalog.setval('perfil_acesso_audited_id_seq', 1, false);
3137
3138
3139--
3140-- Data for Name: perfil_acesso_permissao_audited; Type: TABLE DATA; Schema: auditing; Owner: vidafacil
3141--
3142
3143COPY perfil_acesso_permissao_audited (id, revision, revision_type, permissao_identificador, perfil_acesso_id) FROM stdin;
3144\.
3145
3146
3147--
3148-- Name: perfil_acesso_permissao_audited_id_seq; Type: SEQUENCE SET; Schema: auditing; Owner: vidafacil
3149--
3150
3151SELECT pg_catalog.setval('perfil_acesso_permissao_audited_id_seq', 1, false);
3152
3153
3154--
3155-- Data for Name: plano_seguro_audited; Type: TABLE DATA; Schema: auditing; Owner: vidafacil
3156--
3157
3158COPY plano_seguro_audited (id, revision, revision_type, descricao, nome, ordem_relevancia, permite_incluir_conjuge, valor, produto_seguro_id) FROM stdin;
3159\.
3160
3161
3162--
3163-- Name: plano_seguro_audited_id_seq; Type: SEQUENCE SET; Schema: auditing; Owner: vidafacil
3164--
3165
3166SELECT pg_catalog.setval('plano_seguro_audited_id_seq', 1, false);
3167
3168
3169--
3170-- Data for Name: produto_seguro_audited; Type: TABLE DATA; Schema: auditing; Owner: vidafacil
3171--
3172
3173COPY produto_seguro_audited (id, revision, revision_type, nome, ordem_relevancia) FROM stdin;
3174\.
3175
3176
3177--
3178-- Name: produto_seguro_audited_id_seq; Type: SEQUENCE SET; Schema: auditing; Owner: vidafacil
3179--
3180
3181SELECT pg_catalog.setval('produto_seguro_audited_id_seq', 1, false);
3182
3183
3184--
3185-- Data for Name: profissao_audited; Type: TABLE DATA; Schema: auditing; Owner: vidafacil
3186--
3187
3188COPY profissao_audited (id, revision, revision_type, descricao) FROM stdin;
3189\.
3190
3191
3192--
3193-- Name: profissao_audited_id_seq; Type: SEQUENCE SET; Schema: auditing; Owner: vidafacil
3194--
3195
3196SELECT pg_catalog.setval('profissao_audited_id_seq', 1, false);
3197
3198
3199--
3200-- Data for Name: profissao_restricao_plano_seguro_audited; Type: TABLE DATA; Schema: auditing; Owner: vidafacil
3201--
3202
3203COPY profissao_restricao_plano_seguro_audited (id, revision, revision_type, plano_seguro_id, profissao_id) FROM stdin;
3204\.
3205
3206
3207--
3208-- Name: profissao_restricao_plano_seguro_audited_id_seq; Type: SEQUENCE SET; Schema: auditing; Owner: vidafacil
3209--
3210
3211SELECT pg_catalog.setval('profissao_restricao_plano_seguro_audited_id_seq', 1, false);
3212
3213
3214--
3215-- Data for Name: revision; Type: TABLE DATA; Schema: auditing; Owner: vidafacil
3216--
3217
3218COPY revision (id, "timestamp", user_id) FROM stdin;
32191	1522347019801	1
32202	1522347307467	1
32213	1522347977478	1
32224	1522348842735	1
32235	1522352091422	1
32246	1522352833298	1
32257	1522353143970	1
32268	1522353393100	1
32279	1522354046740	1
322810	1522356909006	1
322911	1522357104687	1
323012	1522357699277	1
323113	1522359709127	1
323214	1522360120099	1
323315	1522360136880	1
323416	1522360224275	1
323517	1522360935351	1
323618	1522360998049	1
323719	1522374916260	1
323820	1522375682717	1
323921	1522670916409	1
324022	1522675876579	1
324123	1522676737632	1
324224	1522676840464	1
324325	1522678050530	1
324426	1522678367384	1
324527	1522679080895	1
324628	1522679108889	1
324729	1522679138633	1
324830	1522679194599	1
324931	1522679287431	1
325032	1522679420741	1
325133	1522679553031	1
325234	1522680028282	1
325335	1522680135738	1
325436	1522680236834	1
325537	1522680351446	1
325638	1522680526643	1
325739	1522680590339	1
325840	1522680849112	1
325941	1522681237100	1
326042	1522681849230	1
326143	1522682801453	1
326244	1522682935498	1
326345	1522690524683	1
326446	1522690624889	1
326547	1522691411622	1
326648	1522694711236	1
326749	1522694835664	1
326852	1522695235406	1
326953	1522695393117	1
327054	1522695415721	1
327155	1522695587414	1
327256	1522695895485	\N
327357	1522695958052	\N
327458	1522695975127	1
327559	1522696191175	\N
327660	1522696307938	\N
327761	1522696891743	1
327862	1522697228654	1
3279\.
3280
3281
3282--
3283-- Name: revision_id_seq; Type: SEQUENCE SET; Schema: auditing; Owner: vidafacil
3284--
3285
3286SELECT pg_catalog.setval('revision_id_seq', 62, true);
3287
3288
3289--
3290-- Data for Name: solicitacao_cotacao_seguro_audited; Type: TABLE DATA; Schema: auditing; Owner: vidafacil
3291--
3292
3293COPY solicitacao_cotacao_seguro_audited (id, revision, revision_type, celular, data_nascimento, documento, email, estado_civil, forma_pagamento, incluir_conjuge_cobertura, nome, numero_solicitacao, sexo, situacao_solicitacao_cotacao_seguro, sobrenome, telefone_residencial, telefone_trabalho, tipo_documento, uso_de_motocicleta, valor_mensal, whatsapp, agente_autorizado_id, apolice_seguro_id, cartao_credito_id, conjuge_id, endereco_residencial_id, endereco_trabalho_id, executivo_id, grupo_empresa_id, plano_seguro_id, profissao_id, edit_token, especificacao_profissao_outro) FROM stdin;
32941004	15	1	10000000	2018-03-29 15:14:36.104139	123456789	teste@mailinator.com	0	1	f	Fulano	1111111	0	3	Da Silva	4530303030	4530303535	0	f	350.00	22222222	1000	\N	\N	\N	1000	1000	1001	\N	1007	25	\N	\N
32951002	16	1	45991919191	2018-03-29 15:14:36.104139	123456789	teste6@mailinator.com	0	1	f	Fulana	22000000	0	3	Da Silva	4530303030	4530303535	0	f	350.00	4589878977	1000	\N	\N	\N	1000	1000	1001	\N	1006	25	\N	\N
32961001	18	1	45991919191	2018-03-29 15:14:36.104139	123456789	testando@mailinator.com	0	1	f	Teste	22211111	0	2	Testando	2222222	12312213132	0	f	30.00	12321231213	\N	\N	\N	\N	1000	1000	1002	\N	1007	1	\N	\N
32971	20	0	45999932329	1992-11-19 21:00:00	94023920	digossmi@gmail.com	0	\N	\N	Rodrigo Luis	\N	0	1	Fracaroli	\N	\N	0	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	1000	43	\N	\N
32983	23	0	4599932329	1992-11-19 19:00:00	94023920	digossmi@gmail.com	0	\N	\N	Rodrigo Luis	\N	0	1	Fracaroli	\N	\N	0	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	1001	43	\N	\N
32993	24	1	4599932329	1992-11-17 21:00:00	94023920	digossmi@gmail.com	0	2	f	Rodrigo Luis	3	0	0	Fracaroli	\N	\N	0	f	10.00	\N	\N	\N	\N	\N	9	10	\N	\N	1001	43	\N	\N
33004	48	0	456456456456	1995-02-05 15:00:00	456564564	wolleson.kelm@eits.com.br	0	\N	\N	Wolleson	\N	0	1	Kelm	\N	\N	0	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	1000	43	\N	\N
33014	49	1	456456456456	1995-02-03 15:00:00	456564564	wolleson.kelm@eits.com.br	0	2	f	Wolleson	4	0	0	Kelm	\N	\N	0	f	10.00	\N	\N	\N	\N	\N	11	12	\N	\N	1000	43	\N	\N
33025	53	0	123123132	1992-01-05 03:00:00	123123123	digossmi@gmail.com	0	\N	\N	Rodrigo Luis	\N	0	1	Fracaroli	\N	\N	0	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	1000	43	\N	\N
33035	55	1	123123132	1992-01-03 15:00:00	123123123	digossmi@gmail.com	0	1	f	Rodrigo Luis	5	0	0	Fracaroli	\N	\N	0	f	10.00	\N	\N	\N	\N	\N	17	18	\N	\N	1000	43	\N	\N
33046	56	0	123213123213	1992-11-19 23:00:00	123123123213	digossmi@gmail.com	0	\N	\N	Rodrigo Luis	\N	0	1	Fracaroli	\N	\N	0	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	1001	43	\N	\N
33056	57	1	123213123213	1992-11-18 07:00:00	123123123213	digossmi@gmail.com	0	2	f	Rodrigo Luis	6	0	0	Fracaroli	\N	\N	0	f	10.00	\N	\N	\N	\N	\N	19	20	\N	\N	1001	43	\N	\N
33067	59	0	231231213213	2000-02-29 12:00:00	123231123	alou@alou.com.br	0	\N	\N	Teste testando	\N	0	1	Teste		\N	0	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	1007	2	\N	\N
33078	60	0	123213231213	2000-03-31 12:00:00	123123	aloprasd@aloprasd.com.br	0	\N	\N	Alopr Asd	\N	0	1	Adv	\N	\N	0	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	1003	12	\N	\N
3308\.
3309
3310
3311--
3312-- Name: solicitacao_cotacao_seguro_audited_id_seq; Type: SEQUENCE SET; Schema: auditing; Owner: vidafacil
3313--
3314
3315SELECT pg_catalog.setval('solicitacao_cotacao_seguro_audited_id_seq', 1, false);
3316
3317
3318--
3319-- Data for Name: tutor_audited; Type: TABLE DATA; Schema: auditing; Owner: vidafacil
3320--
3321
3322COPY tutor_audited (id, revision, revision_type, documento, grau_parentesco, nome_completo, tipo_documento, data_nascimento) FROM stdin;
3323\.
3324
3325
3326--
3327-- Name: tutor_audited_id_seq; Type: SEQUENCE SET; Schema: auditing; Owner: vidafacil
3328--
3329
3330SELECT pg_catalog.setval('tutor_audited_id_seq', 1, false);
3331
3332
3333--
3334-- Data for Name: user_audited; Type: TABLE DATA; Schema: auditing; Owner: vidafacil
3335--
3336
3337COPY user_audited (id, revision, revision_type, disabled, email, last_login, name, password, sobrenome, role, password_reset_token, password_reset_token_expiration) FROM stdin;
33381	1	1	f	admin@admin.com	2018-03-29 15:10:19.761-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33391	2	1	f	admin@admin.com	2018-03-29 15:15:07.462-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33401	3	1	f	admin@admin.com	2018-03-29 15:26:17.431-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33411	4	1	f	admin@admin.com	2018-03-29 15:40:42.69-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33421	5	1	f	admin@admin.com	2018-03-29 16:34:51.378-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33431	6	1	f	admin@admin.com	2018-03-29 16:47:13.245-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33441	7	1	f	admin@admin.com	2018-03-29 16:52:23.927-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33451	8	1	f	admin@admin.com	2018-03-29 16:56:33.056-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33461	9	1	f	admin@admin.com	2018-03-29 17:07:26.696-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33471	10	1	f	admin@admin.com	2018-03-29 17:55:08.949-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33481	11	1	f	admin@admin.com	2018-03-29 17:58:24.64-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33491	13	1	f	admin@admin.com	2018-03-29 18:41:49.079-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33501	14	1	f	admin@admin.com	2018-03-29 18:48:40.052-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33511	17	1	f	admin@admin.com	2018-03-29 19:02:15.307-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33522	18	0	t	testando@mailinator.com	\N	Teste	123	Testando	2	\N	\N
33531	19	1	f	admin@admin.com	2018-03-29 22:55:16.196-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33541	21	1	f	admin@admin.com	2018-04-02 09:08:36.249-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33551	22	1	f	admin@admin.com	2018-04-02 10:31:16.579-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33561	25	1	f	admin@admin.com	2018-04-02 11:07:30.483-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33571	26	1	f	admin@admin.com	2018-04-02 11:12:47.344-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33581	27	1	f	admin@admin.com	2018-04-02 11:24:40.848-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33591	28	1	f	admin@admin.com	2018-04-02 11:25:08.873-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33601	29	1	f	admin@admin.com	2018-04-02 11:25:38.629-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33611	30	1	f	admin@admin.com	2018-04-02 11:26:34.599-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33621	31	1	f	admin@admin.com	2018-04-02 11:28:07.4-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33631	32	1	f	admin@admin.com	2018-04-02 11:30:20.694-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33641	33	1	f	admin@admin.com	2018-04-02 11:32:32.984-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33651	34	1	f	admin@admin.com	2018-04-02 11:40:28.235-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33661	35	1	f	admin@admin.com	2018-04-02 11:42:15.691-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33671	36	1	f	admin@admin.com	2018-04-02 11:43:56.787-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33681	37	1	f	admin@admin.com	2018-04-02 11:45:51.399-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33691	38	1	f	admin@admin.com	2018-04-02 11:48:46.586-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33701	39	1	f	admin@admin.com	2018-04-02 11:49:50.294-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33711	40	1	f	admin@admin.com	2018-04-02 11:54:09.066-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33721	41	1	f	admin@admin.com	2018-04-02 12:00:37.053-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33731	42	1	f	admin@admin.com	2018-04-02 12:10:49.184-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33741	43	1	f	admin@admin.com	2018-04-02 12:26:41.407-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33751	44	1	f	admin@admin.com	2018-04-02 12:28:55.446-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33761	45	1	f	admin@admin.com	2018-04-02 14:35:24.671-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33771	46	1	f	admin@admin.com	2018-04-02 14:37:04.845-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33781	47	1	f	admin@admin.com	2018-04-02 14:50:11.563-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33791	52	1	f	admin@admin.com	2018-04-02 15:53:55.359-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33801	54	1	f	admin@admin.com	2018-04-02 15:56:55.721-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33811	58	1	f	admin@admin.com	2018-04-02 16:06:15.112-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33821	61	1	f	admin@admin.com	2018-04-02 16:21:31.699-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
33831	62	1	f	admin@admin.com	2018-04-02 16:27:08.611-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
3384\.
3385
3386
3387--
3388-- Data for Name: usuario_perfil_acesso_audited; Type: TABLE DATA; Schema: auditing; Owner: vidafacil
3389--
3390
3391COPY usuario_perfil_acesso_audited (id, revision, revision_type, perfil_acesso_id, user_id) FROM stdin;
3392\.
3393
3394
3395--
3396-- Name: usuario_perfil_acesso_audited_id_seq; Type: SEQUENCE SET; Schema: auditing; Owner: vidafacil
3397--
3398
3399SELECT pg_catalog.setval('usuario_perfil_acesso_audited_id_seq', 1, false);
3400
3401
3402SET search_path = public, pg_catalog;
3403
3404--
3405-- Data for Name: agente; Type: TABLE DATA; Schema: public; Owner: vidafacil
3406--
3407
3408COPY agente (id, created, updated, user_id) FROM stdin;
34099999	2018-03-29 15:13:01.44651	\N	9999
34101000	2018-03-29 15:13:01.44651	\N	1000
3411\.
3412
3413
3414--
3415-- Name: agente_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vidafacil
3416--
3417
3418SELECT pg_catalog.setval('agente_id_seq', 1, false);
3419
3420
3421--
3422-- Data for Name: apolice_seguro; Type: TABLE DATA; Schema: public; Owner: vidafacil
3423--
3424
3425COPY apolice_seguro (id, created, updated, forma_pagamento, incluir_conjuge_na_cobertura, numero_apolice, valor_mensal, agente_id, cartao_credito_id, cliente_id, executivo_id, grupo_empresa_id, plano_seguro_id, uso_de_motocicleta, status_apolice_seguro, solicitacao_cotacao_seguro_id) FROM stdin;
34261000	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	1	f	1010	8989.00	1000	\N	1000	1001	1000	1000	f	0	1000
34271002	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	1	f	3333	8989.00	9999	\N	1001	1002	1001	1000	f	0	1000
34281003	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	1	f	4433	8989.00	1000	\N	1001	1001	1001	1000	f	0	1000
34291004	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	1	f	4444	8989.00	9999	\N	1000	1001	1001	1000	f	0	1000
34301001	2018-03-29 15:13:01.44651	2018-03-29 18:08:19.118	1	f	1011	8989.00	9999	\N	1000	1001	1000	1000	f	1	1000
34311	2018-03-29 19:03:18.04	\N	1	f	15654	30.00	\N	\N	1	1002	\N	1007	f	0	1001
3432\.
3433
3434
3435--
3436-- Name: apolice_seguro_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vidafacil
3437--
3438
3439SELECT pg_catalog.setval('apolice_seguro_id_seq', 1, true);
3440
3441
3442--
3443-- Data for Name: beneficiario; Type: TABLE DATA; Schema: public; Owner: vidafacil
3444--
3445
3446COPY beneficiario (id, created, updated, data_nascimento, documento, grau_parentesco, nome_completo, numero, percentual_participacao, tipo_documento, solicitacao_cotacao_seguro_id, tutor_id, apolice_seguro_id) FROM stdin;
344710	2018-04-02 15:59:47.184	\N	1962-04-01 18:00:00	12321231123123	1	Gilberto Alouwc	9	100	0	4	\N	\N
344811	2018-04-02 16:05:57.777	\N	1992-11-19 07:00:00	2312312312312	0	Smiles Sil	10	100	1	6	\N	\N
34496	2018-03-29 15:14:36.104139	2018-03-29 15:14:36.104139	2018-03-29 15:14:36.104139	123456789	0	Noe Arca	1	100	1	1003	1002	\N
34501000	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	123456789	0	Pedro Souza	6	50	1	1000	1	1000
34511001	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	123456789	0	Bruna Pirli	7	50	1	1000	2	1001
34521003	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	123456789	0	Carlos Aloha	8	25	1	1001	3	1002
34531004	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	123456789	0	Vava de Belém	9	25	1	1001	4	1003
34541005	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	123456789	0	Bya Bye	10	25	1	1001	5	1004
34551006	2018-03-29 15:14:36.104139	2018-03-29 19:03:18.045	2018-03-29 15:14:36.104139	123456789	0	Bela Fera	11	25	1	1001	6	1
34561007	2018-03-29 15:14:36.104139	2018-03-29 15:14:36.104139	2018-03-29 15:14:36.104139	123456789	0	Debi Ajo	12	100	1	1004	1001	\N
34571008	2018-03-29 15:14:36.104139	2018-03-29 15:14:36.104139	2018-03-29 15:14:36.104139	123456789	0	Beatriz Hows	13	100	1	1002	1002	\N
3458\.
3459
3460
3461--
3462-- Name: beneficiario_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vidafacil
3463--
3464
3465SELECT pg_catalog.setval('beneficiario_id_seq', 11, true);
3466
3467
3468--
3469-- Name: beneficiario_numero_seq; Type: SEQUENCE SET; Schema: public; Owner: vidafacil
3470--
3471
3472SELECT pg_catalog.setval('beneficiario_numero_seq', 10, true);
3473
3474
3475--
3476-- Data for Name: cartao_credito; Type: TABLE DATA; Schema: public; Owner: vidafacil
3477--
3478
3479COPY cartao_credito (id, created, updated, bandeira_cartao, codigo_seguranca, documento_titular, nome_titular, numero, processadora_cartao, mes, ano) FROM stdin;
34801000	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	1	999	10000	joão 	13213123	1	02	90
3481\.
3482
3483
3484--
3485-- Name: cartao_credito_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vidafacil
3486--
3487
3488SELECT pg_catalog.setval('cartao_credito_id_seq', 1, false);
3489
3490
3491--
3492-- Data for Name: cidade; Type: TABLE DATA; Schema: public; Owner: vidafacil
3493--
3494
3495COPY cidade (id, created, updated, nome, estado_id) FROM stdin;
34961	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Bahía Negra", "PORTUGUESE"=>"Bahía Negra"	1
34972	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Fuerte Olimpo", "PORTUGUESE"=>"Fuerte Olimpo"	1
34983	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Isla Margarita", "PORTUGUESE"=>"Isla Margarita"	1
34994	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"La Victoria", "PORTUGUESE"=>"La Victoria"	1
35005	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Lagerenza", "PORTUGUESE"=>"Lagerenza"	1
35016	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Puerto Guaraní", "PORTUGUESE"=>"Puerto Guaraní"	1
35027	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Puerto la Esperanza", "PORTUGUESE"=>"Puerto la Esperanza"	1
35038	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Ciudad del Este", "PORTUGUESE"=>"Ciudad del Este"	2
35049	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Domingo Martinez de Irala", "PORTUGUESE"=>"Domingo Martinez de Irala"	2
350510	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Dr. Juan Leon Mallorquin", "PORTUGUESE"=>"Dr. Juan Leon Mallorquin"	2
350611	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Hernandarias", "PORTUGUESE"=>"Hernandarias"	2
350712	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Itaquyry", "PORTUGUESE"=>"Itaquyry"	2
350813	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Juan E. Oleary", "PORTUGUESE"=>"Juan E. Oleary"	2
350914	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Los Cedrales", "PORTUGUESE"=>"Los Cedrales"	2
351015	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Mbaracayú", "PORTUGUESE"=>"Mbaracayú"	2
351116	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Minga Guazu", "PORTUGUESE"=>"Minga Guazu"	2
351217	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Minga Pora", "PORTUGUESE"=>"Minga Pora"	2
351318	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Ñacunday", "PORTUGUESE"=>"Ñacunday"	2
351419	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Naranjal", "PORTUGUESE"=>"Naranjal"	2
351520	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Presidente Franco", "PORTUGUESE"=>"Presidente Franco"	2
351621	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Puerto Bertoni", "PORTUGUESE"=>"Puerto Bertoni"	2
351722	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"San Alberto", "PORTUGUESE"=>"San Alberto"	2
351823	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"San Cristóbal", "PORTUGUESE"=>"San Cristóbal"	2
351924	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Santa Rita", "PORTUGUESE"=>"Santa Rita"	2
352025	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Santa Rosa del Monday", "PORTUGUESE"=>"Santa Rosa del Monday"	2
352126	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Yguazu", "PORTUGUESE"=>"Yguazu"	2
352227	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Bella Vista", "PORTUGUESE"=>"Bella Vista"	3
352328	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Capitán Bado", "PORTUGUESE"=>"Capitán Bado"	3
352429	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Pedro Juan Caballero", "PORTUGUESE"=>"Pedro Juan Caballero"	3
352530	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Capitán Joel Estigarribia", "PORTUGUESE"=>"Capitán Joel Estigarribia"	4
352631	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Colonia Neuland", "PORTUGUESE"=>"Colonia Neuland"	4
352732	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Dr. Pedro P. Peña", "PORTUGUESE"=>"Dr. Pedro P. Peña"	4
352833	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Filadelfia", "PORTUGUESE"=>"Filadelfia"	4
352934	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"General Eugenio A. Garay", "PORTUGUESE"=>"General Eugenio A. Garay"	4
353035	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Loma Plata", "PORTUGUESE"=>"Loma Plata"	4
353136	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Mariscal Estigarribia", "PORTUGUESE"=>"Mariscal Estigarribia"	4
353237	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Teniente Primero Irala Fernandez", "PORTUGUESE"=>"Teniente Primero Irala Fernandez"	4
353338	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Caaguazu", "PORTUGUESE"=>"Caaguazu"	5
353439	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Carayao", "PORTUGUESE"=>"Carayao"	5
353540	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Cecilio Báez", "PORTUGUESE"=>"Cecilio Báez"	5
353641	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Colonia Genaro Romero", "PORTUGUESE"=>"Colonia Genaro Romero"	5
353742	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Coronel Oviedo", "PORTUGUESE"=>"Coronel Oviedo"	5
353843	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Dr. José E. Estigarribia", "PORTUGUESE"=>"Dr. José E. Estigarribia"	5
353944	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Dr. Juan Manuel Frutos", "PORTUGUESE"=>"Dr. Juan Manuel Frutos"	5
354045	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"José Domingo Ocampos", "PORTUGUESE"=>"José Domingo Ocampos"	5
354146	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"La Pastora", "PORTUGUESE"=>"La Pastora"	5
354247	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Mariscal F. Solano Lopez", "PORTUGUESE"=>"Mariscal F. Solano Lopez"	5
354348	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Nueva Australia", "PORTUGUESE"=>"Nueva Australia"	5
354449	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Nueva Londres", "PORTUGUESE"=>"Nueva Londres"	5
354550	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"R.I. 3 Corrales", "PORTUGUESE"=>"R.I. 3 Corrales"	5
354651	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Raul A. Oviedo", "PORTUGUESE"=>"Raul A. Oviedo"	5
354752	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Repatriación", "PORTUGUESE"=>"Repatriación"	5
354853	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"San Antonio Cordillera", "PORTUGUESE"=>"San Antonio Cordillera"	5
354954	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"San Joaquin", "PORTUGUESE"=>"San Joaquin"	5
355055	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"San José de los Arroyos", "PORTUGUESE"=>"San José de los Arroyos"	5
355156	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Santa Rosa del Mbutu", "PORTUGUESE"=>"Santa Rosa del Mbutu"	5
355257	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Simon Bolivar", "PORTUGUESE"=>"Simon Bolivar"	5
355358	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Yhu", "PORTUGUESE"=>"Yhu"	5
355459	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Abaí", "PORTUGUESE"=>"Abaí"	6
355560	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Buena Vista", "PORTUGUESE"=>"Buena Vista"	6
355661	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Caazapá", "PORTUGUESE"=>"Caazapá"	6
355762	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Col. Mayor Nicolas Arguello", "PORTUGUESE"=>"Col. Mayor Nicolas Arguello"	6
355863	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Colonia San Cosme", "PORTUGUESE"=>"Colonia San Cosme"	6
355964	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Compañía San Francisco", "PORTUGUESE"=>"Compañía San Francisco"	6
356065	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Dr. Moises Bertoni", "PORTUGUESE"=>"Dr. Moises Bertoni"	6
356166	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Estacion Gral. Patricio Colman", "PORTUGUESE"=>"Estacion Gral. Patricio Colman"	6
356267	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Estación Yuty", "PORTUGUESE"=>"Estación Yuty"	6
356368	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"General Higinio Morínigo", "PORTUGUESE"=>"General Higinio Morínigo"	6
356469	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Isla Saca", "PORTUGUESE"=>"Isla Saca"	6
356570	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Maciel", "PORTUGUESE"=>"Maciel"	6
356671	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"San Juan Nepomuceno", "PORTUGUESE"=>"San Juan Nepomuceno"	6
356772	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Santa Barbara", "PORTUGUESE"=>"Santa Barbara"	6
356873	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Santa Luisa", "PORTUGUESE"=>"Santa Luisa"	6
356974	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Santa Rosa de Lima", "PORTUGUESE"=>"Santa Rosa de Lima"	6
357075	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Tabai", "PORTUGUESE"=>"Tabai"	6
357176	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Yacubo", "PORTUGUESE"=>"Yacubo"	6
357277	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Yegros", "PORTUGUESE"=>"Yegros"	6
357378	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Yuty", "PORTUGUESE"=>"Yuty"	6
357479	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Colonia Anahi", "PORTUGUESE"=>"Colonia Anahi"	7
357580	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Colonia Catuete", "PORTUGUESE"=>"Colonia Catuete"	7
357681	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Corpus Christi", "PORTUGUESE"=>"Corpus Christi"	7
357782	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Curuguaty", "PORTUGUESE"=>"Curuguaty"	7
357883	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"General Francisco Alvarez", "PORTUGUESE"=>"General Francisco Alvarez"	7
357984	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Itarara", "PORTUGUESE"=>"Itarara"	7
358085	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"La Paloma", "PORTUGUESE"=>"La Paloma"	7
358186	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Nueva Esperanza", "PORTUGUESE"=>"Nueva Esperanza"	7
358287	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Salto del Guairá", "PORTUGUESE"=>"Salto del Guairá"	7
358388	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Ygatimí", "PORTUGUESE"=>"Ygatimí"	7
358489	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Ypé Jhú", "PORTUGUESE"=>"Ypé Jhú"	7
358590	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Areguá", "PORTUGUESE"=>"Areguá"	8
358691	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Asunción", "PORTUGUESE"=>"Asunción"	8
358792	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Ñemby", "PORTUGUESE"=>"Ñemby"	8
358893	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Capiatá", "PORTUGUESE"=>"Capiatá"	8
358994	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Fernando de la Mora", "PORTUGUESE"=>"Fernando de la Mora"	8
359095	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Guarambaré", "PORTUGUESE"=>"Guarambaré"	8
359196	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Itá", "PORTUGUESE"=>"Itá"	8
359297	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Itagua", "PORTUGUESE"=>"Itagua"	8
359398	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"José Augusto Saldivar", "PORTUGUESE"=>"José Augusto Saldivar"	8
359499	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Lambaré", "PORTUGUESE"=>"Lambaré"	8
3595100	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Limpio", "PORTUGUESE"=>"Limpio"	8
3596101	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Loma Pyta", "PORTUGUESE"=>"Loma Pyta"	8
3597102	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Luque", "PORTUGUESE"=>"Luque"	8
3598103	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Mariano Roque Alonso", "PORTUGUESE"=>"Mariano Roque Alonso"	8
3599104	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Nueva Italia", "PORTUGUESE"=>"Nueva Italia"	8
3600105	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"San Antonio", "PORTUGUESE"=>"San Antonio"	8
3601106	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"San Lorenzo", "PORTUGUESE"=>"San Lorenzo"	8
3602107	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Villa Elisa", "PORTUGUESE"=>"Villa Elisa"	8
3603108	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Villeta", "PORTUGUESE"=>"Villeta"	8
3604109	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Ypacarai", "PORTUGUESE"=>"Ypacarai"	8
3605110	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Ypane", "PORTUGUESE"=>"Ypane"	8
3606111	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Zeballos Cue", "PORTUGUESE"=>"Zeballos Cue"	8
3607112	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Belén", "PORTUGUESE"=>"Belén"	9
3608113	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Concepción", "PORTUGUESE"=>"Concepción"	9
3609114	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Horqueta", "PORTUGUESE"=>"Horqueta"	9
3610115	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Loreto", "PORTUGUESE"=>"Loreto"	9
3611116	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Paso Barreto", "PORTUGUESE"=>"Paso Barreto"	9
3612117	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Paso Mbutú", "PORTUGUESE"=>"Paso Mbutú"	9
3613118	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Puerto Fonciere", "PORTUGUESE"=>"Puerto Fonciere"	9
3614119	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"San Carlos", "PORTUGUESE"=>"San Carlos"	9
3615120	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"San Lázaro", "PORTUGUESE"=>"San Lázaro"	9
3616121	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Valle-Mí", "PORTUGUESE"=>"Valle-Mí"	9
3617122	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Yby - Yau", "PORTUGUESE"=>"Yby - Yau"	9
3618123	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Alfonso Tranquera", "PORTUGUESE"=>"Alfonso Tranquera"	10
3619124	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Altos", "PORTUGUESE"=>"Altos"	10
3620125	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Arroyos y Esteros", "PORTUGUESE"=>"Arroyos y Esteros"	10
3621126	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Atyrá", "PORTUGUESE"=>"Atyrá"	10
3622127	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Caacupé", "PORTUGUESE"=>"Caacupé"	10
3623128	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Caraguatay", "PORTUGUESE"=>"Caraguatay"	10
3624129	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Col. G. Bernardino Caballero", "PORTUGUESE"=>"Col. G. Bernardino Caballero"	10
3625130	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Compañía San Antonio", "PORTUGUESE"=>"Compañía San Antonio"	10
3626131	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Emboscada", "PORTUGUESE"=>"Emboscada"	10
3627132	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Eusebio Ayala", "PORTUGUESE"=>"Eusebio Ayala"	10
3628133	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Isla Pucu", "PORTUGUESE"=>"Isla Pucu"	10
3629134	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Itacurubí de la Cordillera", "PORTUGUESE"=>"Itacurubí de la Cordillera"	10
3630135	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Itapirú", "PORTUGUESE"=>"Itapirú"	10
3631136	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Juan de Mena", "PORTUGUESE"=>"Juan de Mena"	10
3632137	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Loma Grande", "PORTUGUESE"=>"Loma Grande"	10
3633138	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Mbocayaty del Yhaguy", "PORTUGUESE"=>"Mbocayaty del Yhaguy"	10
3634139	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Nueva Colombia", "PORTUGUESE"=>"Nueva Colombia"	10
3635140	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Piribebuy", "PORTUGUESE"=>"Piribebuy"	10
3636141	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Primero de Marzo", "PORTUGUESE"=>"Primero de Marzo"	10
3637142	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"San Bernardino", "PORTUGUESE"=>"San Bernardino"	10
3638143	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"San José Obrero", "PORTUGUESE"=>"San José Obrero"	10
3639144	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Santa Elena", "PORTUGUESE"=>"Santa Elena"	10
3640145	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Tobatí", "PORTUGUESE"=>"Tobatí"	10
3641146	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Valenzuela", "PORTUGUESE"=>"Valenzuela"	10
3642147	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Yaguarete Cua", "PORTUGUESE"=>"Yaguarete Cua"	10
3643148	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Barrio Estacion", "PORTUGUESE"=>"Barrio Estacion"	11
3644149	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Borja", "PORTUGUESE"=>"Borja"	11
3645150	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Capitan Mauricio José Troche", "PORTUGUESE"=>"Capitan Mauricio José Troche"	11
3646151	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Colonia Carlos Pfannl", "PORTUGUESE"=>"Colonia Carlos Pfannl"	11
3647152	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Colonia San Roque González", "PORTUGUESE"=>"Colonia San Roque González"	11
3648153	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Coronel Martinez", "PORTUGUESE"=>"Coronel Martinez"	11
3649154	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Dr. Bottrell", "PORTUGUESE"=>"Dr. Bottrell"	11
3650155	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Félix Pérez Cardozo", "PORTUGUESE"=>"Félix Pérez Cardozo"	11
3651156	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"General Eugenio A. Garay", "PORTUGUESE"=>"General Eugenio A. Garay"	11
3652157	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Independencia", "PORTUGUESE"=>"Independencia"	11
3653158	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Itapé", "PORTUGUESE"=>"Itapé"	11
3654159	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Iturbe", "PORTUGUESE"=>"Iturbe"	11
3655160	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"José Fasardi", "PORTUGUESE"=>"José Fasardi"	11
3656161	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Mbocayaty", "PORTUGUESE"=>"Mbocayaty"	11
3657162	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Natalicio Talavera", "PORTUGUESE"=>"Natalicio Talavera"	11
3658163	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Ñumi", "PORTUGUESE"=>"Ñumi"	11
3659164	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Paso Yobay", "PORTUGUESE"=>"Paso Yobay"	11
3660165	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Pindoyu", "PORTUGUESE"=>"Pindoyu"	11
3661166	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"San Salvador", "PORTUGUESE"=>"San Salvador"	11
3662167	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Tebicuary", "PORTUGUESE"=>"Tebicuary"	11
3663168	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Villarrica", "PORTUGUESE"=>"Villarrica"	11
3664169	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Yataity", "PORTUGUESE"=>"Yataity"	11
3665170	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Alto Verá", "PORTUGUESE"=>"Alto Verá"	12
3666171	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Barrio San Roque", "PORTUGUESE"=>"Barrio San Roque"	12
3667172	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Bella Vista", "PORTUGUESE"=>"Bella Vista"	12
3668173	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Cambyretá", "PORTUGUESE"=>"Cambyretá"	12
3669174	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Capitán Meza", "PORTUGUESE"=>"Capitán Meza"	12
3670175	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Capitán Miranda", "PORTUGUESE"=>"Capitán Miranda"	12
3671176	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Carlos Antonio Lopez", "PORTUGUESE"=>"Carlos Antonio Lopez"	12
3672177	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Carmen del Parana", "PORTUGUESE"=>"Carmen del Parana"	12
3673178	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Centro de Fronteras", "PORTUGUESE"=>"Centro de Fronteras"	12
3674179	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Colonia Federico Chavez", "PORTUGUESE"=>"Colonia Federico Chavez"	12
3675180	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Colonia Samu-u", "PORTUGUESE"=>"Colonia Samu-u"	12
3676181	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Colonia Triunfo", "PORTUGUESE"=>"Colonia Triunfo"	12
3677182	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Coronel Bogado", "PORTUGUESE"=>"Coronel Bogado"	12
3678183	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Curuñai", "PORTUGUESE"=>"Curuñai"	12
3679184	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Edelira", "PORTUGUESE"=>"Edelira"	12
3680185	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Encarnación", "PORTUGUESE"=>"Encarnación"	12
3681186	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Fram", "PORTUGUESE"=>"Fram"	12
3682187	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"General Artigas", "PORTUGUESE"=>"General Artigas"	12
3683188	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"General Delgado", "PORTUGUESE"=>"General Delgado"	12
3684189	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Hohenau", "PORTUGUESE"=>"Hohenau"	12
3685190	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Isla Alta", "PORTUGUESE"=>"Isla Alta"	12
3686191	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Jesus", "PORTUGUESE"=>"Jesus"	12
3687192	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"José L. Oviedo", "PORTUGUESE"=>"José L. Oviedo"	12
3688193	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"La Paz", "PORTUGUESE"=>"La Paz"	12
3689194	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Mayor Julio Otaño", "PORTUGUESE"=>"Mayor Julio Otaño"	12
3690195	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Natalio", "PORTUGUESE"=>"Natalio"	12
3691196	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Nueva Alborada", "PORTUGUESE"=>"Nueva Alborada"	12
3692197	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Obligado", "PORTUGUESE"=>"Obligado"	12
3693198	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Pirapo", "PORTUGUESE"=>"Pirapo"	12
3694199	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"San Cosme y Damián", "PORTUGUESE"=>"San Cosme y Damián"	12
3695200	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"San Dionisio", "PORTUGUESE"=>"San Dionisio"	12
3696201	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"San Juan del Paraná", "PORTUGUESE"=>"San Juan del Paraná"	12
3697202	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"San Pedro del Parana", "PORTUGUESE"=>"San Pedro del Parana"	12
3698203	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"San Rafael del Parana", "PORTUGUESE"=>"San Rafael del Parana"	12
3699204	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Tomas Romero Pereira", "PORTUGUESE"=>"Tomas Romero Pereira"	12
3700205	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Trinidad", "PORTUGUESE"=>"Trinidad"	12
3701206	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Yatytay", "PORTUGUESE"=>"Yatytay"	12
3702207	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Ayolas", "PORTUGUESE"=>"Ayolas"	13
3703208	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Colonia Alejo García", "PORTUGUESE"=>"Colonia Alejo García"	13
3704209	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Itayurú", "PORTUGUESE"=>"Itayurú"	13
3705210	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"San Ignacio", "PORTUGUESE"=>"San Ignacio"	13
3706211	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"San Juan Bautista", "PORTUGUESE"=>"San Juan Bautista"	13
3707212	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"San Miguel", "PORTUGUESE"=>"San Miguel"	13
3708213	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"San Patricio", "PORTUGUESE"=>"San Patricio"	13
3709214	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"San Ramón", "PORTUGUESE"=>"San Ramón"	13
3710215	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Santa Maria", "PORTUGUESE"=>"Santa Maria"	13
3711216	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Santa Rosa", "PORTUGUESE"=>"Santa Rosa"	13
3712217	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Santiago", "PORTUGUESE"=>"Santiago"	13
3713218	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Villa Florida", "PORTUGUESE"=>"Villa Florida"	13
3714219	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Yabebyry", "PORTUGUESE"=>"Yabebyry"	13
3715220	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Yacuti", "PORTUGUESE"=>"Yacuti"	13
3716221	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Alberdi", "PORTUGUESE"=>"Alberdi"	14
3717222	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Barrio Burrerita", "PORTUGUESE"=>"Barrio Burrerita"	14
3718223	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Barrio Obrero", "PORTUGUESE"=>"Barrio Obrero"	14
3719224	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Cerrito", "PORTUGUESE"=>"Cerrito"	14
3720225	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Desmochado", "PORTUGUESE"=>"Desmochado"	14
3721226	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"General José Eduvigis Díaz", "PORTUGUESE"=>"General José Eduvigis Díaz"	14
3722227	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Guazu Cua", "PORTUGUESE"=>"Guazu Cua"	14
3723228	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Humaitá", "PORTUGUESE"=>"Humaitá"	14
3724229	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Isla Umbú", "PORTUGUESE"=>"Isla Umbú"	14
3725230	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Laureles", "PORTUGUESE"=>"Laureles"	14
3726231	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Mayor José de J. Martinez", "PORTUGUESE"=>"Mayor José de J. Martinez"	14
3727232	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Paso de Patria", "PORTUGUESE"=>"Paso de Patria"	14
3728233	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Pilar", "PORTUGUESE"=>"Pilar"	14
3729234	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"San Juan B. de Ñeembucu", "PORTUGUESE"=>"San Juan B. de Ñeembucu"	14
3730235	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Tacuaras", "PORTUGUESE"=>"Tacuaras"	14
3731236	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Villa Franca", "PORTUGUESE"=>"Villa Franca"	14
3732237	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Villa Oliva", "PORTUGUESE"=>"Villa Oliva"	14
3733238	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Villalbin", "PORTUGUESE"=>"Villalbin"	14
3734239	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Acahay", "PORTUGUESE"=>"Acahay"	15
3735240	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Caapucú", "PORTUGUESE"=>"Caapucú"	15
3736241	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Caballero", "PORTUGUESE"=>"Caballero"	15
3737242	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Carapeguá", "PORTUGUESE"=>"Carapeguá"	15
3738243	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Cerro Leon", "PORTUGUESE"=>"Cerro Leon"	15
3739244	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Colonia G. Cesar Barrientos", "PORTUGUESE"=>"Colonia G. Cesar Barrientos"	15
3740245	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Colonia Santa Isabel", "PORTUGUESE"=>"Colonia Santa Isabel"	15
3741246	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Escobar", "PORTUGUESE"=>"Escobar"	15
3742247	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"La Colmena", "PORTUGUESE"=>"La Colmena"	15
3743248	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Mbuyapey", "PORTUGUESE"=>"Mbuyapey"	15
3744249	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Paraguari", "PORTUGUESE"=>"Paraguari"	15
3745250	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Pirayu", "PORTUGUESE"=>"Pirayu"	15
3746251	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Quiindy", "PORTUGUESE"=>"Quiindy"	15
3747252	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Quyquyho", "PORTUGUESE"=>"Quyquyho"	15
3748253	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"San Roque Gonzalez", "PORTUGUESE"=>"San Roque Gonzalez"	15
3749254	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Sapucai", "PORTUGUESE"=>"Sapucai"	15
3750255	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Tebicuary-Mi", "PORTUGUESE"=>"Tebicuary-Mi"	15
3751256	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Valle Apúa", "PORTUGUESE"=>"Valle Apúa"	15
3752257	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Yaguarón", "PORTUGUESE"=>"Yaguarón"	15
3753258	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Ybycuí", "PORTUGUESE"=>"Ybycuí"	15
3754259	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Ybytymí", "PORTUGUESE"=>"Ybytymí"	15
3755260	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Benjamín Aceval", "PORTUGUESE"=>"Benjamín Aceval"	16
3756261	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Chaco-i", "PORTUGUESE"=>"Chaco-i"	16
3757262	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Colonia Falcón", "PORTUGUESE"=>"Colonia Falcón"	16
3758263	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Dr. Francia (Beteretecue)", "PORTUGUESE"=>"Dr. Francia (Beteretecue)"	16
3759264	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Fortin Esteban Martinez", "PORTUGUESE"=>"Fortin Esteban Martinez"	16
3760265	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Fortín General Bruguez", "PORTUGUESE"=>"Fortín General Bruguez"	16
3761266	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Nanawa", "PORTUGUESE"=>"Nanawa"	16
3762267	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Pozo Colorado", "PORTUGUESE"=>"Pozo Colorado"	16
3763268	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Puerto Pinasco", "PORTUGUESE"=>"Puerto Pinasco"	16
3764269	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Villa Hayes", "PORTUGUESE"=>"Villa Hayes"	16
3765270	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Antequera", "PORTUGUESE"=>"Antequera"	17
3766271	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Chore", "PORTUGUESE"=>"Chore"	17
3767272	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Colonia Friesland", "PORTUGUESE"=>"Colonia Friesland"	17
3768273	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Colonia Navidad", "PORTUGUESE"=>"Colonia Navidad"	17
3769274	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Colonia Volendam", "PORTUGUESE"=>"Colonia Volendam"	17
3770275	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"General Aquino", "PORTUGUESE"=>"General Aquino"	17
3771276	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"General Resquin", "PORTUGUESE"=>"General Resquin"	17
3772277	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Guayaibi", "PORTUGUESE"=>"Guayaibi"	17
3773278	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Itacurubi", "PORTUGUESE"=>"Itacurubi"	17
3774279	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Lima", "PORTUGUESE"=>"Lima"	17
3775280	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Nueva Germania", "PORTUGUESE"=>"Nueva Germania"	17
3776281	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Puerto Rosario", "PORTUGUESE"=>"Puerto Rosario"	17
3777282	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Puerto Ybapobó", "PORTUGUESE"=>"Puerto Ybapobó"	17
3778283	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"San Estanislao", "PORTUGUESE"=>"San Estanislao"	17
3779284	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"San José del Rosario", "PORTUGUESE"=>"San José del Rosario"	17
3780285	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"San Pablo", "PORTUGUESE"=>"San Pablo"	17
3781286	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"San Pedro", "PORTUGUESE"=>"San Pedro"	17
3782287	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Tacuatí", "PORTUGUESE"=>"Tacuatí"	17
3783288	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Unión", "PORTUGUESE"=>"Unión"	17
3784289	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Villa del Rosario", "PORTUGUESE"=>"Villa del Rosario"	17
3785290	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Yataity del Norte", "PORTUGUESE"=>"Yataity del Norte"	17
3786\.
3787
3788
3789--
3790-- Name: cidade_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vidafacil
3791--
3792
3793SELECT pg_catalog.setval('cidade_id_seq', 1, false);
3794
3795
3796--
3797-- Data for Name: cliente; Type: TABLE DATA; Schema: public; Owner: vidafacil
3798--
3799
3800COPY cliente (id, created, updated, estado_civil, sexo, tipo_documento, versao_anterior, conjuge_id, endereco_id, profissao_id, user_id, celular, data_nascimento, documento, especificacao_profissao_outro, telefone_residencial, whatsapp, telefone_trabalho, endereco_trabalho_id) FROM stdin;
38011000	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	0	0	0	\N	1000	1000	1	1000	123123	2018-03-29 15:13:01.44651	2131232	\N	\N	\N	\N	1000
38021001	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	0	0	0	\N	1000	1000	1	1001	123123	2018-03-29 15:13:01.44651	2131232	\N	\N	\N	\N	1000
38031	2018-03-29 19:03:18.026	\N	0	0	0	\N	\N	1000	1	2	45991919191	2018-03-29 15:14:36.104139	123456789	\N	2222222	12321231213	12312213132	1000
3804\.
3805
3806
3807--
3808-- Name: cliente_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vidafacil
3809--
3810
3811SELECT pg_catalog.setval('cliente_id_seq', 1, true);
3812
3813
3814--
3815-- Data for Name: cobertura_plano_seguro; Type: TABLE DATA; Schema: public; Owner: vidafacil
3816--
3817
3818COPY cobertura_plano_seguro (id, created, updated, cobertura_relevante, descricao, ordem_relevancia, valor, plano_seguro_id) FROM stdin;
38191	2018-03-29 15:13:01.44651	\N	t	"SPANISH"=>"Cobertura um", "PORTUGUESE"=>"Cobertura um"	1	100.000	1000
38202	2018-03-29 15:13:01.44651	\N	t	"SPANISH"=>"Cobertura dois", "PORTUGUESE"=>"Cobertura dois"	2	200.000	1000
382120	2018-03-29 18:15:29.560116	\N	t	"SPANISH"=>"Cobertura mil e dois", "PORTUGUESE"=>"Cobertura mil e dois"	1	200.000	1002
382210	2018-03-29 18:15:29.560116	\N	t	"SPANISH"=>"Cobertura teste", "PORTUGUESE"=>"Cobertura teste"	1	250.000	1007
382315	2018-03-29 18:15:29.560116	\N	t	"SPANISH"=>"Cobertura mil e sete", "PORTUGUESE"=>"Cobertura mil e sete"	2	100.000	1007
382424	2018-03-29 18:15:29.560116	\N	t	"SPANISH"=>"Cobertura mil e sete tres", "PORTUGUESE"=>"Cobertura mil e tres"	3	2000.000	1007
382523	2018-03-29 18:15:29.560116	\N	t	"SPANISH"=>"Cobertura mil e cinco", "PORTUGUESE"=>"Cobertura mil e cinco"	1	100.000	1005
382622	2018-03-29 18:15:29.560116	\N	t	"SPANISH"=>"Cobertura mil e quatro", "PORTUGUESE"=>"Cobertura mil e quatro"	1	100.000	1004
382721	2018-03-29 18:15:29.560116	\N	t	"SPANISH"=>"Cobertura mil e três", "PORTUGUESE"=>"Cobertura mil e três"	1	100.000	1003
382813	2018-03-29 18:15:29.560116	\N	t	"SPANISH"=>"Cobertura mil e seis um", "PORTUGUESE"=>"Cobertura mil e seis um"	1	150.000	1006
382914	2018-03-29 18:15:29.560116	\N	t	"SPANISH"=>"Cobertura mil e seis dois", "PORTUGUESE"=>"Cobertura mil e seis dois"	2	100.000	1006
38303	2018-03-29 15:13:01.44651	\N	t	"SPANISH"=>"Cobertura três", "PORTUGUESE"=>"Cobertura três"	1	300.000	1001
38314	2018-03-29 15:13:01.44651	\N	t	"SPANISH"=>"Cobertura quatro", "PORTUGUESE"=>"Cobertura quatro"	2	400.000	1001
38325	2018-03-29 15:13:01.44651	\N	t	"SPANISH"=>"Cobertura cinco", "PORTUGUESE"=>"Cobertura cinco"	3	500.000	1001
3833\.
3834
3835
3836--
3837-- Name: cobertura_plano_seguro_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vidafacil
3838--
3839
3840SELECT pg_catalog.setval('cobertura_plano_seguro_id_seq', 24, true);
3841
3842
3843--
3844-- Data for Name: configuracao_perfil_usuario_plano_seguro; Type: TABLE DATA; Schema: public; Owner: vidafacil
3845--
3846
3847COPY configuracao_perfil_usuario_plano_seguro (id, created, updated, perfil_usuario_plano_seguro, plano_seguro_id) FROM stdin;
3848\.
3849
3850
3851--
3852-- Name: configuracao_perfil_usuario_plano_seguro_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vidafacil
3853--
3854
3855SELECT pg_catalog.setval('configuracao_perfil_usuario_plano_seguro_id_seq', 1, false);
3856
3857
3858--
3859-- Data for Name: configuracao_plataforma; Type: TABLE DATA; Schema: public; Owner: vidafacil
3860--
3861
3862COPY configuracao_plataforma (id, created, updated, limite_reenvio_email_rejeicao_cotacao, tempo_reenvio_email_rejeicao_cotacao) FROM stdin;
3863\.
3864
3865
3866--
3867-- Name: configuracao_plataforma_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vidafacil
3868--
3869
3870SELECT pg_catalog.setval('configuracao_plataforma_id_seq', 1, false);
3871
3872
3873--
3874-- Data for Name: conjuge; Type: TABLE DATA; Schema: public; Owner: vidafacil
3875--
3876
3877COPY conjuge (id, created, updated, data_nascimento, documento, nome_completo, especificacao_profissao_outro_conjuge, tipo_documento, profissao_id) FROM stdin;
38781000	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	12312312	Julia	\N	0	1
3879\.
3880
3881
3882--
3883-- Name: conjuge_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vidafacil
3884--
3885
3886SELECT pg_catalog.setval('conjuge_id_seq', 1, false);
3887
3888
3889--
3890-- Data for Name: endereco; Type: TABLE DATA; Schema: public; Owner: vidafacil
3891--
3892
3893COPY endereco (id, created, updated, bairro, codigo_postal, complemento, logradouro, numero, cidade_id) FROM stdin;
38941000	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	bairro 	\N	\N	logrdouro	\N	1
38959	2018-04-02 10:47:20.205	\N	\N	\N	\N	Rua Edmundo de Barros	1849	4
389610	2018-04-02 10:47:20.207	\N	\N	\N	\N	Rua Edmundo de Barros	1849	4
389711	2018-04-02 15:47:15.409	\N	\N	\N	\N	Rua Teste	\N	3
389812	2018-04-02 15:47:15.411	\N	\N	\N	\N	Rua Teste	\N	3
389917	2018-04-02 15:59:47.188	\N	\N	\N	\N	Rua Teste	\N	4
390018	2018-04-02 15:59:47.19	\N	\N	\N	\N	Rua Teste	\N	4
390119	2018-04-02 16:05:57.781	\N	\N	\N	\N	Rua Teste	\N	5
390220	2018-04-02 16:05:57.782	\N	\N	\N	\N	Rua Teste	\N	5
3903\.
3904
3905
3906--
3907-- Name: endereco_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vidafacil
3908--
3909
3910SELECT pg_catalog.setval('endereco_id_seq', 20, true);
3911
3912
3913--
3914-- Data for Name: estado; Type: TABLE DATA; Schema: public; Owner: vidafacil
3915--
3916
3917COPY estado (id, created, updated, nome, pais_id) FROM stdin;
39181	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Alto Paraguay", "PORTUGUESE"=>"Alto Paraguay"	1
39192	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Alto Paraná", "PORTUGUESE"=>"Alto Paraná"	1
39203	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Amambay", "PORTUGUESE"=>"Amambay"	1
39214	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Boquerón", "PORTUGUESE"=>"Boquerón"	1
39225	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Caaguazú", "PORTUGUESE"=>"Caaguazú"	1
39236	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Caazapá", "PORTUGUESE"=>"Caazapá"	1
39247	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Canindeyú", "PORTUGUESE"=>"Canindeyú"	1
39258	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Central", "PORTUGUESE"=>"Central"	1
39269	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Concepción", "PORTUGUESE"=>"Concepción"	1
392710	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Cordillera", "PORTUGUESE"=>"Cordillera"	1
392811	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Guairá", "PORTUGUESE"=>"Guairá"	1
392912	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Itapúa", "PORTUGUESE"=>"Itapúa"	1
393013	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Misiones", "PORTUGUESE"=>"Misiones"	1
393114	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Ñeembucú", "PORTUGUESE"=>"Ñeembucú"	1
393215	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Paraguarí", "PORTUGUESE"=>"Paraguarí"	1
393316	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Presidente Hayes", "PORTUGUESE"=>"Presidente Hayes"	1
393417	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"San Pedro", "PORTUGUESE"=>"San Pedro"	1
3935\.
3936
3937
3938--
3939-- Name: estado_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vidafacil
3940--
3941
3942SELECT pg_catalog.setval('estado_id_seq', 1, false);
3943
3944
3945--
3946-- Data for Name: executivo; Type: TABLE DATA; Schema: public; Owner: vidafacil
3947--
3948
3949COPY executivo (id, created, updated, agente_id, user_id) FROM stdin;
39501001	2018-03-29 15:13:01.44651	\N	9999	1001
39511002	2018-03-29 15:13:01.44651	\N	9999	1002
3952\.
3953
3954
3955--
3956-- Name: executivo_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vidafacil
3957--
3958
3959SELECT pg_catalog.setval('executivo_id_seq', 1, false);
3960
3961
3962--
3963-- Data for Name: formulario_perfil_usuario_cotacao_seguro; Type: TABLE DATA; Schema: public; Owner: vidafacil
3964--
3965
3966COPY formulario_perfil_usuario_cotacao_seguro (id, created, updated, formulario_cotacao_plano_seguro, configuracao_perfil_usuario_plano_seguro_id) FROM stdin;
3967\.
3968
3969
3970--
3971-- Name: formulario_perfil_usuario_cotacao_seguro_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vidafacil
3972--
3973
3974SELECT pg_catalog.setval('formulario_perfil_usuario_cotacao_seguro_id_seq', 1, false);
3975
3976
3977--
3978-- Data for Name: grupo_empresa; Type: TABLE DATA; Schema: public; Owner: vidafacil
3979--
3980
3981COPY grupo_empresa (id, created, updated, nome_fantasia, responsavel_rh_id, pagamento_comum) FROM stdin;
39821000	2018-03-29 15:13:01.44651	\N	Computer CIA	1002	t
39831001	2018-03-29 15:13:01.44651	\N	No CIA	9999	f
3984\.
3985
3986
3987--
3988-- Name: grupo_empresa_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vidafacil
3989--
3990
3991SELECT pg_catalog.setval('grupo_empresa_id_seq', 1, false);
3992
3993
3994--
3995-- Data for Name: historico_apolice_seguro; Type: TABLE DATA; Schema: public; Owner: vidafacil
3996--
3997
3998COPY historico_apolice_seguro (id, created, updated, data_operacao, operacao_troca_status_apolice_seguro, apolice_seguro_id, user_id, observacao) FROM stdin;
39991001	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	1	1001	1001	por que não
40001	2018-03-29 18:08:19.106	\N	2018-03-29 18:08:19.095	0	1001	\N	Teste
40012	2018-03-29 19:03:18.035	2018-03-29 19:03:18.045	2018-03-29 19:03:18.033	1	1	\N	\N
4002\.
4003
4004
4005--
4006-- Name: historico_apolice_seguro_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vidafacil
4007--
4008
4009SELECT pg_catalog.setval('historico_apolice_seguro_id_seq', 2, true);
4010
4011
4012--
4013-- Data for Name: historico_solicitacao_cotacao_seguro; Type: TABLE DATA; Schema: public; Owner: vidafacil
4014--
4015
4016COPY historico_solicitacao_cotacao_seguro (id, created, updated, data_operacao, operacao_troca_status_solicitacao_seguro, observacao, solicitacao_cotacao_seguro_id, user_id) FROM stdin;
40171	2018-03-29 17:50:34.931104	\N	2018-03-29 17:50:34.931104	0	avaliacao	1004	1001
40183	2018-03-29 17:50:59.595941	\N	2018-03-29 17:50:59.595941	2	aprovada	1004	1001
40194	2018-03-29 17:51:10.419919	\N	2018-03-29 17:51:10.419919	3	rejeitada	1004	1001
40205	2018-03-29 17:51:21.585983	\N	2018-03-29 17:51:21.585983	4	cancelada	1004	1001
40212	2018-03-29 17:50:50.194132	\N	2018-03-29 17:50:50.194132	1	envio parcial	1004	\N
40226	2018-03-29 18:48:56.872	\N	2018-03-29 18:48:56.867	2	Teste	1004	\N
40237	2018-03-29 18:50:24.27	\N	2018-03-29 18:50:24.27	2	Teste	1002	\N
40248	2018-03-29 19:03:18.008	\N	2018-03-29 19:03:17.999	6	\N	1001	\N
402517	2018-04-02 15:47:15.414	\N	2018-04-02 15:47:15.414	4	\N	4	\N
402622	2018-04-02 16:04:55.472	\N	2018-04-02 16:04:55.468	0	\N	6	\N
402723	2018-04-02 16:05:57.785	\N	2018-04-02 16:05:57.784	4	\N	6	\N
402824	2018-04-02 16:09:51.16	\N	2018-04-02 16:09:51.158	0	\N	7	\N
402925	2018-04-02 16:11:47.925	\N	2018-04-02 16:11:47.922	0	\N	8	\N
4030\.
4031
4032
4033--
4034-- Name: historico_solicitacao_cotacao_seguro_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vidafacil
4035--
4036
4037SELECT pg_catalog.setval('historico_solicitacao_cotacao_seguro_id_seq', 25, true);
4038
4039
4040--
4041-- Data for Name: pais; Type: TABLE DATA; Schema: public; Owner: vidafacil
4042--
4043
4044COPY pais (id, created, updated, nome) FROM stdin;
40451	2018-03-29 15:08:23.161197	\N	"SPANISH"=>"Paraguay", "PORTUGUESE"=>"Paraguai"
4046\.
4047
4048
4049--
4050-- Name: pais_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vidafacil
4051--
4052
4053SELECT pg_catalog.setval('pais_id_seq', 1, false);
4054
4055
4056--
4057-- Data for Name: perfil_acesso; Type: TABLE DATA; Schema: public; Owner: vidafacil
4058--
4059
4060COPY perfil_acesso (id, created, updated, descricao, editavel, nome, removivel) FROM stdin;
40611000	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	\N	f	"SPANISH"=>"EXECUTIVO", "PORTUGUESE"=>"EXECUTIVO"	f
40621001	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	\N	f	"SPANISH"=>"AGENTE", "PORTUGUESE"=>"AGENTE"	f
40631002	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	\N	f	"SPANISH"=>"RHEMPRESA", "PORTUGUESE"=>"RHEMPRESA"	f
4064\.
4065
4066
4067--
4068-- Name: perfil_acesso_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vidafacil
4069--
4070
4071SELECT pg_catalog.setval('perfil_acesso_id_seq', 1, false);
4072
4073
4074--
4075-- Data for Name: perfil_acesso_permissao; Type: TABLE DATA; Schema: public; Owner: vidafacil
4076--
4077
4078COPY perfil_acesso_permissao (id, created, updated, permissao_identificador, perfil_acesso_id) FROM stdin;
40791000	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	solicitacao_seguro.consultar_apolices	1000
40801001	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	solicitacao_seguro.consultar_apolices	1001
40811002	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	solicitacao_seguro.consultar_apolices	1002
40821003	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	solicitacao_seguro.visualizar_apolice	1001
40831004	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	solicitacao_seguro.dar_baixa_apolice	1001
40841006	2018-03-29 15:14:51.758576	2018-03-29 15:14:51.758576	solicitacao_seguro.consultar_cotacao	1001
40851007	2018-03-29 15:38:38.667798	2018-03-29 15:38:38.667798	solicitacao_seguro.visualizar_cotacao	1001
40861008	2018-03-29 16:47:08.060947	2018-03-29 16:47:08.060947	solicitacao_seguro.visualizar_cotacao	1001
40871009	2018-03-29 18:42:48.994748	2018-03-29 18:42:48.994748	solicitacao_seguro.aprovar_cotacao	1001
40881010	2018-03-29 18:42:48.994748	2018-03-29 18:42:48.994748	solicitacao_seguro.rejeitar_cotacao	1001
4089\.
4090
4091
4092--
4093-- Name: perfil_acesso_permissao_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vidafacil
4094--
4095
4096SELECT pg_catalog.setval('perfil_acesso_permissao_id_seq', 1, false);
4097
4098
4099--
4100-- Data for Name: plano_seguro; Type: TABLE DATA; Schema: public; Owner: vidafacil
4101--
4102
4103COPY plano_seguro (id, created, updated, descricao, nome, ordem_relevancia, permite_incluir_conjuge, valor, produto_seguro_id) FROM stdin;
41041000	2018-03-29 15:13:01.44651	\N	"SPANISH"=>"Plano 1000 Teste 1", "PORTUGUESE"=>"Plano 1000"	"SPANISH"=>"PLANO MIL", "PORTUGUESE"=>"PLANO MIL"	0	t	10	1000
41051001	2018-03-29 15:13:01.44651	\N	"SPANISH"=>"Plano 1 Teste 1", "PORTUGUESE"=>"Plano 1 Teste 1"	"SPANISH"=>"PLANO VERDE", "PORTUGUESE"=>"PLANO VERDE"	0	f	10	1000
41061002	2018-03-29 15:13:01.44651	\N	"SPANISH"=>"Plano 2 Teste 1", "PORTUGUESE"=>"Plano 2"	"SPANISH"=>"PLANO AZUL", "PORTUGUESE"=>"PLANO AZUL"	0	f	10	1000
41071003	2018-03-29 15:13:01.44651	\N	"SPANISH"=>"Plano 3 Teste 1", "PORTUGUESE"=>"Plano 3"	"SPANISH"=>"PLANO VERMELHO", "PORTUGUESE"=>"PLANO VERMELHO"	0	f	10	1002
41081004	2018-03-29 15:13:01.44651	\N	"SPANISH"=>"Plano 4 Teste 1", "PORTUGUESE"=>"Plano 4"	"SPANISH"=>"PLANO PRATA", "PORTUGUESE"=>"PLANO PRATA"	0	f	10	1003
41091005	2018-03-29 15:13:01.44651	\N	"SPANISH"=>"Plano 5 Teste 1", "PORTUGUESE"=>"Plano 5"	"SPANISH"=>"PLANO OURO", "PORTUGUESE"=>"PLANO OURO"	0	f	10	1004
41101006	2018-03-29 15:13:01.44651	\N	"SPANISH"=>"Plano 6 Teste 1", "PORTUGUESE"=>"Plano 6"	"SPANISH"=>"PLANO DIAMANTE", "PORTUGUESE"=>"PLANO DIAMANTE"	0	t	10	1005
41111007	2018-03-29 15:13:01.44651	\N	"SPANISH"=>"Plano 7 Teste 1", "PORTUGUESE"=>"Plano 7"	"SPANISH"=>"PLANO TESTE", "PORTUGUESE"=>"PLANO TESTE"	0	t	10	1006
4112\.
4113
4114
4115--
4116-- Name: plano_seguro_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vidafacil
4117--
4118
4119SELECT pg_catalog.setval('plano_seguro_id_seq', 1, false);
4120
4121
4122--
4123-- Data for Name: produto_seguro; Type: TABLE DATA; Schema: public; Owner: vidafacil
4124--
4125
4126COPY produto_seguro (id, created, updated, nome, ordem_relevancia) FROM stdin;
41271000	2018-03-29 15:13:01.44651	\N	"SPANISH"=>"Produto 1000", "PORTUGUESE"=>"Produto 1000"	12
41281001	2018-03-29 15:13:01.44651	\N	"SPANISH"=>"Produto 1", "PORTUGUESE"=>"Produto 1"	0
41291002	2018-03-29 15:13:01.44651	\N	"SPANISH"=>"Produto 2", "PORTUGUESE"=>"Produto 2"	1
41301003	2018-03-29 15:13:01.44651	\N	"SPANISH"=>"Produto 3", "PORTUGUESE"=>"Produto 3"	2
41311004	2018-03-29 15:13:01.44651	\N	"SPANISH"=>"Produto 4", "PORTUGUESE"=>"Produto 4"	3
41321005	2018-03-29 15:13:01.44651	\N	"SPANISH"=>"Produto 5", "PORTUGUESE"=>"Produto 5"	4
41331006	2018-03-29 15:13:01.44651	\N	"SPANISH"=>"Produto 6", "PORTUGUESE"=>"Produto 6"	5
41341007	2018-03-29 15:13:01.44651	\N	"SPANISH"=>"Produto 7", "PORTUGUESE"=>"Produto 7"	6
41351008	2018-03-29 15:13:01.44651	\N	"SPANISH"=>"Produto 8", "PORTUGUESE"=>"Produto 8"	7
41361009	2018-03-29 15:13:01.44651	\N	"SPANISH"=>"Produto 9", "PORTUGUESE"=>"Produto 9"	8
41371010	2018-03-29 15:13:01.44651	\N	"SPANISH"=>"Produto 10", "PORTUGUESE"=>"Produto 10"	9
41381011	2018-03-29 15:13:01.44651	\N	"SPANISH"=>"Produto 11", "PORTUGUESE"=>"Produto 11"	10
41391012	2018-03-29 15:13:01.44651	\N	"SPANISH"=>"Produto 12", "PORTUGUESE"=>"Produto 12"	11
4140\.
4141
4142
4143--
4144-- Name: produto_seguro_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vidafacil
4145--
4146
4147SELECT pg_catalog.setval('produto_seguro_id_seq', 1, false);
4148
4149
4150--
4151-- Data for Name: profissao; Type: TABLE DATA; Schema: public; Owner: vidafacil
4152--
4153
4154COPY profissao (id, created, updated, descricao) FROM stdin;
41551	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Abogado", "PORTUGUESE"=>"Advogado"
41562	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Agente de Seguros", "PORTUGUESE"=>"Agente de Seguros"
41573	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Ama de Casa", "PORTUGUESE"=>"Dona de Casa"
41584	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Ama de Cocina", "PORTUGUESE"=>"Chefe de Cozinha"
41595	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Arquitecto", "PORTUGUESE"=>"Arquiteto"
41606	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Auxiliar de Cocina", "PORTUGUESE"=>"Assistente de Cozinha"
41617	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Auxiliar de Reparto", "PORTUGUESE"=>"Assistente de Entrega"
41628	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Auxiliar de Restaurant", "PORTUGUESE"=>"Assistente de Restaurante"
41639	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Aviador/Piloto", "PORTUGUESE"=>"Aviador/Piloto"
416410	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Bombero", "PORTUGUESE"=>"Bombeiro"
416511	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Chofer", "PORTUGUESE"=>"Motorista"
416612	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Cajero", "PORTUGUESE"=>"Caixa"
416713	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Carpintero", "PORTUGUESE"=>"Carpinteiro"
416814	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Cobrador", "PORTUGUESE"=>"Cobrador"
416915	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Cocinero", "PORTUGUESE"=>"Cozinheiro"
417016	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Confitero", "PORTUGUESE"=>"Confeiteiro"
417117	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Constructor", "PORTUGUESE"=>"Construtor"
417218	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Consultor de Servicios/Productos", "PORTUGUESE"=>"Consultor de Serviços/Produtos"
417319	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Contador/Auditor", "PORTUGUESE"=>"Contador/Auditor"
417420	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Contratista", "PORTUGUESE"=>"Contratante"
417521	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Despachante de Aduana", "PORTUGUESE"=>"Corretor Aduaneiro"
417622	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Diplomático", "PORTUGUESE"=>"Diplomata"
417723	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Fumigador", "PORTUGUESE"=>"Dedetizador"
417824	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Diseñador de Modas", "PORTUGUESE"=>"Estilista"
417925	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Diseñador Industrial", "PORTUGUESE"=>"Designer Industrial"
418026	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Diseñador Web", "PORTUGUESE"=>"Web Designer"
418127	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Diseño de Interiores/Decoración", "PORTUGUESE"=>"Designer de Interiores/Decorador"
418228	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Diseñador gráfico", "PORTUGUESE"=>"Designer Gráfico"
418329	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Ejecutivo Comercial", "PORTUGUESE"=>"Executivo de Negócios"
418430	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Electricista", "PORTUGUESE"=>"Eletricista"
418531	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Empresario Comercial/Industrial", "PORTUGUESE"=>"Empresário Comerciante/Industrial"
418632	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Empresario PYMES", "PORTUGUESE"=>"Empresário PYMES"
418733	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Encargado de Cocina", "PORTUGUESE"=>"Encarregado de Cozinha"
418834	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Encargado de Depósito", "PORTUGUESE"=>"Encarregado de Depósito"
418935	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Escribano", "PORTUGUESE"=>"Escrivão"
419036	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Estudiante", "PORTUGUESE"=>"Estudante"
419137	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Farmaceútico", "PORTUGUESE"=>"Farmacêutico"
419238	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Ganadero", "PORTUGUESE"=>"Racheiro"
419339	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Gerente/Director", "PORTUGUESE"=>"Gerente/Diretor"
419440	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Gestor Comercial", "PORTUGUESE"=>"Gerente Comercial"
419541	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Guardia/Seguridad", "PORTUGUESE"=>"Guarda/Segurança"
419642	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Guardería / Seguridad (sin carga de arma)", "PORTUGUESE"=>"Guarda/Segurança (sem porte de arma)"
419743	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Informático Programador", "PORTUGUESE"=>"Programador/Desenvolvedor de Software"
419844	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Ingeniero Agronomo", "PORTUGUESE"=>"Engenheiro Agrônomo"
419945	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Ingeniero Eléctrico", "PORTUGUESE"=>"Engenheiro Eletricista"
420046	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Ingeniero Electromecánico", "PORTUGUESE"=>"Engenheiro Eletromecânico"
420147	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Ingeniero en Comunicación", "PORTUGUESE"=>"Engenheiro da Computação"
420248	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Ingeniero Industrial", "PORTUGUESE"=>"Engenheiro Industrial"
420349	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Ingeniero Químico", "PORTUGUESE"=>"Engenheiro Químico"
420450	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Ingeniero de Riesgos", "PORTUGUESE"=>"Engenheiro de Riscos"
420551	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Instructor", "PORTUGUESE"=>"Instrutor"
420652	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Locutor", "PORTUGUESE"=>"Palestrante"
420753	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Marketing", "PORTUGUESE"=>"Marketing"
420854	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Mecánico", "PORTUGUESE"=>"Mecânico"
420955	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Mozo", "PORTUGUESE"=>"Garçom"
421056	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Nutricionista", "PORTUGUESE"=>"Nutricionista"
421157	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Operador de Maquinas", "PORTUGUESE"=>"Operador de Máquinas"
421258	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Operador Técnico", "PORTUGUESE"=>"Operador Técnico"
421359	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Operario Agrícola", "PORTUGUESE"=>"Trabalhador Agrícola"
421460	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Operario de Construcción", "PORTUGUESE"=>"Trabalhador da Construção Civil"
421561	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Operario de Depósitos/Logística", "PORTUGUESE"=>"Operador de Depósitos/Logística"
421662	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Operador de Planta", "PORTUGUESE"=>"Operador de Planta"
421763	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Operario Estación de Servicios", "PORTUGUESE"=>"Operador de Estação de Serviços"
421864	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Operario Ganadero", "PORTUGUESE"=>"Operário Rancheiro"
421965	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Ordenanza/Secretario", "PORTUGUESE"=>"Ordenança/Secretário"
422066	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Otro", "PORTUGUESE"=>"Outro"
422167	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Periodista", "PORTUGUESE"=>"Jornalista"
422268	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Oficial de Policía", "PORTUGUESE"=>"Policial"
422369	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Productor Agrícola", "PORTUGUESE"=>"Produtos Agrícula"
422470	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Profesional de Deporte", "PORTUGUESE"=>"Profissional do Esporte"
422571	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Profesional de Educación", "PORTUGUESE"=>"Profissional da Educação"
422672	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Profesional de Salud", "PORTUGUESE"=>"Profissional da Saúde"
422773	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Promotor", "PORTUGUESE"=>"Promotor"
422874	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Psicólogo", "PORTUGUESE"=>"Psicólogo"
422975	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Recepcionista", "PORTUGUESE"=>"Recepcionista"
423076	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Secretario", "PORTUGUESE"=>"Secretário"
423177	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Servicios Administrativos", "PORTUGUESE"=>"Serviços Administrativos"
423278	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Servicios Comerciales", "PORTUGUESE"=>"Serviços Comerciais"
423379	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Servicios de Atención al Cliente", "PORTUGUESE"=>"Serviços de Atenção ao Cliente"
423480	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Servicios de Belleza", "PORTUGUESE"=>"Serviços de Beleza"
423581	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Servicios de Delivery", "PORTUGUESE"=>"Serviços de Delivery"
423682	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Servicios de Flete", "PORTUGUESE"=>"Serviços de Fretagem"
423783	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Servicios de Hotelería", "PORTUGUESE"=>"Serviços de Hotelaria"
423884	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Servicios de Investigación de Mercado", "PORTUGUESE"=>"Serviços de Pesquisa de Mercado"
423985	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Servicios de limpieza", "PORTUGUESE"=>"Serviços de Limpeza"
424086	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Servicios de Mantenimiento de Locales", "PORTUGUESE"=>"Serviços de Manutenção de Instalações"
424187	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Servicios de Medioambiente", "PORTUGUESE"=>"Serviços de Meio Ambiente"
424288	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Servicios de Taller Chapería", "PORTUGUESE"=>"Serviços de Oficina/Chapeação"
424389	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Empleado Estatal", "PORTUGUESE"=>"Servidor Público"
424490	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Supervisor Administrativo", "PORTUGUESE"=>"Supervisor Administrativo"
424591	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Supervisor Comercial", "PORTUGUESE"=>"Supervisor Comercial"
424692	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Supervisor de Ventas", "PORTUGUESE"=>"Supervidor de Vendas"
424793	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Técnico de Maquinarias", "PORTUGUESE"=>"Técnico de Maquinários"
424894	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Técnico en Computación", "PORTUGUESE"=>"Técnico em Computação/Informática"
424995	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Técnico en Internet", "PORTUGUESE"=>"Técnico em Internet"
425096	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Tripulante de barco/aeronave", "PORTUGUESE"=>"Tripulante de barco/aeronave"
425197	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Vendedor", "PORTUGUESE"=>"Vendedor"
425298	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Veterinario", "PORTUGUESE"=>"Veterinário"
425399	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Visitador Médico", "PORTUGUESE"=>"Visitador Médico/Domicílio"
4254100	2018-03-29 15:08:23.056023	\N	"SPANISH"=>"Velocista", "PORTUGUESE"=>"Velocista"
4255\.
4256
4257
4258--
4259-- Name: profissao_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vidafacil
4260--
4261
4262SELECT pg_catalog.setval('profissao_id_seq', 1, false);
4263
4264
4265--
4266-- Data for Name: profissao_restricao_plano_seguro; Type: TABLE DATA; Schema: public; Owner: vidafacil
4267--
4268
4269COPY profissao_restricao_plano_seguro (id, created, updated, plano_seguro_id, profissao_id) FROM stdin;
4270\.
4271
4272
4273--
4274-- Name: profissao_restricao_plano_seguro_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vidafacil
4275--
4276
4277SELECT pg_catalog.setval('profissao_restricao_plano_seguro_id_seq', 1, false);
4278
4279
4280--
4281-- Data for Name: schema_version; Type: TABLE DATA; Schema: public; Owner: vidafacil
4282--
4283
4284COPY schema_version (installed_rank, version, description, type, script, checksum, installed_by, installed_on, execution_time, success) FROM stdin;
42851	201801010000	filter	SQL	201801010000__filter.sql	-1893315774	vidafacil	2018-03-29 15:08:21.777486	17	t
42862	201802061139	create users	SQL	201802061139__create_users.sql	-1687707621	vidafacil	2018-03-29 15:08:21.810334	51	t
42873	201802091101	intl filter	SQL	201802091101__intl_filter.sql	962421310	vidafacil	2018-03-29 15:08:21.890306	41	t
42884	201802161112	create tables	SQL	201802161112__create_tables.sql	36529975	vidafacil	2018-03-29 15:08:21.962928	585	t
42895	201802191120	insert profissoes	SQL	201802191120__insert_profissoes.sql	1463130559	vidafacil	2018-03-29 15:08:23.056023	5	t
42906	201802271133	insert pais estado cidade	SQL	201802271133__insert_pais_estado_cidade.sql	-774137672	vidafacil	2018-03-29 15:08:23.161197	13	t
42917	201803161611	alter tables	SQL	201803161611__alter_tables.sql	-1154080751	vidafacil	2018-03-29 15:08:23.336487	918	t
4292\.
4293
4294
4295--
4296-- Data for Name: solicitacao_cotacao_seguro; Type: TABLE DATA; Schema: public; Owner: vidafacil
4297--
4298
4299COPY solicitacao_cotacao_seguro (id, created, updated, celular, data_nascimento, documento, email, estado_civil, forma_pagamento, incluir_conjuge_cobertura, nome, numero_solicitacao, sexo, situacao_solicitacao_cotacao_seguro, sobrenome, telefone_residencial, telefone_trabalho, tipo_documento, uso_de_motocicleta, valor_mensal, whatsapp, agente_autorizado_id, apolice_seguro_id, cartao_credito_id, conjuge_id, endereco_residencial_id, endereco_trabalho_id, executivo_id, grupo_empresa_id, plano_seguro_id, profissao_id, edit_token, especificacao_profissao_outro, especificacao_profissao_outro_conjuge) FROM stdin;
43004	2018-04-02 15:45:11.213	2018-04-02 15:47:15.658	456456456456	1995-02-03 15:00:00	456564564	wolleson.kelm@eits.com.br	0	2	f	Wolleson	4	0	0	Kelm	\N	\N	0	f	10.00	\N	\N	\N	\N	\N	11	12	\N	\N	1000	43	\N	\N	\N
43016	2018-04-02 16:04:55.4	2018-04-02 16:05:58.047	123213123213	1992-11-18 07:00:00	123123123213	digossmi@gmail.com	0	2	f	Rodrigo Luis	6	0	0	Fracaroli	\N	\N	0	f	10.00	\N	\N	\N	\N	\N	19	20	\N	\N	1001	43	\N	\N	\N
43028	2018-04-02 16:11:47.881	\N	123213231213	2000-03-31 12:00:00	123123	aloprasd@aloprasd.com.br	0	\N	\N	Alopr Asd	\N	0	1	Adv	\N	\N	0	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	1003	12	\N	\N	\N
43031000	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	121212	2018-03-29 15:13:01.44651	12313123	nome@mail.com	0	0	f	luno	789789789	0	0	lona	\N	\N	0	t	\N	\N	\N	\N	\N	\N	1000	1000	\N	\N	1000	1	\N	\N	\N
43047	2018-04-02 16:09:51.108	\N	231231213213	2000-02-29 12:00:00	123231123	alou@alou.com.br	0	\N	\N	Teste testando	\N	0	1	Teste		\N	0	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	1007	2	\N	\N	\N
43051002	2018-07-13 00:00:00	2018-03-29 18:50:24.273	45991919191	2018-03-29 15:14:36.104139	123456789	teste6@mailinator.com	0	1	f	Fulana	22000000	0	3	Da Silva	4530303030	4530303535	0	f	350.00	4589878977	\N	\N	\N	\N	1000	1000	1001	\N	1006	25	\N	\N	\N
43061004	2018-07-13 00:00:00	2018-03-29 18:48:56.876	10000000	2018-03-29 15:14:36.104139	123456789	teste@mailinator.com	0	1	f	Fulano	1111111	0	3	Da Silva	4530303030	4530303535	0	f	350.00	22222222	\N	\N	\N	\N	1000	1000	1001	\N	1007	25	\N	\N	\N
43071003	2018-07-13 00:00:00	\N	45991919191	2018-03-29 15:14:36.104139	123456789	teste96@mailinator.com	0	1	f	Wolle	22000000	0	1	Da Silva	4530303030	4530303535	0	f	350.00	4589878977	\N	\N	\N	\N	1000	1000	1001	\N	1006	25	\N	\N	\N
43081001	2018-07-13 00:00:00	2018-03-29 19:03:18.029	45991919191	2018-03-29 15:14:36.104139	123456789	testando@mailinator.com	0	1	f	Teste	22211111	0	2	Testando	2222222	12312213132	0	f	30.00	12321231213	\N	\N	\N	\N	1000	1000	1002	\N	1007	1	\N	\N	\N
4309\.
4310
4311
4312--
4313-- Name: solicitacao_cotacao_seguro_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vidafacil
4314--
4315
4316SELECT pg_catalog.setval('solicitacao_cotacao_seguro_id_seq', 8, true);
4317
4318
4319--
4320-- Data for Name: tutor; Type: TABLE DATA; Schema: public; Owner: vidafacil
4321--
4322
4323COPY tutor (id, created, updated, documento, grau_parentesco, nome_completo, tipo_documento, data_nascimento) FROM stdin;
43241	2018-03-29 15:14:36.104139	2018-03-29 15:14:36.104139	1232132	0	Mario Adalberto Silva	0	1952-04-05 03:00:00
43252	2018-03-29 15:14:36.104139	2018-03-29 15:14:36.104139	1232132	0	Aloisio Souza	0	1950-03-01 03:00:00
43263	2018-03-29 15:14:36.104139	2018-03-29 15:14:36.104139	1232132	0	José Luiz Portugues	0	1968-06-10 03:00:00
43274	2018-03-29 15:14:36.104139	2018-03-29 15:14:36.104139	1232132	0	Mario Broz	0	1957-08-12 03:00:00
43285	2018-03-29 15:14:36.104139	2018-03-29 15:14:36.104139	1232132	0	Luigi Broz	0	1961-07-09 03:00:00
43296	2018-03-29 15:14:36.104139	2018-03-29 15:14:36.104139	1232132	0	Princess Peach	0	1962-06-06 03:00:00
43301000	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	1232132	0	Kido Aloha	0	1963-01-01 03:00:00
43311001	2018-03-29 15:14:36.104139	2018-03-29 15:14:36.104139	1232132	0	Holo Loois	0	1964-01-25 03:00:00
43321002	2018-03-29 15:14:36.104139	2018-03-29 15:14:36.104139	1232132	0	Uite Uitente	0	1966-11-21 03:00:00
4333\.
4334
4335
4336--
4337-- Name: tutor_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vidafacil
4338--
4339
4340SELECT pg_catalog.setval('tutor_id_seq', 6, true);
4341
4342
4343--
4344-- Data for Name: user; Type: TABLE DATA; Schema: public; Owner: vidafacil
4345--
4346
4347COPY "user" (id, created, updated, disabled, email, last_login, name, password, sobrenome, role, password_reset_token, password_reset_token_expiration) FROM stdin;
43489999	2018-03-29 15:13:01.44651-03	\N	f	admin@mailinator.com	\N	Ciclano	d1bd2f08fead38a982aed9d4ca060152400b1b8f	de Tal	0	\N	\N
43491000	2018-03-29 15:13:01.44651-03	\N	f	user001@mailinator.com	\N	Rodrigo	d1bd2f08fead38a982aed9d4ca060152400b1b8f	Luis	4	\N	\N
43501001	2018-03-29 15:13:01.44651-03	\N	f	user002@mailinator.com	\N	Lucas	d1bd2f08fead38a982aed9d4ca060152400b1b8f	Boz	1	\N	\N
43511002	2018-03-29 15:13:01.44651-03	\N	f	xova@mailinator.com	\N	Fulano	d1bd2f08fead38a982aed9d4ca060152400b1b8f	 de Tal	2	\N	\N
43521003	2018-03-29 15:13:01.44651-03	\N	f	user003@mailinator.com	\N	Pequeno	d1bd2f08fead38a982aed9d4ca060152400b1b8f	 de Tal	2	\N	\N
43531	2018-03-29 15:08:21.810334-03	2018-04-02 16:27:08.622-03	f	admin@admin.com	2018-04-02 16:27:08.611-03	Administrador de Sistemas	$2a$10$bAdAVLvM.k3DqPaPYi0gnO1OffPSHLref8MElAk.u.fFQ17v9YKC2	de Sistemas	0	\N	\N
43542	2018-03-29 19:03:18.022-03	\N	t	testando@mailinator.com	\N	Teste	123	Testando	2	\N	\N
4355\.
4356
4357
4358--
4359-- Name: user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vidafacil
4360--
4361
4362SELECT pg_catalog.setval('user_id_seq', 2, true);
4363
4364
4365--
4366-- Data for Name: usuario_perfil_acesso; Type: TABLE DATA; Schema: public; Owner: vidafacil
4367--
4368
4369COPY usuario_perfil_acesso (id, created, updated, perfil_acesso_id, user_id) FROM stdin;
43701000	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	1000	1000
43711001	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	1001	1001
43721002	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	1002	1002
43731003	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	1000	1003
43741004	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	1001	1001
43751005	2018-03-29 15:13:01.44651	2018-03-29 15:13:01.44651	1001	1
4376\.
4377
4378
4379--
4380-- Name: usuario_perfil_acesso_id_seq; Type: SEQUENCE SET; Schema: public; Owner: vidafacil
4381--
4382
4383SELECT pg_catalog.setval('usuario_perfil_acesso_id_seq', 1, false);
4384
4385
4386SET search_path = auditing, pg_catalog;
4387
4388--
4389-- Name: agente_audited pk_agente_audited; Type: CONSTRAINT; Schema: auditing; Owner: vidafacil
4390--
4391
4392ALTER TABLE ONLY agente_audited
4393    ADD CONSTRAINT pk_agente_audited PRIMARY KEY (id, revision);
4394
4395
4396--
4397-- Name: apolice_seguro_audited pk_apolice_seguro_audited; Type: CONSTRAINT; Schema: auditing; Owner: vidafacil
4398--
4399
4400ALTER TABLE ONLY apolice_seguro_audited
4401    ADD CONSTRAINT pk_apolice_seguro_audited PRIMARY KEY (id, revision);
4402
4403
4404--
4405-- Name: beneficiario_audited pk_beneficiario_audited; Type: CONSTRAINT; Schema: auditing; Owner: vidafacil
4406--
4407
4408ALTER TABLE ONLY beneficiario_audited
4409    ADD CONSTRAINT pk_beneficiario_audited PRIMARY KEY (id, revision);
4410
4411
4412--
4413-- Name: cartao_credito_audited pk_cartao_credito_audited; Type: CONSTRAINT; Schema: auditing; Owner: vidafacil
4414--
4415
4416ALTER TABLE ONLY cartao_credito_audited
4417    ADD CONSTRAINT pk_cartao_credito_audited PRIMARY KEY (id, revision);
4418
4419
4420--
4421-- Name: cidade_audited pk_cidade_audited; Type: CONSTRAINT; Schema: auditing; Owner: vidafacil
4422--
4423
4424ALTER TABLE ONLY cidade_audited
4425    ADD CONSTRAINT pk_cidade_audited PRIMARY KEY (id, revision);
4426
4427
4428--
4429-- Name: cliente_audited pk_cliente_audited; Type: CONSTRAINT; Schema: auditing; Owner: vidafacil
4430--
4431
4432ALTER TABLE ONLY cliente_audited
4433    ADD CONSTRAINT pk_cliente_audited PRIMARY KEY (id, revision);
4434
4435
4436--
4437-- Name: cobertura_plano_seguro_audited pk_cobertura_plano_seguro_audited; Type: CONSTRAINT; Schema: auditing; Owner: vidafacil
4438--
4439
4440ALTER TABLE ONLY cobertura_plano_seguro_audited
4441    ADD CONSTRAINT pk_cobertura_plano_seguro_audited PRIMARY KEY (id, revision);
4442
4443
4444--
4445-- Name: configuracao_perfil_usuario_plano_seguro_audited pk_configuracao_perfil_usuario_plano_seguro_audited; Type: CONSTRAINT; Schema: auditing; Owner: vidafacil
4446--
4447
4448ALTER TABLE ONLY configuracao_perfil_usuario_plano_seguro_audited
4449    ADD CONSTRAINT pk_configuracao_perfil_usuario_plano_seguro_audited PRIMARY KEY (id, revision);
4450
4451
4452--
4453-- Name: configuracao_plataforma_audited pk_configuracao_plataforma_audited; Type: CONSTRAINT; Schema: auditing; Owner: vidafacil
4454--
4455
4456ALTER TABLE ONLY configuracao_plataforma_audited
4457    ADD CONSTRAINT pk_configuracao_plataforma_audited PRIMARY KEY (id, revision);
4458
4459
4460--
4461-- Name: conjuge_audited pk_conjuge_audited; Type: CONSTRAINT; Schema: auditing; Owner: vidafacil
4462--
4463
4464ALTER TABLE ONLY conjuge_audited
4465    ADD CONSTRAINT pk_conjuge_audited PRIMARY KEY (id, revision);
4466
4467
4468--
4469-- Name: endereco_audited pk_endereco_audited; Type: CONSTRAINT; Schema: auditing; Owner: vidafacil
4470--
4471
4472ALTER TABLE ONLY endereco_audited
4473    ADD CONSTRAINT pk_endereco_audited PRIMARY KEY (id, revision);
4474
4475
4476--
4477-- Name: estado_audited pk_estado_audited; Type: CONSTRAINT; Schema: auditing; Owner: vidafacil
4478--
4479
4480ALTER TABLE ONLY estado_audited
4481    ADD CONSTRAINT pk_estado_audited PRIMARY KEY (id, revision);
4482
4483
4484--
4485-- Name: executivo_audited pk_executivo_audited; Type: CONSTRAINT; Schema: auditing; Owner: vidafacil
4486--
4487
4488ALTER TABLE ONLY executivo_audited
4489    ADD CONSTRAINT pk_executivo_audited PRIMARY KEY (id, revision);
4490
4491
4492--
4493-- Name: formulario_perfil_usuario_cotacao_seguro_audited pk_formulario_perfil__audited; Type: CONSTRAINT; Schema: auditing; Owner: vidafacil
4494--
4495
4496ALTER TABLE ONLY formulario_perfil_usuario_cotacao_seguro_audited
4497    ADD CONSTRAINT pk_formulario_perfil__audited PRIMARY KEY (id, revision);
4498
4499
4500--
4501-- Name: grupo_empresa_audited pk_grupo_empresa_audited; Type: CONSTRAINT; Schema: auditing; Owner: vidafacil
4502--
4503
4504ALTER TABLE ONLY grupo_empresa_audited
4505    ADD CONSTRAINT pk_grupo_empresa_audited PRIMARY KEY (id, revision);
4506
4507
4508--
4509-- Name: historico_apolice_seguro_audited pk_historico_apolice_seguro_id_audited; Type: CONSTRAINT; Schema: auditing; Owner: vidafacil
4510--
4511
4512ALTER TABLE ONLY historico_apolice_seguro_audited
4513    ADD CONSTRAINT pk_historico_apolice_seguro_id_audited PRIMARY KEY (id, revision);
4514
4515
4516--
4517-- Name: historico_solicitacao_cotacao_seguro_audited pk_historico_solicitacao_cotacao_seguro_audited; Type: CONSTRAINT; Schema: auditing; Owner: vidafacil
4518--
4519
4520ALTER TABLE ONLY historico_solicitacao_cotacao_seguro_audited
4521    ADD CONSTRAINT pk_historico_solicitacao_cotacao_seguro_audited PRIMARY KEY (id, revision);
4522
4523
4524--
4525-- Name: pais_audited pk_pais_audited; Type: CONSTRAINT; Schema: auditing; Owner: vidafacil
4526--
4527
4528ALTER TABLE ONLY pais_audited
4529    ADD CONSTRAINT pk_pais_audited PRIMARY KEY (id, revision);
4530
4531
4532--
4533-- Name: perfil_acesso_audited pk_perfil_acesso_audited; Type: CONSTRAINT; Schema: auditing; Owner: vidafacil
4534--
4535
4536ALTER TABLE ONLY perfil_acesso_audited
4537    ADD CONSTRAINT pk_perfil_acesso_audited PRIMARY KEY (id, revision);
4538
4539
4540--
4541-- Name: perfil_acesso_permissao_audited pk_perfil_acesso_permissao_audited; Type: CONSTRAINT; Schema: auditing; Owner: vidafacil
4542--
4543
4544ALTER TABLE ONLY perfil_acesso_permissao_audited
4545    ADD CONSTRAINT pk_perfil_acesso_permissao_audited PRIMARY KEY (id, revision);
4546
4547
4548--
4549-- Name: plano_seguro_audited pk_plano_seguro_audited; Type: CONSTRAINT; Schema: auditing; Owner: vidafacil
4550--
4551
4552ALTER TABLE ONLY plano_seguro_audited
4553    ADD CONSTRAINT pk_plano_seguro_audited PRIMARY KEY (id, revision);
4554
4555
4556--
4557-- Name: produto_seguro_audited pk_produto_seguro_audited; Type: CONSTRAINT; Schema: auditing; Owner: vidafacil
4558--
4559
4560ALTER TABLE ONLY produto_seguro_audited
4561    ADD CONSTRAINT pk_produto_seguro_audited PRIMARY KEY (id, revision);
4562
4563
4564--
4565-- Name: profissao_audited pk_profissao_audited; Type: CONSTRAINT; Schema: auditing; Owner: vidafacil
4566--
4567
4568ALTER TABLE ONLY profissao_audited
4569    ADD CONSTRAINT pk_profissao_audited PRIMARY KEY (id, revision);
4570
4571
4572--
4573-- Name: profissao_restricao_plano_seguro_audited pk_profissao_restricao_plano_seguro_audited; Type: CONSTRAINT; Schema: auditing; Owner: vidafacil
4574--
4575
4576ALTER TABLE ONLY profissao_restricao_plano_seguro_audited
4577    ADD CONSTRAINT pk_profissao_restricao_plano_seguro_audited PRIMARY KEY (id, revision);
4578
4579
4580--
4581-- Name: solicitacao_cotacao_seguro_audited pk_solicitacao_cotacao_seguro_audited; Type: CONSTRAINT; Schema: auditing; Owner: vidafacil
4582--
4583
4584ALTER TABLE ONLY solicitacao_cotacao_seguro_audited
4585    ADD CONSTRAINT pk_solicitacao_cotacao_seguro_audited PRIMARY KEY (id, revision);
4586
4587
4588--
4589-- Name: tutor_audited pk_tutor_audited; Type: CONSTRAINT; Schema: auditing; Owner: vidafacil
4590--
4591
4592ALTER TABLE ONLY tutor_audited
4593    ADD CONSTRAINT pk_tutor_audited PRIMARY KEY (id, revision);
4594
4595
4596--
4597-- Name: user_audited pk_user_audited; Type: CONSTRAINT; Schema: auditing; Owner: vidafacil
4598--
4599
4600ALTER TABLE ONLY user_audited
4601    ADD CONSTRAINT pk_user_audited PRIMARY KEY (id, revision);
4602
4603
4604--
4605-- Name: usuario_perfil_acesso_audited pk_usuario_perfil_acesso_audited; Type: CONSTRAINT; Schema: auditing; Owner: vidafacil
4606--
4607
4608ALTER TABLE ONLY usuario_perfil_acesso_audited
4609    ADD CONSTRAINT pk_usuario_perfil_acesso_audited PRIMARY KEY (id, revision);
4610
4611
4612--
4613-- Name: revision revision_pkey; Type: CONSTRAINT; Schema: auditing; Owner: vidafacil
4614--
4615
4616ALTER TABLE ONLY revision
4617    ADD CONSTRAINT revision_pkey PRIMARY KEY (id);
4618
4619
4620SET search_path = public, pg_catalog;
4621
4622--
4623-- Name: cartao_credito cartao_credito_pkey; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4624--
4625
4626ALTER TABLE ONLY cartao_credito
4627    ADD CONSTRAINT cartao_credito_pkey PRIMARY KEY (id);
4628
4629
4630--
4631-- Name: agente pk_agente; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4632--
4633
4634ALTER TABLE ONLY agente
4635    ADD CONSTRAINT pk_agente PRIMARY KEY (id);
4636
4637
4638--
4639-- Name: apolice_seguro pk_apolice_seguro; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4640--
4641
4642ALTER TABLE ONLY apolice_seguro
4643    ADD CONSTRAINT pk_apolice_seguro PRIMARY KEY (id);
4644
4645
4646--
4647-- Name: beneficiario pk_beneficiario; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4648--
4649
4650ALTER TABLE ONLY beneficiario
4651    ADD CONSTRAINT pk_beneficiario PRIMARY KEY (id);
4652
4653
4654--
4655-- Name: cidade pk_cidade; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4656--
4657
4658ALTER TABLE ONLY cidade
4659    ADD CONSTRAINT pk_cidade PRIMARY KEY (id);
4660
4661
4662--
4663-- Name: cliente pk_cliente; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4664--
4665
4666ALTER TABLE ONLY cliente
4667    ADD CONSTRAINT pk_cliente PRIMARY KEY (id);
4668
4669
4670--
4671-- Name: solicitacao_cotacao_seguro pk_cliente_cotacao_seguro; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4672--
4673
4674ALTER TABLE ONLY solicitacao_cotacao_seguro
4675    ADD CONSTRAINT pk_cliente_cotacao_seguro PRIMARY KEY (id);
4676
4677
4678--
4679-- Name: cobertura_plano_seguro pk_cobertura_plano_seguro; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4680--
4681
4682ALTER TABLE ONLY cobertura_plano_seguro
4683    ADD CONSTRAINT pk_cobertura_plano_seguro PRIMARY KEY (id);
4684
4685
4686--
4687-- Name: configuracao_perfil_usuario_plano_seguro pk_configuracao_perfil_usuario_plano_seguro; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4688--
4689
4690ALTER TABLE ONLY configuracao_perfil_usuario_plano_seguro
4691    ADD CONSTRAINT pk_configuracao_perfil_usuario_plano_seguro PRIMARY KEY (id);
4692
4693
4694--
4695-- Name: configuracao_plataforma pk_configuracao_plataforma; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4696--
4697
4698ALTER TABLE ONLY configuracao_plataforma
4699    ADD CONSTRAINT pk_configuracao_plataforma PRIMARY KEY (id);
4700
4701
4702--
4703-- Name: conjuge pk_conjuge; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4704--
4705
4706ALTER TABLE ONLY conjuge
4707    ADD CONSTRAINT pk_conjuge PRIMARY KEY (id);
4708
4709
4710--
4711-- Name: endereco pk_endereco; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4712--
4713
4714ALTER TABLE ONLY endereco
4715    ADD CONSTRAINT pk_endereco PRIMARY KEY (id);
4716
4717
4718--
4719-- Name: estado pk_estado; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4720--
4721
4722ALTER TABLE ONLY estado
4723    ADD CONSTRAINT pk_estado PRIMARY KEY (id);
4724
4725
4726--
4727-- Name: executivo pk_executivo; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4728--
4729
4730ALTER TABLE ONLY executivo
4731    ADD CONSTRAINT pk_executivo PRIMARY KEY (id);
4732
4733
4734--
4735-- Name: formulario_perfil_usuario_cotacao_seguro pk_formulario_perfil_usuario_cotacao_seguro; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4736--
4737
4738ALTER TABLE ONLY formulario_perfil_usuario_cotacao_seguro
4739    ADD CONSTRAINT pk_formulario_perfil_usuario_cotacao_seguro PRIMARY KEY (id);
4740
4741
4742--
4743-- Name: grupo_empresa pk_grupo_empresa; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4744--
4745
4746ALTER TABLE ONLY grupo_empresa
4747    ADD CONSTRAINT pk_grupo_empresa PRIMARY KEY (id);
4748
4749
4750--
4751-- Name: historico_apolice_seguro pk_historico_apolice_seguro_id; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4752--
4753
4754ALTER TABLE ONLY historico_apolice_seguro
4755    ADD CONSTRAINT pk_historico_apolice_seguro_id PRIMARY KEY (id);
4756
4757
4758--
4759-- Name: historico_solicitacao_cotacao_seguro pk_historico_solicitacao_cotacao_seguro; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4760--
4761
4762ALTER TABLE ONLY historico_solicitacao_cotacao_seguro
4763    ADD CONSTRAINT pk_historico_solicitacao_cotacao_seguro PRIMARY KEY (id);
4764
4765
4766--
4767-- Name: pais pk_pais; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4768--
4769
4770ALTER TABLE ONLY pais
4771    ADD CONSTRAINT pk_pais PRIMARY KEY (id);
4772
4773
4774--
4775-- Name: perfil_acesso pk_perfil_acesso; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4776--
4777
4778ALTER TABLE ONLY perfil_acesso
4779    ADD CONSTRAINT pk_perfil_acesso PRIMARY KEY (id);
4780
4781
4782--
4783-- Name: perfil_acesso_permissao pk_perfil_acesso_permissao; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4784--
4785
4786ALTER TABLE ONLY perfil_acesso_permissao
4787    ADD CONSTRAINT pk_perfil_acesso_permissao PRIMARY KEY (id);
4788
4789
4790--
4791-- Name: plano_seguro pk_plano_seguro; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4792--
4793
4794ALTER TABLE ONLY plano_seguro
4795    ADD CONSTRAINT pk_plano_seguro PRIMARY KEY (id);
4796
4797
4798--
4799-- Name: produto_seguro pk_produto_seguro; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4800--
4801
4802ALTER TABLE ONLY produto_seguro
4803    ADD CONSTRAINT pk_produto_seguro PRIMARY KEY (id);
4804
4805
4806--
4807-- Name: profissao pk_profissao; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4808--
4809
4810ALTER TABLE ONLY profissao
4811    ADD CONSTRAINT pk_profissao PRIMARY KEY (id);
4812
4813
4814--
4815-- Name: profissao_restricao_plano_seguro pk_profissao_restricao_plano_seguro; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4816--
4817
4818ALTER TABLE ONLY profissao_restricao_plano_seguro
4819    ADD CONSTRAINT pk_profissao_restricao_plano_seguro PRIMARY KEY (id);
4820
4821
4822--
4823-- Name: tutor pk_tutor; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4824--
4825
4826ALTER TABLE ONLY tutor
4827    ADD CONSTRAINT pk_tutor PRIMARY KEY (id);
4828
4829
4830--
4831-- Name: usuario_perfil_acesso pk_usuario_perfil_acesso; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4832--
4833
4834ALTER TABLE ONLY usuario_perfil_acesso
4835    ADD CONSTRAINT pk_usuario_perfil_acesso PRIMARY KEY (id);
4836
4837
4838--
4839-- Name: schema_version schema_version_pk; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4840--
4841
4842ALTER TABLE ONLY schema_version
4843    ADD CONSTRAINT schema_version_pk PRIMARY KEY (installed_rank);
4844
4845
4846--
4847-- Name: cidade uk_cidade_nome; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4848--
4849
4850ALTER TABLE ONLY cidade
4851    ADD CONSTRAINT uk_cidade_nome UNIQUE (nome, estado_id);
4852
4853
4854--
4855-- Name: cobertura_plano_seguro uk_cobertura_plano_seguro_descricao; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4856--
4857
4858ALTER TABLE ONLY cobertura_plano_seguro
4859    ADD CONSTRAINT uk_cobertura_plano_seguro_descricao UNIQUE (descricao);
4860
4861
4862--
4863-- Name: estado uk_estado_nome; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4864--
4865
4866ALTER TABLE ONLY estado
4867    ADD CONSTRAINT uk_estado_nome UNIQUE (nome, pais_id);
4868
4869
4870--
4871-- Name: pais uk_pais_nome; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4872--
4873
4874ALTER TABLE ONLY pais
4875    ADD CONSTRAINT uk_pais_nome UNIQUE (nome);
4876
4877
4878--
4879-- Name: plano_seguro uk_plano_seguro_nome; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4880--
4881
4882ALTER TABLE ONLY plano_seguro
4883    ADD CONSTRAINT uk_plano_seguro_nome UNIQUE (nome);
4884
4885
4886--
4887-- Name: produto_seguro uk_produto_seguro_nome; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4888--
4889
4890ALTER TABLE ONLY produto_seguro
4891    ADD CONSTRAINT uk_produto_seguro_nome UNIQUE (nome);
4892
4893
4894--
4895-- Name: profissao uk_profissao_descricao; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4896--
4897
4898ALTER TABLE ONLY profissao
4899    ADD CONSTRAINT uk_profissao_descricao UNIQUE (descricao);
4900
4901
4902--
4903-- Name: solicitacao_cotacao_seguro uk_solicitacao_cotacao_seguro_email; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4904--
4905
4906ALTER TABLE ONLY solicitacao_cotacao_seguro
4907    ADD CONSTRAINT uk_solicitacao_cotacao_seguro_email UNIQUE (email);
4908
4909
4910--
4911-- Name: user user_pkey; Type: CONSTRAINT; Schema: public; Owner: vidafacil
4912--
4913
4914ALTER TABLE ONLY "user"
4915    ADD CONSTRAINT user_pkey PRIMARY KEY (id);
4916
4917
4918--
4919-- Name: idx_user_email; Type: INDEX; Schema: public; Owner: vidafacil
4920--
4921
4922CREATE UNIQUE INDEX idx_user_email ON "user" USING btree (lower((email)::text));
4923
4924
4925--
4926-- Name: schema_version_s_idx; Type: INDEX; Schema: public; Owner: vidafacil
4927--
4928
4929CREATE INDEX schema_version_s_idx ON schema_version USING btree (success);
4930
4931
4932SET search_path = auditing, pg_catalog;
4933
4934--
4935-- Name: agente_audited fk_agente_audited_revision; Type: FK CONSTRAINT; Schema: auditing; Owner: vidafacil
4936--
4937
4938ALTER TABLE ONLY agente_audited
4939    ADD CONSTRAINT fk_agente_audited_revision FOREIGN KEY (revision) REFERENCES revision(id);
4940
4941
4942--
4943-- Name: apolice_seguro_audited fk_apolice_seguro_audited_revision; Type: FK CONSTRAINT; Schema: auditing; Owner: vidafacil
4944--
4945
4946ALTER TABLE ONLY apolice_seguro_audited
4947    ADD CONSTRAINT fk_apolice_seguro_audited_revision FOREIGN KEY (revision) REFERENCES revision(id);
4948
4949
4950--
4951-- Name: apolice_seguro_audited fk_apolice_seguro_solicitacao_cotacao_seguro; Type: FK CONSTRAINT; Schema: auditing; Owner: vidafacil
4952--
4953
4954ALTER TABLE ONLY apolice_seguro_audited
4955    ADD CONSTRAINT fk_apolice_seguro_solicitacao_cotacao_seguro FOREIGN KEY (solicitacao_cotacao_seguro_id) REFERENCES public.solicitacao_cotacao_seguro(id);
4956
4957
4958--
4959-- Name: beneficiario_audited fk_beneficiario_apolice_seguro_id; Type: FK CONSTRAINT; Schema: auditing; Owner: vidafacil
4960--
4961
4962ALTER TABLE ONLY beneficiario_audited
4963    ADD CONSTRAINT fk_beneficiario_apolice_seguro_id FOREIGN KEY (apolice_seguro_id) REFERENCES public.apolice_seguro(id);
4964
4965
4966--
4967-- Name: beneficiario_audited fk_beneficiario_audited_revision; Type: FK CONSTRAINT; Schema: auditing; Owner: vidafacil
4968--
4969
4970ALTER TABLE ONLY beneficiario_audited
4971    ADD CONSTRAINT fk_beneficiario_audited_revision FOREIGN KEY (revision) REFERENCES revision(id);
4972
4973
4974--
4975-- Name: cartao_credito_audited fk_cartao_credito_audited_revision; Type: FK CONSTRAINT; Schema: auditing; Owner: vidafacil
4976--
4977
4978ALTER TABLE ONLY cartao_credito_audited
4979    ADD CONSTRAINT fk_cartao_credito_audited_revision FOREIGN KEY (revision) REFERENCES revision(id);
4980
4981
4982--
4983-- Name: cidade_audited fk_cidade_audited_revision; Type: FK CONSTRAINT; Schema: auditing; Owner: vidafacil
4984--
4985
4986ALTER TABLE ONLY cidade_audited
4987    ADD CONSTRAINT fk_cidade_audited_revision FOREIGN KEY (revision) REFERENCES revision(id);
4988
4989
4990--
4991-- Name: cliente_audited fk_cliente_audited_revision; Type: FK CONSTRAINT; Schema: auditing; Owner: vidafacil
4992--
4993
4994ALTER TABLE ONLY cliente_audited
4995    ADD CONSTRAINT fk_cliente_audited_revision FOREIGN KEY (revision) REFERENCES revision(id);
4996
4997
4998--
4999-- Name: cliente_audited fk_cliente_endereco_trabalho; Type: FK CONSTRAINT; Schema: auditing; Owner: vidafacil
5000--
5001
5002ALTER TABLE ONLY cliente_audited
5003    ADD CONSTRAINT fk_cliente_endereco_trabalho FOREIGN KEY (endereco_trabalho_id) REFERENCES public.endereco(id);
5004
5005
5006--
5007-- Name: cobertura_plano_seguro_audited fk_cobertura_plano_seguro_audited_revision; Type: FK CONSTRAINT; Schema: auditing; Owner: vidafacil
5008--
5009
5010ALTER TABLE ONLY cobertura_plano_seguro_audited
5011    ADD CONSTRAINT fk_cobertura_plano_seguro_audited_revision FOREIGN KEY (revision) REFERENCES revision(id);
5012
5013
5014--
5015-- Name: configuracao_perfil_usuario_plano_seguro_audited fk_configuracao_perfil_usuario_plano_seguro_audited_revision; Type: FK CONSTRAINT; Schema: auditing; Owner: vidafacil
5016--
5017
5018ALTER TABLE ONLY configuracao_perfil_usuario_plano_seguro_audited
5019    ADD CONSTRAINT fk_configuracao_perfil_usuario_plano_seguro_audited_revision FOREIGN KEY (revision) REFERENCES revision(id);
5020
5021
5022--
5023-- Name: configuracao_plataforma_audited fk_configuracao_plataforma_audited_revision; Type: FK CONSTRAINT; Schema: auditing; Owner: vidafacil
5024--
5025
5026ALTER TABLE ONLY configuracao_plataforma_audited
5027    ADD CONSTRAINT fk_configuracao_plataforma_audited_revision FOREIGN KEY (revision) REFERENCES revision(id);
5028
5029
5030--
5031-- Name: conjuge_audited fk_conjuge_audited_revision; Type: FK CONSTRAINT; Schema: auditing; Owner: vidafacil
5032--
5033
5034ALTER TABLE ONLY conjuge_audited
5035    ADD CONSTRAINT fk_conjuge_audited_revision FOREIGN KEY (revision) REFERENCES revision(id);
5036
5037
5038--
5039-- Name: endereco_audited fk_endereco_audited_revision; Type: FK CONSTRAINT; Schema: auditing; Owner: vidafacil
5040--
5041
5042ALTER TABLE ONLY endereco_audited
5043    ADD CONSTRAINT fk_endereco_audited_revision FOREIGN KEY (revision) REFERENCES revision(id);
5044
5045
5046--
5047-- Name: estado_audited fk_estado_audited_revision; Type: FK CONSTRAINT; Schema: auditing; Owner: vidafacil
5048--
5049
5050ALTER TABLE ONLY estado_audited
5051    ADD CONSTRAINT fk_estado_audited_revision FOREIGN KEY (revision) REFERENCES revision(id);
5052
5053
5054--
5055-- Name: executivo_audited fk_executivo_audited_revision; Type: FK CONSTRAINT; Schema: auditing; Owner: vidafacil
5056--
5057
5058ALTER TABLE ONLY executivo_audited
5059    ADD CONSTRAINT fk_executivo_audited_revision FOREIGN KEY (revision) REFERENCES revision(id);
5060
5061
5062--
5063-- Name: formulario_perfil_usuario_cotacao_seguro_audited fk_formulario_perfil_audited_revision; Type: FK CONSTRAINT; Schema: auditing; Owner: vidafacil
5064--
5065
5066ALTER TABLE ONLY formulario_perfil_usuario_cotacao_seguro_audited
5067    ADD CONSTRAINT fk_formulario_perfil_audited_revision FOREIGN KEY (revision) REFERENCES revision(id);
5068
5069
5070--
5071-- Name: grupo_empresa_audited fk_grupo_empresa_audited_revision; Type: FK CONSTRAINT; Schema: auditing; Owner: vidafacil
5072--
5073
5074ALTER TABLE ONLY grupo_empresa_audited
5075    ADD CONSTRAINT fk_grupo_empresa_audited_revision FOREIGN KEY (revision) REFERENCES revision(id);
5076
5077
5078--
5079-- Name: historico_apolice_seguro_audited fk_historico_apolice_seguro_id_audited_revision; Type: FK CONSTRAINT; Schema: auditing; Owner: vidafacil
5080--
5081
5082ALTER TABLE ONLY historico_apolice_seguro_audited
5083    ADD CONSTRAINT fk_historico_apolice_seguro_id_audited_revision FOREIGN KEY (revision) REFERENCES revision(id);
5084
5085
5086--
5087-- Name: historico_solicitacao_cotacao_seguro_audited fk_historico_solicitacao_cotacao_seguro_audited_revision; Type: FK CONSTRAINT; Schema: auditing; Owner: vidafacil
5088--
5089
5090ALTER TABLE ONLY historico_solicitacao_cotacao_seguro_audited
5091    ADD CONSTRAINT fk_historico_solicitacao_cotacao_seguro_audited_revision FOREIGN KEY (revision) REFERENCES revision(id);
5092
5093
5094--
5095-- Name: pais_audited fk_pais_audited_revision; Type: FK CONSTRAINT; Schema: auditing; Owner: vidafacil
5096--
5097
5098ALTER TABLE ONLY pais_audited
5099    ADD CONSTRAINT fk_pais_audited_revision FOREIGN KEY (revision) REFERENCES revision(id);
5100
5101
5102--
5103-- Name: perfil_acesso_audited fk_perfil_acesso_audited_revision; Type: FK CONSTRAINT; Schema: auditing; Owner: vidafacil
5104--
5105
5106ALTER TABLE ONLY perfil_acesso_audited
5107    ADD CONSTRAINT fk_perfil_acesso_audited_revision FOREIGN KEY (revision) REFERENCES revision(id);
5108
5109
5110--
5111-- Name: perfil_acesso_permissao_audited fk_perfil_acesso_permissao_audited_revision; Type: FK CONSTRAINT; Schema: auditing; Owner: vidafacil
5112--
5113
5114ALTER TABLE ONLY perfil_acesso_permissao_audited
5115    ADD CONSTRAINT fk_perfil_acesso_permissao_audited_revision FOREIGN KEY (revision) REFERENCES revision(id);
5116
5117
5118--
5119-- Name: plano_seguro_audited fk_plano_seguro_audited_revision; Type: FK CONSTRAINT; Schema: auditing; Owner: vidafacil
5120--
5121
5122ALTER TABLE ONLY plano_seguro_audited
5123    ADD CONSTRAINT fk_plano_seguro_audited_revision FOREIGN KEY (revision) REFERENCES revision(id);
5124
5125
5126--
5127-- Name: produto_seguro_audited fk_produto_seguro_audited_revision; Type: FK CONSTRAINT; Schema: auditing; Owner: vidafacil
5128--
5129
5130ALTER TABLE ONLY produto_seguro_audited
5131    ADD CONSTRAINT fk_produto_seguro_audited_revision FOREIGN KEY (revision) REFERENCES revision(id);
5132
5133
5134--
5135-- Name: profissao_audited fk_profissao_audited_revision; Type: FK CONSTRAINT; Schema: auditing; Owner: vidafacil
5136--
5137
5138ALTER TABLE ONLY profissao_audited
5139    ADD CONSTRAINT fk_profissao_audited_revision FOREIGN KEY (revision) REFERENCES revision(id);
5140
5141
5142--
5143-- Name: profissao_restricao_plano_seguro_audited fk_profissao_restricao_plano_seguro_audited_revision; Type: FK CONSTRAINT; Schema: auditing; Owner: vidafacil
5144--
5145
5146ALTER TABLE ONLY profissao_restricao_plano_seguro_audited
5147    ADD CONSTRAINT fk_profissao_restricao_plano_seguro_audited_revision FOREIGN KEY (revision) REFERENCES revision(id);
5148
5149
5150--
5151-- Name: solicitacao_cotacao_seguro_audited fk_solicitacao_cotacao_seguro_audited_revision; Type: FK CONSTRAINT; Schema: auditing; Owner: vidafacil
5152--
5153
5154ALTER TABLE ONLY solicitacao_cotacao_seguro_audited
5155    ADD CONSTRAINT fk_solicitacao_cotacao_seguro_audited_revision FOREIGN KEY (revision) REFERENCES revision(id);
5156
5157
5158--
5159-- Name: tutor_audited fk_tutor_audited_revision; Type: FK CONSTRAINT; Schema: auditing; Owner: vidafacil
5160--
5161
5162ALTER TABLE ONLY tutor_audited
5163    ADD CONSTRAINT fk_tutor_audited_revision FOREIGN KEY (revision) REFERENCES revision(id);
5164
5165
5166--
5167-- Name: user_audited fk_user_audited_revision; Type: FK CONSTRAINT; Schema: auditing; Owner: vidafacil
5168--
5169
5170ALTER TABLE ONLY user_audited
5171    ADD CONSTRAINT fk_user_audited_revision FOREIGN KEY (revision) REFERENCES revision(id);
5172
5173
5174--
5175-- Name: usuario_perfil_acesso_audited fk_usuario_perfil_acesso_audited_revision; Type: FK CONSTRAINT; Schema: auditing; Owner: vidafacil
5176--
5177
5178ALTER TABLE ONLY usuario_perfil_acesso_audited
5179    ADD CONSTRAINT fk_usuario_perfil_acesso_audited_revision FOREIGN KEY (revision) REFERENCES revision(id);
5180
5181
5182SET search_path = public, pg_catalog;
5183
5184--
5185-- Name: agente fk_agente_user; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5186--
5187
5188ALTER TABLE ONLY agente
5189    ADD CONSTRAINT fk_agente_user FOREIGN KEY (id) REFERENCES "user"(id);
5190
5191
5192--
5193-- Name: agente fk_agente_usuario; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5194--
5195
5196ALTER TABLE ONLY agente
5197    ADD CONSTRAINT fk_agente_usuario FOREIGN KEY (user_id) REFERENCES "user"(id);
5198
5199
5200--
5201-- Name: apolice_seguro fk_apolice_seguro_agente; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5202--
5203
5204ALTER TABLE ONLY apolice_seguro
5205    ADD CONSTRAINT fk_apolice_seguro_agente FOREIGN KEY (agente_id) REFERENCES "user"(id);
5206
5207
5208--
5209-- Name: apolice_seguro fk_apolice_seguro_cartao_credito; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5210--
5211
5212ALTER TABLE ONLY apolice_seguro
5213    ADD CONSTRAINT fk_apolice_seguro_cartao_credito FOREIGN KEY (cartao_credito_id) REFERENCES cartao_credito(id);
5214
5215
5216--
5217-- Name: apolice_seguro fk_apolice_seguro_cliente; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5218--
5219
5220ALTER TABLE ONLY apolice_seguro
5221    ADD CONSTRAINT fk_apolice_seguro_cliente FOREIGN KEY (cliente_id) REFERENCES cliente(id);
5222
5223
5224--
5225-- Name: apolice_seguro fk_apolice_seguro_executivo; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5226--
5227
5228ALTER TABLE ONLY apolice_seguro
5229    ADD CONSTRAINT fk_apolice_seguro_executivo FOREIGN KEY (executivo_id) REFERENCES "user"(id);
5230
5231
5232--
5233-- Name: apolice_seguro fk_apolice_seguro_grupo_empresa; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5234--
5235
5236ALTER TABLE ONLY apolice_seguro
5237    ADD CONSTRAINT fk_apolice_seguro_grupo_empresa FOREIGN KEY (grupo_empresa_id) REFERENCES grupo_empresa(id);
5238
5239
5240--
5241-- Name: apolice_seguro fk_apolice_seguro_plano_seguro; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5242--
5243
5244ALTER TABLE ONLY apolice_seguro
5245    ADD CONSTRAINT fk_apolice_seguro_plano_seguro FOREIGN KEY (plano_seguro_id) REFERENCES plano_seguro(id);
5246
5247
5248--
5249-- Name: apolice_seguro fk_apolice_seguro_solicitacao_cotacao_seguro; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5250--
5251
5252ALTER TABLE ONLY apolice_seguro
5253    ADD CONSTRAINT fk_apolice_seguro_solicitacao_cotacao_seguro FOREIGN KEY (solicitacao_cotacao_seguro_id) REFERENCES solicitacao_cotacao_seguro(id);
5254
5255
5256--
5257-- Name: beneficiario fk_beneficiario_apolice_seguro_id; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5258--
5259
5260ALTER TABLE ONLY beneficiario
5261    ADD CONSTRAINT fk_beneficiario_apolice_seguro_id FOREIGN KEY (apolice_seguro_id) REFERENCES apolice_seguro(id);
5262
5263
5264--
5265-- Name: beneficiario fk_beneficiario_solicitacao_cotacao_seguro; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5266--
5267
5268ALTER TABLE ONLY beneficiario
5269    ADD CONSTRAINT fk_beneficiario_solicitacao_cotacao_seguro FOREIGN KEY (solicitacao_cotacao_seguro_id) REFERENCES solicitacao_cotacao_seguro(id);
5270
5271
5272--
5273-- Name: beneficiario fk_beneficiario_tutor; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5274--
5275
5276ALTER TABLE ONLY beneficiario
5277    ADD CONSTRAINT fk_beneficiario_tutor FOREIGN KEY (tutor_id) REFERENCES tutor(id);
5278
5279
5280--
5281-- Name: cidade fk_cidade_estado; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5282--
5283
5284ALTER TABLE ONLY cidade
5285    ADD CONSTRAINT fk_cidade_estado FOREIGN KEY (estado_id) REFERENCES estado(id);
5286
5287
5288--
5289-- Name: cliente fk_cliente_conjuge; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5290--
5291
5292ALTER TABLE ONLY cliente
5293    ADD CONSTRAINT fk_cliente_conjuge FOREIGN KEY (conjuge_id) REFERENCES conjuge(id);
5294
5295
5296--
5297-- Name: solicitacao_cotacao_seguro fk_cliente_cotacao_seguro_cartao_credito; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5298--
5299
5300ALTER TABLE ONLY solicitacao_cotacao_seguro
5301    ADD CONSTRAINT fk_cliente_cotacao_seguro_cartao_credito FOREIGN KEY (cartao_credito_id) REFERENCES cartao_credito(id);
5302
5303
5304--
5305-- Name: solicitacao_cotacao_seguro fk_cliente_cotacao_seguro_endereco_residencial; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5306--
5307
5308ALTER TABLE ONLY solicitacao_cotacao_seguro
5309    ADD CONSTRAINT fk_cliente_cotacao_seguro_endereco_residencial FOREIGN KEY (endereco_residencial_id) REFERENCES endereco(id);
5310
5311
5312--
5313-- Name: solicitacao_cotacao_seguro fk_cliente_cotacao_seguro_grupo_empresa; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5314--
5315
5316ALTER TABLE ONLY solicitacao_cotacao_seguro
5317    ADD CONSTRAINT fk_cliente_cotacao_seguro_grupo_empresa FOREIGN KEY (grupo_empresa_id) REFERENCES grupo_empresa(id);
5318
5319
5320--
5321-- Name: solicitacao_cotacao_seguro fk_cliente_cotacao_seguro_profissao; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5322--
5323
5324ALTER TABLE ONLY solicitacao_cotacao_seguro
5325    ADD CONSTRAINT fk_cliente_cotacao_seguro_profissao FOREIGN KEY (profissao_id) REFERENCES profissao(id);
5326
5327
5328--
5329-- Name: cliente fk_cliente_endereco; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5330--
5331
5332ALTER TABLE ONLY cliente
5333    ADD CONSTRAINT fk_cliente_endereco FOREIGN KEY (endereco_id) REFERENCES endereco(id);
5334
5335
5336--
5337-- Name: cliente fk_cliente_endereco_trabalho; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5338--
5339
5340ALTER TABLE ONLY cliente
5341    ADD CONSTRAINT fk_cliente_endereco_trabalho FOREIGN KEY (endereco_trabalho_id) REFERENCES endereco(id);
5342
5343
5344--
5345-- Name: cliente fk_cliente_profissao; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5346--
5347
5348ALTER TABLE ONLY cliente
5349    ADD CONSTRAINT fk_cliente_profissao FOREIGN KEY (profissao_id) REFERENCES profissao(id);
5350
5351
5352--
5353-- Name: cliente fk_cliente_usuario; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5354--
5355
5356ALTER TABLE ONLY cliente
5357    ADD CONSTRAINT fk_cliente_usuario FOREIGN KEY (user_id) REFERENCES "user"(id);
5358
5359
5360--
5361-- Name: cobertura_plano_seguro fk_cobertura_plano_seguro_plano_seguro; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5362--
5363
5364ALTER TABLE ONLY cobertura_plano_seguro
5365    ADD CONSTRAINT fk_cobertura_plano_seguro_plano_seguro FOREIGN KEY (plano_seguro_id) REFERENCES plano_seguro(id);
5366
5367
5368--
5369-- Name: configuracao_perfil_usuario_plano_seguro fk_configuracao_perfil_usuario_plano_seguro_plano_seguro; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5370--
5371
5372ALTER TABLE ONLY configuracao_perfil_usuario_plano_seguro
5373    ADD CONSTRAINT fk_configuracao_perfil_usuario_plano_seguro_plano_seguro FOREIGN KEY (plano_seguro_id) REFERENCES plano_seguro(id);
5374
5375
5376--
5377-- Name: conjuge fk_conjuge_profissao; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5378--
5379
5380ALTER TABLE ONLY conjuge
5381    ADD CONSTRAINT fk_conjuge_profissao FOREIGN KEY (profissao_id) REFERENCES profissao(id);
5382
5383
5384--
5385-- Name: endereco fk_endereco_cidade; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5386--
5387
5388ALTER TABLE ONLY endereco
5389    ADD CONSTRAINT fk_endereco_cidade FOREIGN KEY (cidade_id) REFERENCES cidade(id);
5390
5391
5392--
5393-- Name: estado fk_estado_pais; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5394--
5395
5396ALTER TABLE ONLY estado
5397    ADD CONSTRAINT fk_estado_pais FOREIGN KEY (pais_id) REFERENCES pais(id);
5398
5399
5400--
5401-- Name: executivo fk_executivo_agente; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5402--
5403
5404ALTER TABLE ONLY executivo
5405    ADD CONSTRAINT fk_executivo_agente FOREIGN KEY (agente_id) REFERENCES agente(id);
5406
5407
5408--
5409-- Name: executivo fk_executivo_user; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5410--
5411
5412ALTER TABLE ONLY executivo
5413    ADD CONSTRAINT fk_executivo_user FOREIGN KEY (id) REFERENCES "user"(id);
5414
5415
5416--
5417-- Name: executivo fk_executivo_usuario; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5418--
5419
5420ALTER TABLE ONLY executivo
5421    ADD CONSTRAINT fk_executivo_usuario FOREIGN KEY (user_id) REFERENCES "user"(id);
5422
5423
5424--
5425-- Name: formulario_perfil_usuario_cotacao_seguro fk_f_p_u_cotacao_seguro_configuracao_u_p_s; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5426--
5427
5428ALTER TABLE ONLY formulario_perfil_usuario_cotacao_seguro
5429    ADD CONSTRAINT fk_f_p_u_cotacao_seguro_configuracao_u_p_s FOREIGN KEY (configuracao_perfil_usuario_plano_seguro_id) REFERENCES configuracao_perfil_usuario_plano_seguro(id);
5430
5431
5432--
5433-- Name: grupo_empresa fk_grupo_empresa_usuario; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5434--
5435
5436ALTER TABLE ONLY grupo_empresa
5437    ADD CONSTRAINT fk_grupo_empresa_usuario FOREIGN KEY (responsavel_rh_id) REFERENCES "user"(id);
5438
5439
5440--
5441-- Name: historico_apolice_seguro fk_historico_apolice_seguro_id; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5442--
5443
5444ALTER TABLE ONLY historico_apolice_seguro
5445    ADD CONSTRAINT fk_historico_apolice_seguro_id FOREIGN KEY (apolice_seguro_id) REFERENCES apolice_seguro(id);
5446
5447
5448--
5449-- Name: historico_apolice_seguro fk_historico_apolice_seguro_id_usuario; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5450--
5451
5452ALTER TABLE ONLY historico_apolice_seguro
5453    ADD CONSTRAINT fk_historico_apolice_seguro_id_usuario FOREIGN KEY (user_id) REFERENCES "user"(id);
5454
5455
5456--
5457-- Name: historico_solicitacao_cotacao_seguro fk_historico_solicitacao_cotacao_seguro_solicitacao_cotacao_seg; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5458--
5459
5460ALTER TABLE ONLY historico_solicitacao_cotacao_seguro
5461    ADD CONSTRAINT fk_historico_solicitacao_cotacao_seguro_solicitacao_cotacao_seg FOREIGN KEY (solicitacao_cotacao_seguro_id) REFERENCES solicitacao_cotacao_seguro(id);
5462
5463
5464--
5465-- Name: historico_solicitacao_cotacao_seguro fk_historico_solicitacao_cotacao_seguro_usuario; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5466--
5467
5468ALTER TABLE ONLY historico_solicitacao_cotacao_seguro
5469    ADD CONSTRAINT fk_historico_solicitacao_cotacao_seguro_usuario FOREIGN KEY (user_id) REFERENCES "user"(id);
5470
5471
5472--
5473-- Name: perfil_acesso_permissao fk_perfil_acesso_permissao_perfil_acesso; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5474--
5475
5476ALTER TABLE ONLY perfil_acesso_permissao
5477    ADD CONSTRAINT fk_perfil_acesso_permissao_perfil_acesso FOREIGN KEY (perfil_acesso_id) REFERENCES perfil_acesso(id);
5478
5479
5480--
5481-- Name: plano_seguro fk_plano_seguro_produto_seguro; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5482--
5483
5484ALTER TABLE ONLY plano_seguro
5485    ADD CONSTRAINT fk_plano_seguro_produto_seguro FOREIGN KEY (produto_seguro_id) REFERENCES produto_seguro(id);
5486
5487
5488--
5489-- Name: profissao_restricao_plano_seguro fk_profissao_restricao_plano_seguro_plano_seguro; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5490--
5491
5492ALTER TABLE ONLY profissao_restricao_plano_seguro
5493    ADD CONSTRAINT fk_profissao_restricao_plano_seguro_plano_seguro FOREIGN KEY (plano_seguro_id) REFERENCES plano_seguro(id);
5494
5495
5496--
5497-- Name: profissao_restricao_plano_seguro fk_profissao_restricao_plano_seguro_profissao; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5498--
5499
5500ALTER TABLE ONLY profissao_restricao_plano_seguro
5501    ADD CONSTRAINT fk_profissao_restricao_plano_seguro_profissao FOREIGN KEY (profissao_id) REFERENCES profissao(id);
5502
5503
5504--
5505-- Name: solicitacao_cotacao_seguro fk_solicitacao_cotacao_seguro; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5506--
5507
5508ALTER TABLE ONLY solicitacao_cotacao_seguro
5509    ADD CONSTRAINT fk_solicitacao_cotacao_seguro FOREIGN KEY (executivo_id) REFERENCES "user"(id);
5510
5511
5512--
5513-- Name: solicitacao_cotacao_seguro fk_solicitacao_cotacao_seguro_agente_autorizado; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5514--
5515
5516ALTER TABLE ONLY solicitacao_cotacao_seguro
5517    ADD CONSTRAINT fk_solicitacao_cotacao_seguro_agente_autorizado FOREIGN KEY (agente_autorizado_id) REFERENCES "user"(id);
5518
5519
5520--
5521-- Name: solicitacao_cotacao_seguro fk_solicitacao_cotacao_seguro_apolice_seguro; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5522--
5523
5524ALTER TABLE ONLY solicitacao_cotacao_seguro
5525    ADD CONSTRAINT fk_solicitacao_cotacao_seguro_apolice_seguro FOREIGN KEY (apolice_seguro_id) REFERENCES apolice_seguro(id);
5526
5527
5528--
5529-- Name: solicitacao_cotacao_seguro fk_solicitacao_cotacao_seguro_conjuge; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5530--
5531
5532ALTER TABLE ONLY solicitacao_cotacao_seguro
5533    ADD CONSTRAINT fk_solicitacao_cotacao_seguro_conjuge FOREIGN KEY (conjuge_id) REFERENCES conjuge(id);
5534
5535
5536--
5537-- Name: solicitacao_cotacao_seguro fk_solicitacao_cotacao_seguro_endereco_trabalho; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5538--
5539
5540ALTER TABLE ONLY solicitacao_cotacao_seguro
5541    ADD CONSTRAINT fk_solicitacao_cotacao_seguro_endereco_trabalho FOREIGN KEY (endereco_trabalho_id) REFERENCES endereco(id);
5542
5543
5544--
5545-- Name: solicitacao_cotacao_seguro fk_solicitacao_cotacao_seguro_plano_seguro; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5546--
5547
5548ALTER TABLE ONLY solicitacao_cotacao_seguro
5549    ADD CONSTRAINT fk_solicitacao_cotacao_seguro_plano_seguro FOREIGN KEY (plano_seguro_id) REFERENCES plano_seguro(id);
5550
5551
5552--
5553-- Name: usuario_perfil_acesso fk_usuario_perfil_acesso_perfil_acesso; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5554--
5555
5556ALTER TABLE ONLY usuario_perfil_acesso
5557    ADD CONSTRAINT fk_usuario_perfil_acesso_perfil_acesso FOREIGN KEY (perfil_acesso_id) REFERENCES perfil_acesso(id);
5558
5559
5560--
5561-- Name: usuario_perfil_acesso fk_usuario_perfil_acesso_usuario; Type: FK CONSTRAINT; Schema: public; Owner: vidafacil
5562--
5563
5564ALTER TABLE ONLY usuario_perfil_acesso
5565    ADD CONSTRAINT fk_usuario_perfil_acesso_usuario FOREIGN KEY (user_id) REFERENCES "user"(id);
5566
5567
5568--
5569-- PostgreSQL database dump complete
5570--