· 8 years ago · Aug 13, 2018, 05:02 PM
1/*
2 Navicat Premium Data Transfer
3
4 Source Server : AWS - Produção - GADO
5 Source Server Type : PostgreSQL
6 Source Server Version : 90606
7 Source Host : gadoecia.cowo0uia9y9a.us-east-2.rds.amazonaws.com
8 Source Database : gadoecia
9 Source Schema : public
10
11 Target Server Type : PostgreSQL
12 Target Server Version : 90606
13 File Encoding : utf-8
14
15 Date: 08/13/2018 13:58:04 PM
16*/
17
18-- ----------------------------
19-- Table structure for lotes
20-- ----------------------------
21DROP TABLE IF EXISTS "public"."lotes";
22CREATE TABLE "public"."lotes" (
23 "id" int8 NOT NULL DEFAULT nextval('lotes_id_seq'::regclass),
24 "cliente_id" int8,
25 "gado_categoria_id" int8,
26 "gado_raca_id" int8,
27 "aceita_troca" varchar COLLATE "default",
28 "alimentacao" varchar COLLATE "default",
29 "amojando" varchar COLLATE "default",
30 "apartacao" varchar COLLATE "default",
31 "grau_de_sangue" varchar COLLATE "default",
32 "idade" int4,
33 "producao_de_leite" int4,
34 "quantidade" int4,
35 "tiragem_dia" varchar COLLATE "default",
36 "transporte" varchar COLLATE "default",
37 "created_at" timestamp(6) NOT NULL,
38 "updated_at" timestamp(6) NOT NULL,
39 "youtube_id" varchar COLLATE "default",
40 "moderado" bool,
41 "publicado" bool,
42 "sintegra_id" int8,
43 "latitude" float8,
44 "longitude" float8,
45 "valor" float8,
46 "preco_final" float8,
47 "unidade" varchar COLLATE "default",
48 "cidade" varchar COLLATE "default",
49 "estado" varchar COLLATE "default",
50 "peso_kg" varchar COLLATE "default",
51 "peso_arroba" varchar COLLATE "default",
52 "vendido" bool,
53 "pedida_minimo" int4,
54 "observacao" varchar COLLATE "default",
55 "path_img_1" varchar COLLATE "default",
56 "path_img_2" varchar COLLATE "default",
57 "path_img_3" varchar COLLATE "default",
58 "path_img_4" varchar COLLATE "default",
59 "path_img_5" varchar COLLATE "default",
60 "video_is_attached" bool,
61 "path_img_6" varchar COLLATE "default",
62 "motivo_exclusao" varchar COLLATE "default",
63 "vimeo_id" varchar COLLATE "default",
64 "cancelado" bool
65)
66WITH (OIDS=FALSE);
67ALTER TABLE "public"."lotes" OWNER TO "gadoecia";
68
69-- ----------------------------
70-- Primary key structure for table lotes
71-- ----------------------------
72ALTER TABLE "public"."lotes" ADD PRIMARY KEY ("id") NOT DEFERRABLE INITIALLY IMMEDIATE;
73
74-- ----------------------------
75-- Indexes structure for table lotes
76-- ----------------------------
77CREATE INDEX "index_lotes_on_cliente_id" ON "public"."lotes" USING btree(cliente_id "pg_catalog"."int8_ops" ASC NULLS LAST);
78CREATE INDEX "index_lotes_on_gado_categoria_id" ON "public"."lotes" USING btree(gado_categoria_id "pg_catalog"."int8_ops" ASC NULLS LAST);
79CREATE INDEX "index_lotes_on_gado_raca_id" ON "public"."lotes" USING btree(gado_raca_id "pg_catalog"."int8_ops" ASC NULLS LAST);
80CREATE INDEX "index_lotes_on_sintegra_id" ON "public"."lotes" USING btree(sintegra_id "pg_catalog"."int8_ops" ASC NULLS LAST);
81
82-- ----------------------------
83-- Foreign keys structure for table lotes
84-- ----------------------------
85ALTER TABLE "public"."lotes" ADD CONSTRAINT "fk_rails_42bb1d3b0a" FOREIGN KEY ("cliente_id") REFERENCES "public"."clientes" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION NOT DEFERRABLE INITIALLY IMMEDIATE;
86ALTER TABLE "public"."lotes" ADD CONSTRAINT "fk_rails_d143e2cf78" FOREIGN KEY ("gado_categoria_id") REFERENCES "public"."gado_categorias" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION NOT DEFERRABLE INITIALLY IMMEDIATE;
87ALTER TABLE "public"."lotes" ADD CONSTRAINT "fk_rails_a8ee064061" FOREIGN KEY ("gado_raca_id") REFERENCES "public"."gado_racas" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION NOT DEFERRABLE INITIALLY IMMEDIATE;
88ALTER TABLE "public"."lotes" ADD CONSTRAINT "fk_rails_0658e686fa" FOREIGN KEY ("sintegra_id") REFERENCES "public"."sintegras" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION NOT DEFERRABLE INITIALLY IMMEDIATE;