iframe-proxy | Sunbelt Computer Software

19 lines (17 loc) · 505 Bytes

CREATE SCHEMA IF NOT EXISTS `amazon` DEFAULT CHARACTER SET utf8;
USE `amazon`;
 create table if not exists reviews
    customer_id varchar(20),
    product_id varchar(10),
    marketplace char(2),
    review_body text not null,
    helpful_votes int not null,
    total_votes int not null,
    review_date datetime not null,
    review_headline varchar(10000) not null,
    product_category varchar(100),
    verified_purchase boolean,
    star_rating int,
    primary key (customer_id, product_id)

Sunbelt Computer Software

PL/B Language Development and Support

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Sunbelt Computer Software

PL/B Language Development and Support

Uh oh!

FilesExpand file tree

sql_statements.sql

Latest commit

History

sql_statements.sql

File metadata and controls