Dean
/
Bookdata-tools
mirror of https://github.com/BoiseState/bookdata-tools


  
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

	
            --- #dep common-schema
--- #table az14.raw_rating
--- #table az18.raw_review
--- #table az18.raw_book
CREATE SCHEMA IF NOT EXISTS az14;
CREATE SCHEMA IF NOT EXISTS az18;

DROP TABLE IF EXISTS az14.raw_rating CASCADE;
CREATE TABLE az14.raw_rating (
  user_key VARCHAR NOT NULL,
  asin VARCHAR NOT NULL,
  rating REAL NOT NULL,
  rating_time BIGINT NOT NULL
);

DROP TABLE IF EXISTS az18.raw_review CASCADE;
CREATE TABLE az18.raw_review (
  review_id SERIAL PRIMARY KEY,
  review_data JSONB NOT NULL
);

DROP TABLE IF EXISTS az18.raw_book CASCADE;
CREATE TABLE az18.raw_book (
  book_id SERIAL PRIMARY KEY,
  book_data JSONB NOT NULL
);