--
-- PostgreSQL database dump
--

\restrict B0ebdLhMb9GpCpdvvaLUQKjmzZOzMcZe8BIttn0hN6R1pPuqFcyzc1dumbjSgFe

-- Dumped from database version 17.6
-- Dumped by pg_dump version 17.6

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET transaction_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: auth_group; Type: TABLE; Schema: public; Owner: danielgusdev
--

CREATE TABLE public.auth_group (
    id integer NOT NULL,
    name character varying(150) NOT NULL
);


ALTER TABLE public.auth_group OWNER TO danielgusdev;

--
-- Name: auth_group_id_seq; Type: SEQUENCE; Schema: public; Owner: danielgusdev
--

ALTER TABLE public.auth_group ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.auth_group_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: auth_group_permissions; Type: TABLE; Schema: public; Owner: danielgusdev
--

CREATE TABLE public.auth_group_permissions (
    id bigint NOT NULL,
    group_id integer NOT NULL,
    permission_id integer NOT NULL
);


ALTER TABLE public.auth_group_permissions OWNER TO danielgusdev;

--
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: danielgusdev
--

ALTER TABLE public.auth_group_permissions ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.auth_group_permissions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: auth_permission; Type: TABLE; Schema: public; Owner: danielgusdev
--

CREATE TABLE public.auth_permission (
    id integer NOT NULL,
    name character varying(255) NOT NULL,
    content_type_id integer NOT NULL,
    codename character varying(100) NOT NULL
);


ALTER TABLE public.auth_permission OWNER TO danielgusdev;

--
-- Name: auth_permission_id_seq; Type: SEQUENCE; Schema: public; Owner: danielgusdev
--

ALTER TABLE public.auth_permission ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.auth_permission_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: auth_user; Type: TABLE; Schema: public; Owner: danielgusdev
--

CREATE TABLE public.auth_user (
    id integer NOT NULL,
    password character varying(128) NOT NULL,
    last_login timestamp with time zone,
    is_superuser boolean NOT NULL,
    username character varying(150) NOT NULL,
    first_name character varying(150) NOT NULL,
    last_name character varying(150) NOT NULL,
    email character varying(254) NOT NULL,
    is_staff boolean NOT NULL,
    is_active boolean NOT NULL,
    date_joined timestamp with time zone NOT NULL
);


ALTER TABLE public.auth_user OWNER TO danielgusdev;

--
-- Name: auth_user_groups; Type: TABLE; Schema: public; Owner: danielgusdev
--

CREATE TABLE public.auth_user_groups (
    id bigint NOT NULL,
    user_id integer NOT NULL,
    group_id integer NOT NULL
);


ALTER TABLE public.auth_user_groups OWNER TO danielgusdev;

--
-- Name: auth_user_groups_id_seq; Type: SEQUENCE; Schema: public; Owner: danielgusdev
--

ALTER TABLE public.auth_user_groups ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.auth_user_groups_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: auth_user_id_seq; Type: SEQUENCE; Schema: public; Owner: danielgusdev
--

ALTER TABLE public.auth_user ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.auth_user_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: auth_user_user_permissions; Type: TABLE; Schema: public; Owner: danielgusdev
--

CREATE TABLE public.auth_user_user_permissions (
    id bigint NOT NULL,
    user_id integer NOT NULL,
    permission_id integer NOT NULL
);


ALTER TABLE public.auth_user_user_permissions OWNER TO danielgusdev;

--
-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: danielgusdev
--

ALTER TABLE public.auth_user_user_permissions ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.auth_user_user_permissions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: dashboard_animal; Type: TABLE; Schema: public; Owner: danielgusdev
--

CREATE TABLE public.dashboard_animal (
    id bigint NOT NULL,
    especie character varying(50) NOT NULL,
    sexo character varying(10) NOT NULL,
    propriedade_id bigint NOT NULL
);


ALTER TABLE public.dashboard_animal OWNER TO danielgusdev;

--
-- Name: dashboard_animal_id_seq; Type: SEQUENCE; Schema: public; Owner: danielgusdev
--

ALTER TABLE public.dashboard_animal ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.dashboard_animal_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: dashboard_atividade; Type: TABLE; Schema: public; Owner: danielgusdev
--

CREATE TABLE public.dashboard_atividade (
    id bigint NOT NULL,
    nome character varying(100) NOT NULL
);


ALTER TABLE public.dashboard_atividade OWNER TO danielgusdev;

--
-- Name: dashboard_atividade_id_seq; Type: SEQUENCE; Schema: public; Owner: danielgusdev
--

ALTER TABLE public.dashboard_atividade ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.dashboard_atividade_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: dashboard_colaborador; Type: TABLE; Schema: public; Owner: danielgusdev
--

CREATE TABLE public.dashboard_colaborador (
    id bigint NOT NULL,
    nome character varying(100) NOT NULL,
    cpf character varying(14) NOT NULL,
    tipo character varying(20) NOT NULL,
    email character varying(254),
    telefone character varying(20),
    rg character varying(20),
    nome_mae character varying(100),
    foto character varying(100)
);


ALTER TABLE public.dashboard_colaborador OWNER TO danielgusdev;

--
-- Name: dashboard_colaborador_id_seq; Type: SEQUENCE; Schema: public; Owner: danielgusdev
--

ALTER TABLE public.dashboard_colaborador ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.dashboard_colaborador_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: dashboard_despesa; Type: TABLE; Schema: public; Owner: danielgusdev
--

CREATE TABLE public.dashboard_despesa (
    id bigint NOT NULL,
    categoria character varying(50) NOT NULL,
    nome character varying(100),
    fornecedor character varying(100),
    fazenda character varying(100),
    tipo_animal character varying(100),
    tipo_despesa character varying(100) NOT NULL,
    valor numeric(10,2) NOT NULL,
    centro_custo character varying(100),
    percentual_rateio integer NOT NULL,
    observacao text,
    data_registro timestamp with time zone NOT NULL,
    CONSTRAINT dashboard_despesa_percentual_rateio_check CHECK ((percentual_rateio >= 0))
);


ALTER TABLE public.dashboard_despesa OWNER TO danielgusdev;

--
-- Name: dashboard_despesa_id_seq; Type: SEQUENCE; Schema: public; Owner: danielgusdev
--

ALTER TABLE public.dashboard_despesa ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.dashboard_despesa_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: dashboard_fornecedor; Type: TABLE; Schema: public; Owner: danielgusdev
--

CREATE TABLE public.dashboard_fornecedor (
    id bigint NOT NULL,
    cnpj character varying(18) NOT NULL,
    nome_fantasia character varying(100) NOT NULL,
    razao_social character varying(100),
    inscricao_estadual character varying(20),
    endereco character varying(200),
    telefone character varying(20),
    email character varying(254),
    ativo boolean NOT NULL,
    contato character varying(100)
);


ALTER TABLE public.dashboard_fornecedor OWNER TO danielgusdev;

--
-- Name: dashboard_fornecedor_id_seq; Type: SEQUENCE; Schema: public; Owner: danielgusdev
--

ALTER TABLE public.dashboard_fornecedor ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.dashboard_fornecedor_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: dashboard_fotopropriedade; Type: TABLE; Schema: public; Owner: danielgusdev
--

CREATE TABLE public.dashboard_fotopropriedade (
    id bigint NOT NULL,
    imagem character varying(100),
    descricao character varying(255),
    propriedade_id bigint NOT NULL
);


ALTER TABLE public.dashboard_fotopropriedade OWNER TO danielgusdev;

--
-- Name: dashboard_fotopropriedade_id_seq; Type: SEQUENCE; Schema: public; Owner: danielgusdev
--

ALTER TABLE public.dashboard_fotopropriedade ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.dashboard_fotopropriedade_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: dashboard_lancamento; Type: TABLE; Schema: public; Owner: danielgusdev
--

CREATE TABLE public.dashboard_lancamento (
    id bigint NOT NULL,
    tipo character varying(10) NOT NULL,
    categoria_despesa character varying(50),
    categoria_receita character varying(50),
    categoria_investimento character varying(50),
    observacao character varying(200),
    fornecedor_local_nome character varying(100),
    fornecedor_local_tel character varying(20),
    fornecedor_local_email character varying(254),
    fornecedor_local_desc character varying(200),
    fazenda character varying(100),
    animal_tipo character varying(100),
    centro_custo character varying(100),
    percentual numeric(7,2),
    valor numeric(12,2) NOT NULL,
    data date NOT NULL,
    colaborador_id bigint,
    fornecedor_id bigint,
    descricao_item character varying(200),
    nota_fiscal character varying(100)
);


ALTER TABLE public.dashboard_lancamento OWNER TO danielgusdev;

--
-- Name: dashboard_lancamento_id_seq; Type: SEQUENCE; Schema: public; Owner: danielgusdev
--

ALTER TABLE public.dashboard_lancamento ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.dashboard_lancamento_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: dashboard_pluviometria; Type: TABLE; Schema: public; Owner: danielgusdev
--

CREATE TABLE public.dashboard_pluviometria (
    id bigint NOT NULL,
    data date NOT NULL,
    quantidade numeric(6,2) NOT NULL,
    observacoes text,
    propriedade_id bigint NOT NULL
);


ALTER TABLE public.dashboard_pluviometria OWNER TO danielgusdev;

--
-- Name: dashboard_pluviometria_id_seq; Type: SEQUENCE; Schema: public; Owner: danielgusdev
--

ALTER TABLE public.dashboard_pluviometria ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.dashboard_pluviometria_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: dashboard_propriedade; Type: TABLE; Schema: public; Owner: danielgusdev
--

CREATE TABLE public.dashboard_propriedade (
    id bigint NOT NULL,
    nome character varying(100) NOT NULL,
    localizacao character varying(200) NOT NULL,
    area_hectares numeric(10,2) NOT NULL,
    cultura_principal_id bigint,
    producao_anual numeric(12,2),
    valor_terra numeric(12,2),
    data_cadastro date NOT NULL,
    codigo_valor character varying(30),
    tipo_codigo character varying(10)
);


ALTER TABLE public.dashboard_propriedade OWNER TO danielgusdev;

--
-- Name: dashboard_propriedade_id_seq; Type: SEQUENCE; Schema: public; Owner: danielgusdev
--

ALTER TABLE public.dashboard_propriedade ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.dashboard_propriedade_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: dashboard_rateiodespesa; Type: TABLE; Schema: public; Owner: danielgusdev
--

CREATE TABLE public.dashboard_rateiodespesa (
    id bigint NOT NULL,
    centro_custo character varying(100) NOT NULL,
    percentual numeric(5,2) NOT NULL,
    lancamento_id bigint NOT NULL
);


ALTER TABLE public.dashboard_rateiodespesa OWNER TO danielgusdev;

--
-- Name: dashboard_rateiodespesa_id_seq; Type: SEQUENCE; Schema: public; Owner: danielgusdev
--

ALTER TABLE public.dashboard_rateiodespesa ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.dashboard_rateiodespesa_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: dashboard_relatoriofinanceiro; Type: TABLE; Schema: public; Owner: danielgusdev
--

CREATE TABLE public.dashboard_relatoriofinanceiro (
    id bigint NOT NULL,
    mes character varying(20) NOT NULL,
    receita numeric(10,2) NOT NULL,
    despesa numeric(10,2) NOT NULL,
    categoria character varying(50) NOT NULL,
    propriedade_id bigint NOT NULL
);


ALTER TABLE public.dashboard_relatoriofinanceiro OWNER TO danielgusdev;

--
-- Name: dashboard_relatoriofinanceiro_id_seq; Type: SEQUENCE; Schema: public; Owner: danielgusdev
--

ALTER TABLE public.dashboard_relatoriofinanceiro ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.dashboard_relatoriofinanceiro_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: django_admin_log; Type: TABLE; Schema: public; Owner: danielgusdev
--

CREATE TABLE public.django_admin_log (
    id integer NOT NULL,
    action_time timestamp with time zone NOT NULL,
    object_id text,
    object_repr character varying(200) NOT NULL,
    action_flag smallint NOT NULL,
    change_message text NOT NULL,
    content_type_id integer,
    user_id integer NOT NULL,
    CONSTRAINT django_admin_log_action_flag_check CHECK ((action_flag >= 0))
);


ALTER TABLE public.django_admin_log OWNER TO danielgusdev;

--
-- Name: django_admin_log_id_seq; Type: SEQUENCE; Schema: public; Owner: danielgusdev
--

ALTER TABLE public.django_admin_log ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.django_admin_log_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: django_content_type; Type: TABLE; Schema: public; Owner: danielgusdev
--

CREATE TABLE public.django_content_type (
    id integer NOT NULL,
    app_label character varying(100) NOT NULL,
    model character varying(100) NOT NULL
);


ALTER TABLE public.django_content_type OWNER TO danielgusdev;

--
-- Name: django_content_type_id_seq; Type: SEQUENCE; Schema: public; Owner: danielgusdev
--

ALTER TABLE public.django_content_type ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.django_content_type_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: django_migrations; Type: TABLE; Schema: public; Owner: danielgusdev
--

CREATE TABLE public.django_migrations (
    id bigint NOT NULL,
    app character varying(255) NOT NULL,
    name character varying(255) NOT NULL,
    applied timestamp with time zone NOT NULL
);


ALTER TABLE public.django_migrations OWNER TO danielgusdev;

--
-- Name: django_migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: danielgusdev
--

ALTER TABLE public.django_migrations ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.django_migrations_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: django_session; Type: TABLE; Schema: public; Owner: danielgusdev
--

CREATE TABLE public.django_session (
    session_key character varying(40) NOT NULL,
    session_data text NOT NULL,
    expire_date timestamp with time zone NOT NULL
);


ALTER TABLE public.django_session OWNER TO danielgusdev;

--
-- Data for Name: auth_group; Type: TABLE DATA; Schema: public; Owner: danielgusdev
--

COPY public.auth_group (id, name) FROM stdin;
\.


--
-- Data for Name: auth_group_permissions; Type: TABLE DATA; Schema: public; Owner: danielgusdev
--

COPY public.auth_group_permissions (id, group_id, permission_id) FROM stdin;
\.


--
-- Data for Name: auth_permission; Type: TABLE DATA; Schema: public; Owner: danielgusdev
--

COPY public.auth_permission (id, name, content_type_id, codename) FROM stdin;
1	Can add log entry	1	add_logentry
2	Can change log entry	1	change_logentry
3	Can delete log entry	1	delete_logentry
4	Can view log entry	1	view_logentry
5	Can add permission	2	add_permission
6	Can change permission	2	change_permission
7	Can delete permission	2	delete_permission
8	Can view permission	2	view_permission
9	Can add group	3	add_group
10	Can change group	3	change_group
11	Can delete group	3	delete_group
12	Can view group	3	view_group
13	Can add user	4	add_user
14	Can change user	4	change_user
15	Can delete user	4	delete_user
16	Can view user	4	view_user
17	Can add content type	5	add_contenttype
18	Can change content type	5	change_contenttype
19	Can delete content type	5	delete_contenttype
20	Can view content type	5	view_contenttype
21	Can add session	6	add_session
22	Can change session	6	change_session
23	Can delete session	6	delete_session
24	Can view session	6	view_session
25	Can add propriedade	7	add_propriedade
26	Can change propriedade	7	change_propriedade
27	Can delete propriedade	7	delete_propriedade
28	Can view propriedade	7	view_propriedade
29	Can add foto propriedade	8	add_fotopropriedade
30	Can change foto propriedade	8	change_fotopropriedade
31	Can delete foto propriedade	8	delete_fotopropriedade
32	Can view foto propriedade	8	view_fotopropriedade
33	Can add animal	9	add_animal
34	Can change animal	9	change_animal
35	Can delete animal	9	delete_animal
36	Can view animal	9	view_animal
37	Can add colaborador	10	add_colaborador
38	Can change colaborador	10	change_colaborador
39	Can delete colaborador	10	delete_colaborador
40	Can view colaborador	10	view_colaborador
41	Can add fornecedor	11	add_fornecedor
42	Can change fornecedor	11	change_fornecedor
43	Can delete fornecedor	11	delete_fornecedor
44	Can view fornecedor	11	view_fornecedor
45	Can add lancamento	12	add_lancamento
46	Can change lancamento	12	change_lancamento
47	Can delete lancamento	12	delete_lancamento
48	Can view lancamento	12	view_lancamento
49	Can add relatorio financeiro	13	add_relatoriofinanceiro
50	Can change relatorio financeiro	13	change_relatoriofinanceiro
51	Can delete relatorio financeiro	13	delete_relatoriofinanceiro
52	Can view relatorio financeiro	13	view_relatoriofinanceiro
53	Can add atividade	14	add_atividade
54	Can change atividade	14	change_atividade
55	Can delete atividade	14	delete_atividade
56	Can view atividade	14	view_atividade
57	Can add pluviometria	15	add_pluviometria
58	Can change pluviometria	15	change_pluviometria
59	Can delete pluviometria	15	delete_pluviometria
60	Can view pluviometria	15	view_pluviometria
61	Can add despesa	16	add_despesa
62	Can change despesa	16	change_despesa
63	Can delete despesa	16	delete_despesa
64	Can view despesa	16	view_despesa
65	Can add rateio despesa	17	add_rateiodespesa
66	Can change rateio despesa	17	change_rateiodespesa
67	Can delete rateio despesa	17	delete_rateiodespesa
68	Can view rateio despesa	17	view_rateiodespesa
\.


--
-- Data for Name: auth_user; Type: TABLE DATA; Schema: public; Owner: danielgusdev
--

COPY public.auth_user (id, password, last_login, is_superuser, username, first_name, last_name, email, is_staff, is_active, date_joined) FROM stdin;
\.


--
-- Data for Name: auth_user_groups; Type: TABLE DATA; Schema: public; Owner: danielgusdev
--

COPY public.auth_user_groups (id, user_id, group_id) FROM stdin;
\.


--
-- Data for Name: auth_user_user_permissions; Type: TABLE DATA; Schema: public; Owner: danielgusdev
--

COPY public.auth_user_user_permissions (id, user_id, permission_id) FROM stdin;
\.


--
-- Data for Name: dashboard_animal; Type: TABLE DATA; Schema: public; Owner: danielgusdev
--

COPY public.dashboard_animal (id, especie, sexo, propriedade_id) FROM stdin;
\.


--
-- Data for Name: dashboard_atividade; Type: TABLE DATA; Schema: public; Owner: danielgusdev
--

COPY public.dashboard_atividade (id, nome) FROM stdin;
1	Gado de Leite
2	Gado de Corte
3	Caprinos
4	Cavalos
5	Agricultura
\.


--
-- Data for Name: dashboard_colaborador; Type: TABLE DATA; Schema: public; Owner: danielgusdev
--

COPY public.dashboard_colaborador (id, nome, cpf, tipo, email, telefone, rg, nome_mae, foto) FROM stdin;
1	DANIEL ALVES DOS SANTOS	03355627445	vaqueiro	danielperitofd@gmail.com	87999204532	6801091	Ana Lucia Silva dos Santos	colaboradores/daniel_agrogestor.JPG
2	Fabio dos Santos Brito	77705261081	vaqueiro	fabiosantosbrito@gmail.com	87988095263	456123786	Vera Lucia Carneiro	colaboradores/fabio.PNG
3	Saulo Emanoel Vitorino	12345678909	encarregado	saulovitorino@gmail.com	879465321826	4825617	Maria Vitorina da Silva Saula	colaboradores/saulo.PNG
\.


--
-- Data for Name: dashboard_despesa; Type: TABLE DATA; Schema: public; Owner: danielgusdev
--

COPY public.dashboard_despesa (id, categoria, nome, fornecedor, fazenda, tipo_animal, tipo_despesa, valor, centro_custo, percentual_rateio, observacao, data_registro) FROM stdin;
\.


--
-- Data for Name: dashboard_fornecedor; Type: TABLE DATA; Schema: public; Owner: danielgusdev
--

COPY public.dashboard_fornecedor (id, cnpj, nome_fantasia, razao_social, inscricao_estadual, endereco, telefone, email, ativo, contato) FROM stdin;
2	60701521006724	EEBP PR. VALENTINA DE OLIVEIRA FIGUEIREDO EX.GARANHUNS	FUNDACAO BRADESCO	\N	RODOVIA PE, 218 - SITIO MUNDAU, GARANHUNS - PE	87999204532	garanhuns@fundacao.bradesco	f	DANIEL ALVES DOS SANTOS
3	08645415000124	INFOCIA	MARCOS ANTONIO GOMES DE LIMA	\N	RUA DOS INCONFIDENTES, 680 - BOA VISTA, GARANHUNS - PE	8788061033	marcos@infocia.com.br	f	Marcio
\.


--
-- Data for Name: dashboard_fotopropriedade; Type: TABLE DATA; Schema: public; Owner: danielgusdev
--

COPY public.dashboard_fotopropriedade (id, imagem, descricao, propriedade_id) FROM stdin;
1	propriedades/fazenda_daniel/DSC05150.JPG	\N	3
2	propriedades/fazenda_daniel/DSC05151.JPG	\N	3
3	propriedades/fazenda_daniel/DSC05152.JPG	\N	3
4	propriedades/fazenda_daniel/DSC05153.JPG	\N	3
5	propriedades/fazenda_vanthuir/DSC05173.JPG	\N	4
6	propriedades/fazenda_vanthuir/DSC05174.JPG	\N	4
7	propriedades/fazenda_vanthuir/DSC05175.JPG	\N	4
8	propriedades/fazenda_vanthuir/DSC05176.JPG	\N	4
9	propriedades/fazenda_de_jullya/Imag001.jpg	\N	5
10	propriedades/fazenda_de_jullya/Imag002.jpg	\N	5
11	propriedades/fazenda_de_jullya/Imag003.jpg	\N	5
12	propriedades/fazenda_de_jullya/Imag004.jpg	\N	5
13	propriedades/fazenda_de_jullya/Imag005.jpg	\N	5
14	propriedades/guigincod/S6300139.JPG	\N	6
15	propriedades/guigincod/S6300140.JPG	\N	6
16	propriedades/guigincod/S6300141.JPG	\N	6
17	propriedades/guigincod/S6300142.JPG	\N	6
18	propriedades/guigincod/S6300143.JPG	\N	6
19	propriedades/brocoio/PHOT0036.JPG	\N	7
20	propriedades/brocoio/PHOT0037.JPG	\N	7
21	propriedades/brocoio/PHOT0038.JPG	\N	7
22	propriedades/brocoio/PHOT0039.JPG	\N	7
23	propriedades/rancho_alegrinho/S5000387.JPG	\N	8
24	propriedades/rancho_alegrinho/S5000390.JPG	\N	8
25	propriedades/rancho_alegrinho/S5000401.JPG	\N	8
26	propriedades/rancho_alegrinho/S5000402.JPG	\N	8
27	propriedades/rancho_alegrinho/S5000408.JPG	\N	8
28	propriedades/rancho_alegrinho/S5000420.JPG	\N	8
29	propriedades/brejinho/Dependencias_e_EdInfantil_030.jpg	\N	9
30	propriedades/brejinho/Dependencias_e_EdInfantil_031.jpg	\N	9
31	propriedades/brejinho/Dependencias_e_EdInfantil_032.jpg	\N	9
32	propriedades/brejinho/Dependencias_e_EdInfantil_033.jpg	\N	9
\.


--
-- Data for Name: dashboard_lancamento; Type: TABLE DATA; Schema: public; Owner: danielgusdev
--

COPY public.dashboard_lancamento (id, tipo, categoria_despesa, categoria_receita, categoria_investimento, observacao, fornecedor_local_nome, fornecedor_local_tel, fornecedor_local_email, fornecedor_local_desc, fazenda, animal_tipo, centro_custo, percentual, valor, data, colaborador_id, fornecedor_id, descricao_item, nota_fiscal) FROM stdin;
14		vaqueiro	\N	\N	Hello World! com compra de drogas!	\N	\N	\N	\N	SJ Cabras		\N	\N	2895.20	2025-11-08	1	\N	Desp. Gerais	despesas/nfs/2025/11/MiRoute_-_Relatorio_Final_qT49ITI.pdf
16		encarregado	\N	\N	\N	\N	\N	\N	\N	SJ Cavalos		\N	\N	800.00	2025-11-09	3	\N	Desp. Tributárias	despesas/nfs/2025/11/Cotação_Hub_USB_Biblioteca.pdf
17		vaqueiro	\N	\N	chupiska	\N	\N	\N	\N	SJ Cabras		\N	\N	4258.33	2025-11-09	1	\N	Desp. Tributárias	despesas/nfs/2025/11/ATA_de_entrega_de_certiicados.pdf
15		vaqueiro	\N	\N	louco de pedra... coxixinha	\N	\N	\N	\N	Escorregão	\N	\N	\N	1750.90	2025-11-09	2	\N	Ordenha / Resfriadores	despesas/nfs/2025/11/MiRoute_-_Relatorio_Final_CeWja9e.pdf
18		compras_animais	\N	\N	Charape	\N	\N	\N	\N	SJ Vacas	Ovinos - Machos	\N	\N	10520.30	2025-11-09	1	\N	Desp. Financeiras	despesas/nfs/2025/11/Apres_in46PqY._Transforma_PE.pdf
19		compras_animais	\N	\N	Nonea chupiskada valente	\N	\N	\N	\N	SJ Cavalos	Caprinos - Fêmeas	\N	\N	1999.99	2025-11-10	1	3	Desp. Tributárias	despesas/nfs/2025/11/DANIEL_ALVES_DOS_SANTOS_part_1_-_assinado.pdf
\.


--
-- Data for Name: dashboard_pluviometria; Type: TABLE DATA; Schema: public; Owner: danielgusdev
--

COPY public.dashboard_pluviometria (id, data, quantidade, observacoes, propriedade_id) FROM stdin;
24	2025-11-05	5.00	Chuva teste dia 0	1
25	2025-11-04	7.30	Chuva teste dia 1	1
26	2025-11-03	9.60	Chuva teste dia 2	1
27	2025-11-02	11.90	Chuva teste dia 3	1
28	2025-11-01	14.20	Chuva teste dia 4	1
29	2025-10-31	16.50	Chuva teste dia 5	1
30	2025-10-30	18.80	Chuva teste dia 6	1
\.


--
-- Data for Name: dashboard_propriedade; Type: TABLE DATA; Schema: public; Owner: danielgusdev
--

COPY public.dashboard_propriedade (id, nome, localizacao, area_hectares, cultura_principal_id, producao_anual, valor_terra, data_cadastro, codigo_valor, tipo_codigo) FROM stdin;
8	Rancho Alegrinho	Canhotinho, PE	15568236.23	1	5000.00	1526394.58	2025-10-31	\N	ccir
9	Brejinho	JACARAMBARA	200000.00	1	2000.00	45123456.78	2025-10-31	456789123456	car
1	SJ Cabras	Garanhuns, PE	150000.00	1	500000.00	752698.52	2025-10-28	\N	\N
3	SJ Vacas	Garanhuns, PE	426532.00	\N	248369.00	1234568123.00	2025-10-30	1234567890123	ccir
4	SJ Cavalos	Garanhuns, PE	25.00	1	4125.00	0.00	2025-10-30	1234567891230	ccir
5	Santo Antônio	Garanhuns, PE	50.00	3	50000.00	68.00	2025-10-30	123456789123	ccir
6	Escorregão	Garanhuns, PE	1234567.89	2	1234561.23	1234567.89	2025-10-30	123456789	car
7	Bela Chã	Garanhuns, PE	123456.13	2	1234564.13	12345612.32	2025-10-31	123456748123	ccir
\.


--
-- Data for Name: dashboard_rateiodespesa; Type: TABLE DATA; Schema: public; Owner: danielgusdev
--

COPY public.dashboard_rateiodespesa (id, centro_custo, percentual, lancamento_id) FROM stdin;
4	Cavalos	25.00	14
6	Cavalos	36.00	16
7	Cavalos	70.00	17
10	Pastagens	52.00	19
\.


--
-- Data for Name: dashboard_relatoriofinanceiro; Type: TABLE DATA; Schema: public; Owner: danielgusdev
--

COPY public.dashboard_relatoriofinanceiro (id, mes, receita, despesa, categoria, propriedade_id) FROM stdin;
\.


--
-- Data for Name: django_admin_log; Type: TABLE DATA; Schema: public; Owner: danielgusdev
--

COPY public.django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) FROM stdin;
\.


--
-- Data for Name: django_content_type; Type: TABLE DATA; Schema: public; Owner: danielgusdev
--

COPY public.django_content_type (id, app_label, model) FROM stdin;
1	admin	logentry
2	auth	permission
3	auth	group
4	auth	user
5	contenttypes	contenttype
6	sessions	session
7	dashboard	propriedade
8	dashboard	fotopropriedade
9	dashboard	animal
10	dashboard	colaborador
11	dashboard	fornecedor
12	dashboard	lancamento
13	dashboard	relatoriofinanceiro
14	dashboard	atividade
15	dashboard	pluviometria
16	dashboard	despesa
17	dashboard	rateiodespesa
\.


--
-- Data for Name: django_migrations; Type: TABLE DATA; Schema: public; Owner: danielgusdev
--

COPY public.django_migrations (id, app, name, applied) FROM stdin;
1	contenttypes	0001_initial	2025-10-28 17:03:32.400349-03
2	auth	0001_initial	2025-10-28 17:03:32.5039-03
3	admin	0001_initial	2025-10-28 17:03:32.531722-03
4	admin	0002_logentry_remove_auto_add	2025-10-28 17:03:32.539654-03
5	admin	0003_logentry_add_action_flag_choices	2025-10-28 17:03:32.548951-03
6	contenttypes	0002_remove_content_type_name	2025-10-28 17:03:32.576336-03
7	auth	0002_alter_permission_name_max_length	2025-10-28 17:03:32.587554-03
8	auth	0003_alter_user_email_max_length	2025-10-28 17:03:32.595874-03
9	auth	0004_alter_user_username_opts	2025-10-28 17:03:32.603699-03
10	auth	0005_alter_user_last_login_null	2025-10-28 17:03:32.612869-03
11	auth	0006_require_contenttypes_0002	2025-10-28 17:03:32.614238-03
12	auth	0007_alter_validators_add_error_messages	2025-10-28 17:03:32.628326-03
13	auth	0008_alter_user_username_max_length	2025-10-28 17:03:32.64435-03
14	auth	0009_alter_user_last_name_max_length	2025-10-28 17:03:32.658586-03
15	auth	0010_alter_group_name_max_length	2025-10-28 17:03:32.66769-03
16	auth	0011_update_proxy_permissions	2025-10-28 17:03:32.698629-03
17	auth	0012_alter_user_first_name_max_length	2025-10-28 17:03:32.70789-03
18	sessions	0001_initial	2025-10-28 17:03:32.720554-03
19	dashboard	0001_initial	2025-10-28 18:19:43.681799-03
20	dashboard	0002_remove_propriedade_slug_propriedade_data_cadastro_and_more	2025-10-28 18:47:52.446545-03
21	dashboard	0003_atividade_alter_propriedade_cultura_principal	2025-10-28 21:49:44.338566-03
22	dashboard	0004_alter_fotopropriedade_imagem	2025-10-28 22:50:03.254585-03
23	dashboard	0005_propriedade_codigo_valor_propriedade_tipo_codigo	2025-10-28 23:14:17.626429-03
24	dashboard	0006_alter_fotopropriedade_descricao_and_more	2025-10-30 13:32:44.071262-03
25	dashboard	0007_alter_fotopropriedade_imagem	2025-10-30 13:34:39.647748-03
26	dashboard	0008_fornecedor_contato	2025-11-05 00:33:12.698639-03
27	dashboard	0009_pluviometria	2025-11-05 22:57:14.551696-03
28	dashboard	0010_rename_quantidade_pluviometria_quantidade_mm	2025-11-05 23:14:04.586409-03
29	dashboard	0011_rename_quantidade_mm_pluviometria_quantidade	2025-11-05 23:34:45.396324-03
30	dashboard	0012_despesa_lancamento_descricao_item_and_more	2025-11-06 23:52:27.980925-03
\.


--
-- Data for Name: django_session; Type: TABLE DATA; Schema: public; Owner: danielgusdev
--

COPY public.django_session (session_key, session_data, expire_date) FROM stdin;
\.


--
-- Name: auth_group_id_seq; Type: SEQUENCE SET; Schema: public; Owner: danielgusdev
--

SELECT pg_catalog.setval('public.auth_group_id_seq', 1, false);


--
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: danielgusdev
--

SELECT pg_catalog.setval('public.auth_group_permissions_id_seq', 1, false);


--
-- Name: auth_permission_id_seq; Type: SEQUENCE SET; Schema: public; Owner: danielgusdev
--

SELECT pg_catalog.setval('public.auth_permission_id_seq', 68, true);


--
-- Name: auth_user_groups_id_seq; Type: SEQUENCE SET; Schema: public; Owner: danielgusdev
--

SELECT pg_catalog.setval('public.auth_user_groups_id_seq', 1, false);


--
-- Name: auth_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: danielgusdev
--

SELECT pg_catalog.setval('public.auth_user_id_seq', 1, false);


--
-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: danielgusdev
--

SELECT pg_catalog.setval('public.auth_user_user_permissions_id_seq', 1, false);


--
-- Name: dashboard_animal_id_seq; Type: SEQUENCE SET; Schema: public; Owner: danielgusdev
--

SELECT pg_catalog.setval('public.dashboard_animal_id_seq', 1, false);


--
-- Name: dashboard_atividade_id_seq; Type: SEQUENCE SET; Schema: public; Owner: danielgusdev
--

SELECT pg_catalog.setval('public.dashboard_atividade_id_seq', 5, true);


--
-- Name: dashboard_colaborador_id_seq; Type: SEQUENCE SET; Schema: public; Owner: danielgusdev
--

SELECT pg_catalog.setval('public.dashboard_colaborador_id_seq', 3, true);


--
-- Name: dashboard_despesa_id_seq; Type: SEQUENCE SET; Schema: public; Owner: danielgusdev
--

SELECT pg_catalog.setval('public.dashboard_despesa_id_seq', 1, false);


--
-- Name: dashboard_fornecedor_id_seq; Type: SEQUENCE SET; Schema: public; Owner: danielgusdev
--

SELECT pg_catalog.setval('public.dashboard_fornecedor_id_seq', 3, true);


--
-- Name: dashboard_fotopropriedade_id_seq; Type: SEQUENCE SET; Schema: public; Owner: danielgusdev
--

SELECT pg_catalog.setval('public.dashboard_fotopropriedade_id_seq', 32, true);


--
-- Name: dashboard_lancamento_id_seq; Type: SEQUENCE SET; Schema: public; Owner: danielgusdev
--

SELECT pg_catalog.setval('public.dashboard_lancamento_id_seq', 19, true);


--
-- Name: dashboard_pluviometria_id_seq; Type: SEQUENCE SET; Schema: public; Owner: danielgusdev
--

SELECT pg_catalog.setval('public.dashboard_pluviometria_id_seq', 30, true);


--
-- Name: dashboard_propriedade_id_seq; Type: SEQUENCE SET; Schema: public; Owner: danielgusdev
--

SELECT pg_catalog.setval('public.dashboard_propriedade_id_seq', 9, true);


--
-- Name: dashboard_rateiodespesa_id_seq; Type: SEQUENCE SET; Schema: public; Owner: danielgusdev
--

SELECT pg_catalog.setval('public.dashboard_rateiodespesa_id_seq', 10, true);


--
-- Name: dashboard_relatoriofinanceiro_id_seq; Type: SEQUENCE SET; Schema: public; Owner: danielgusdev
--

SELECT pg_catalog.setval('public.dashboard_relatoriofinanceiro_id_seq', 1, false);


--
-- Name: django_admin_log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: danielgusdev
--

SELECT pg_catalog.setval('public.django_admin_log_id_seq', 1, false);


--
-- Name: django_content_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: danielgusdev
--

SELECT pg_catalog.setval('public.django_content_type_id_seq', 17, true);


--
-- Name: django_migrations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: danielgusdev
--

SELECT pg_catalog.setval('public.django_migrations_id_seq', 30, true);


--
-- Name: auth_group auth_group_name_key; Type: CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.auth_group
    ADD CONSTRAINT auth_group_name_key UNIQUE (name);


--
-- Name: auth_group_permissions auth_group_permissions_group_id_permission_id_0cd325b0_uniq; Type: CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_group_id_permission_id_0cd325b0_uniq UNIQUE (group_id, permission_id);


--
-- Name: auth_group_permissions auth_group_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_pkey PRIMARY KEY (id);


--
-- Name: auth_group auth_group_pkey; Type: CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.auth_group
    ADD CONSTRAINT auth_group_pkey PRIMARY KEY (id);


--
-- Name: auth_permission auth_permission_content_type_id_codename_01ab375a_uniq; Type: CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.auth_permission
    ADD CONSTRAINT auth_permission_content_type_id_codename_01ab375a_uniq UNIQUE (content_type_id, codename);


--
-- Name: auth_permission auth_permission_pkey; Type: CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.auth_permission
    ADD CONSTRAINT auth_permission_pkey PRIMARY KEY (id);


--
-- Name: auth_user_groups auth_user_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.auth_user_groups
    ADD CONSTRAINT auth_user_groups_pkey PRIMARY KEY (id);


--
-- Name: auth_user_groups auth_user_groups_user_id_group_id_94350c0c_uniq; Type: CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.auth_user_groups
    ADD CONSTRAINT auth_user_groups_user_id_group_id_94350c0c_uniq UNIQUE (user_id, group_id);


--
-- Name: auth_user auth_user_pkey; Type: CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.auth_user
    ADD CONSTRAINT auth_user_pkey PRIMARY KEY (id);


--
-- Name: auth_user_user_permissions auth_user_user_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_pkey PRIMARY KEY (id);


--
-- Name: auth_user_user_permissions auth_user_user_permissions_user_id_permission_id_14a6b632_uniq; Type: CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_user_id_permission_id_14a6b632_uniq UNIQUE (user_id, permission_id);


--
-- Name: auth_user auth_user_username_key; Type: CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.auth_user
    ADD CONSTRAINT auth_user_username_key UNIQUE (username);


--
-- Name: dashboard_animal dashboard_animal_pkey; Type: CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.dashboard_animal
    ADD CONSTRAINT dashboard_animal_pkey PRIMARY KEY (id);


--
-- Name: dashboard_atividade dashboard_atividade_nome_key; Type: CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.dashboard_atividade
    ADD CONSTRAINT dashboard_atividade_nome_key UNIQUE (nome);


--
-- Name: dashboard_atividade dashboard_atividade_pkey; Type: CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.dashboard_atividade
    ADD CONSTRAINT dashboard_atividade_pkey PRIMARY KEY (id);


--
-- Name: dashboard_colaborador dashboard_colaborador_pkey; Type: CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.dashboard_colaborador
    ADD CONSTRAINT dashboard_colaborador_pkey PRIMARY KEY (id);


--
-- Name: dashboard_despesa dashboard_despesa_pkey; Type: CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.dashboard_despesa
    ADD CONSTRAINT dashboard_despesa_pkey PRIMARY KEY (id);


--
-- Name: dashboard_fornecedor dashboard_fornecedor_cnpj_key; Type: CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.dashboard_fornecedor
    ADD CONSTRAINT dashboard_fornecedor_cnpj_key UNIQUE (cnpj);


--
-- Name: dashboard_fornecedor dashboard_fornecedor_pkey; Type: CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.dashboard_fornecedor
    ADD CONSTRAINT dashboard_fornecedor_pkey PRIMARY KEY (id);


--
-- Name: dashboard_fotopropriedade dashboard_fotopropriedade_pkey; Type: CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.dashboard_fotopropriedade
    ADD CONSTRAINT dashboard_fotopropriedade_pkey PRIMARY KEY (id);


--
-- Name: dashboard_lancamento dashboard_lancamento_pkey; Type: CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.dashboard_lancamento
    ADD CONSTRAINT dashboard_lancamento_pkey PRIMARY KEY (id);


--
-- Name: dashboard_pluviometria dashboard_pluviometria_pkey; Type: CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.dashboard_pluviometria
    ADD CONSTRAINT dashboard_pluviometria_pkey PRIMARY KEY (id);


--
-- Name: dashboard_pluviometria dashboard_pluviometria_propriedade_id_data_c6fb2cad_uniq; Type: CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.dashboard_pluviometria
    ADD CONSTRAINT dashboard_pluviometria_propriedade_id_data_c6fb2cad_uniq UNIQUE (propriedade_id, data);


--
-- Name: dashboard_propriedade dashboard_propriedade_pkey; Type: CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.dashboard_propriedade
    ADD CONSTRAINT dashboard_propriedade_pkey PRIMARY KEY (id);


--
-- Name: dashboard_rateiodespesa dashboard_rateiodespesa_pkey; Type: CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.dashboard_rateiodespesa
    ADD CONSTRAINT dashboard_rateiodespesa_pkey PRIMARY KEY (id);


--
-- Name: dashboard_relatoriofinanceiro dashboard_relatoriofinanceiro_pkey; Type: CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.dashboard_relatoriofinanceiro
    ADD CONSTRAINT dashboard_relatoriofinanceiro_pkey PRIMARY KEY (id);


--
-- Name: django_admin_log django_admin_log_pkey; Type: CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.django_admin_log
    ADD CONSTRAINT django_admin_log_pkey PRIMARY KEY (id);


--
-- Name: django_content_type django_content_type_app_label_model_76bd3d3b_uniq; Type: CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.django_content_type
    ADD CONSTRAINT django_content_type_app_label_model_76bd3d3b_uniq UNIQUE (app_label, model);


--
-- Name: django_content_type django_content_type_pkey; Type: CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.django_content_type
    ADD CONSTRAINT django_content_type_pkey PRIMARY KEY (id);


--
-- Name: django_migrations django_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.django_migrations
    ADD CONSTRAINT django_migrations_pkey PRIMARY KEY (id);


--
-- Name: django_session django_session_pkey; Type: CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.django_session
    ADD CONSTRAINT django_session_pkey PRIMARY KEY (session_key);


--
-- Name: auth_group_name_a6ea08ec_like; Type: INDEX; Schema: public; Owner: danielgusdev
--

CREATE INDEX auth_group_name_a6ea08ec_like ON public.auth_group USING btree (name varchar_pattern_ops);


--
-- Name: auth_group_permissions_group_id_b120cbf9; Type: INDEX; Schema: public; Owner: danielgusdev
--

CREATE INDEX auth_group_permissions_group_id_b120cbf9 ON public.auth_group_permissions USING btree (group_id);


--
-- Name: auth_group_permissions_permission_id_84c5c92e; Type: INDEX; Schema: public; Owner: danielgusdev
--

CREATE INDEX auth_group_permissions_permission_id_84c5c92e ON public.auth_group_permissions USING btree (permission_id);


--
-- Name: auth_permission_content_type_id_2f476e4b; Type: INDEX; Schema: public; Owner: danielgusdev
--

CREATE INDEX auth_permission_content_type_id_2f476e4b ON public.auth_permission USING btree (content_type_id);


--
-- Name: auth_user_groups_group_id_97559544; Type: INDEX; Schema: public; Owner: danielgusdev
--

CREATE INDEX auth_user_groups_group_id_97559544 ON public.auth_user_groups USING btree (group_id);


--
-- Name: auth_user_groups_user_id_6a12ed8b; Type: INDEX; Schema: public; Owner: danielgusdev
--

CREATE INDEX auth_user_groups_user_id_6a12ed8b ON public.auth_user_groups USING btree (user_id);


--
-- Name: auth_user_user_permissions_permission_id_1fbb5f2c; Type: INDEX; Schema: public; Owner: danielgusdev
--

CREATE INDEX auth_user_user_permissions_permission_id_1fbb5f2c ON public.auth_user_user_permissions USING btree (permission_id);


--
-- Name: auth_user_user_permissions_user_id_a95ead1b; Type: INDEX; Schema: public; Owner: danielgusdev
--

CREATE INDEX auth_user_user_permissions_user_id_a95ead1b ON public.auth_user_user_permissions USING btree (user_id);


--
-- Name: auth_user_username_6821ab7c_like; Type: INDEX; Schema: public; Owner: danielgusdev
--

CREATE INDEX auth_user_username_6821ab7c_like ON public.auth_user USING btree (username varchar_pattern_ops);


--
-- Name: dashboard_animal_propriedade_id_edc84aaa; Type: INDEX; Schema: public; Owner: danielgusdev
--

CREATE INDEX dashboard_animal_propriedade_id_edc84aaa ON public.dashboard_animal USING btree (propriedade_id);


--
-- Name: dashboard_atividade_nome_f4ab47cf_like; Type: INDEX; Schema: public; Owner: danielgusdev
--

CREATE INDEX dashboard_atividade_nome_f4ab47cf_like ON public.dashboard_atividade USING btree (nome varchar_pattern_ops);


--
-- Name: dashboard_fornecedor_cnpj_6d09a7f0_like; Type: INDEX; Schema: public; Owner: danielgusdev
--

CREATE INDEX dashboard_fornecedor_cnpj_6d09a7f0_like ON public.dashboard_fornecedor USING btree (cnpj varchar_pattern_ops);


--
-- Name: dashboard_fotopropriedade_propriedade_id_adfe6da0; Type: INDEX; Schema: public; Owner: danielgusdev
--

CREATE INDEX dashboard_fotopropriedade_propriedade_id_adfe6da0 ON public.dashboard_fotopropriedade USING btree (propriedade_id);


--
-- Name: dashboard_lancamento_colaborador_id_e2d17454; Type: INDEX; Schema: public; Owner: danielgusdev
--

CREATE INDEX dashboard_lancamento_colaborador_id_e2d17454 ON public.dashboard_lancamento USING btree (colaborador_id);


--
-- Name: dashboard_lancamento_fornecedor_id_5a244708; Type: INDEX; Schema: public; Owner: danielgusdev
--

CREATE INDEX dashboard_lancamento_fornecedor_id_5a244708 ON public.dashboard_lancamento USING btree (fornecedor_id);


--
-- Name: dashboard_pluviometria_propriedade_id_4e1fd095; Type: INDEX; Schema: public; Owner: danielgusdev
--

CREATE INDEX dashboard_pluviometria_propriedade_id_4e1fd095 ON public.dashboard_pluviometria USING btree (propriedade_id);


--
-- Name: dashboard_propriedade_cultura_principal_id_43357bdf; Type: INDEX; Schema: public; Owner: danielgusdev
--

CREATE INDEX dashboard_propriedade_cultura_principal_id_43357bdf ON public.dashboard_propriedade USING btree (cultura_principal_id);


--
-- Name: dashboard_rateiodespesa_lancamento_id_6ff73f3f; Type: INDEX; Schema: public; Owner: danielgusdev
--

CREATE INDEX dashboard_rateiodespesa_lancamento_id_6ff73f3f ON public.dashboard_rateiodespesa USING btree (lancamento_id);


--
-- Name: dashboard_relatoriofinanceiro_propriedade_id_a3118eb6; Type: INDEX; Schema: public; Owner: danielgusdev
--

CREATE INDEX dashboard_relatoriofinanceiro_propriedade_id_a3118eb6 ON public.dashboard_relatoriofinanceiro USING btree (propriedade_id);


--
-- Name: django_admin_log_content_type_id_c4bce8eb; Type: INDEX; Schema: public; Owner: danielgusdev
--

CREATE INDEX django_admin_log_content_type_id_c4bce8eb ON public.django_admin_log USING btree (content_type_id);


--
-- Name: django_admin_log_user_id_c564eba6; Type: INDEX; Schema: public; Owner: danielgusdev
--

CREATE INDEX django_admin_log_user_id_c564eba6 ON public.django_admin_log USING btree (user_id);


--
-- Name: django_session_expire_date_a5c62663; Type: INDEX; Schema: public; Owner: danielgusdev
--

CREATE INDEX django_session_expire_date_a5c62663 ON public.django_session USING btree (expire_date);


--
-- Name: django_session_session_key_c0390e0f_like; Type: INDEX; Schema: public; Owner: danielgusdev
--

CREATE INDEX django_session_session_key_c0390e0f_like ON public.django_session USING btree (session_key varchar_pattern_ops);


--
-- Name: auth_group_permissions auth_group_permissio_permission_id_84c5c92e_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.auth_group_permissions
    ADD CONSTRAINT auth_group_permissio_permission_id_84c5c92e_fk_auth_perm FOREIGN KEY (permission_id) REFERENCES public.auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_group_permissions auth_group_permissions_group_id_b120cbf9_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_group_id_b120cbf9_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES public.auth_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_permission auth_permission_content_type_id_2f476e4b_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.auth_permission
    ADD CONSTRAINT auth_permission_content_type_id_2f476e4b_fk_django_co FOREIGN KEY (content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_groups auth_user_groups_group_id_97559544_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.auth_user_groups
    ADD CONSTRAINT auth_user_groups_group_id_97559544_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES public.auth_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_groups auth_user_groups_user_id_6a12ed8b_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.auth_user_groups
    ADD CONSTRAINT auth_user_groups_user_id_6a12ed8b_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_user_permissions auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm FOREIGN KEY (permission_id) REFERENCES public.auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_user_permissions auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: dashboard_animal dashboard_animal_propriedade_id_edc84aaa_fk_dashboard; Type: FK CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.dashboard_animal
    ADD CONSTRAINT dashboard_animal_propriedade_id_edc84aaa_fk_dashboard FOREIGN KEY (propriedade_id) REFERENCES public.dashboard_propriedade(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: dashboard_fotopropriedade dashboard_fotopropri_propriedade_id_adfe6da0_fk_dashboard; Type: FK CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.dashboard_fotopropriedade
    ADD CONSTRAINT dashboard_fotopropri_propriedade_id_adfe6da0_fk_dashboard FOREIGN KEY (propriedade_id) REFERENCES public.dashboard_propriedade(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: dashboard_lancamento dashboard_lancamento_colaborador_id_e2d17454_fk_dashboard; Type: FK CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.dashboard_lancamento
    ADD CONSTRAINT dashboard_lancamento_colaborador_id_e2d17454_fk_dashboard FOREIGN KEY (colaborador_id) REFERENCES public.dashboard_colaborador(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: dashboard_lancamento dashboard_lancamento_fornecedor_id_5a244708_fk_dashboard; Type: FK CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.dashboard_lancamento
    ADD CONSTRAINT dashboard_lancamento_fornecedor_id_5a244708_fk_dashboard FOREIGN KEY (fornecedor_id) REFERENCES public.dashboard_fornecedor(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: dashboard_pluviometria dashboard_pluviometr_propriedade_id_4e1fd095_fk_dashboard; Type: FK CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.dashboard_pluviometria
    ADD CONSTRAINT dashboard_pluviometr_propriedade_id_4e1fd095_fk_dashboard FOREIGN KEY (propriedade_id) REFERENCES public.dashboard_propriedade(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: dashboard_propriedade dashboard_propriedad_cultura_principal_id_43357bdf_fk_dashboard; Type: FK CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.dashboard_propriedade
    ADD CONSTRAINT dashboard_propriedad_cultura_principal_id_43357bdf_fk_dashboard FOREIGN KEY (cultura_principal_id) REFERENCES public.dashboard_atividade(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: dashboard_rateiodespesa dashboard_rateiodesp_lancamento_id_6ff73f3f_fk_dashboard; Type: FK CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.dashboard_rateiodespesa
    ADD CONSTRAINT dashboard_rateiodesp_lancamento_id_6ff73f3f_fk_dashboard FOREIGN KEY (lancamento_id) REFERENCES public.dashboard_lancamento(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: dashboard_relatoriofinanceiro dashboard_relatoriof_propriedade_id_a3118eb6_fk_dashboard; Type: FK CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.dashboard_relatoriofinanceiro
    ADD CONSTRAINT dashboard_relatoriof_propriedade_id_a3118eb6_fk_dashboard FOREIGN KEY (propriedade_id) REFERENCES public.dashboard_propriedade(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: django_admin_log django_admin_log_content_type_id_c4bce8eb_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.django_admin_log
    ADD CONSTRAINT django_admin_log_content_type_id_c4bce8eb_fk_django_co FOREIGN KEY (content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: django_admin_log django_admin_log_user_id_c564eba6_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: danielgusdev
--

ALTER TABLE ONLY public.django_admin_log
    ADD CONSTRAINT django_admin_log_user_id_c564eba6_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- PostgreSQL database dump complete
--

\unrestrict B0ebdLhMb9GpCpdvvaLUQKjmzZOzMcZe8BIttn0hN6R1pPuqFcyzc1dumbjSgFe

