scrapy_monitoramento_preco_ecommerce/db_table.sql at main · tsffarias/scrapy_monitoramento_preco_ecommerce · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET default_tablespace = '';
SET default_with_oids = false;

---
--- drop tables
---


DROP TABLE IF EXISTS centauro_prices;
DROP TABLE IF EXISTS mercado_livre_prices;
DROP TABLE IF EXISTS bitcoin_prices;
DROP TABLE IF EXISTS ethereum_prices;

--
-- Name: centauro_prices; Type: TABLE; Schema: public; Owner: -; Tablespace:
--

CREATE TABLE IF NOT EXISTS centauro_prices (
  id SERIAL PRIMARY KEY,
  brand VARCHAR(100),
  name VARCHAR(300),
  old_price_reais VARCHAR(20),
  new_price_reais VARCHAR(20),
  reviews_rating_number VARCHAR(10),
  page_count INT,
  _source_name VARCHAR(100),
  _source_link TEXT,
  _data_coleta TIMESTAMP
);

--
-- Name: mercado_livre_prices; Type: TABLE; Schema: public; Owner: -; Tablespace:
--

CREATE TABLE IF NOT EXISTS mercado_livre_prices (
  id SERIAL PRIMARY KEY,
  brand VARCHAR(100),
  name VARCHAR(300),
  old_price_reais VARCHAR(20),
  new_price_reais VARCHAR(20),
  reviews_rating_number VARCHAR(10),
  page_count INT,
  _source_name VARCHAR(100),
  _source_link TEXT,
  _data_coleta TIMESTAMP
);

--
-- Name: bitcoin_prices; Type: TABLE; Schema: public; Owner: -; Tablespace:
--

CREATE TABLE IF NOT EXISTS bitcoin_prices (
    id SERIAL PRIMARY KEY,
    amount_usd NUMERIC NOT NULL,
    amount_brl NUMERIC NOT NULL,
    base VARCHAR(10) NOT NULL,
    currency VARCHAR(10) NOT NULL,
    timestamp TIMESTAMP NOT NULL
);

--
-- Name: ethereum_prices; Type: TABLE; Schema: public; Owner: -; Tablespace:
--

CREATE TABLE IF NOT EXISTS ethereum_prices (
    id SERIAL PRIMARY KEY,
    amount_usd NUMERIC NOT NULL,
    amount_brl NUMERIC NOT NULL,
    base VARCHAR(10) NOT NULL,
    currency VARCHAR(10) NOT NULL,
    timestamp TIMESTAMP NOT NULL
);