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


  
1

	
2

	
3

	
4

	
5

	
6

	
7

	
8

	
9

	
10

	
            --- #dep common-schema
CREATE SCHEMA IF NOT EXISTS az;

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