CREATE TABLE runs (
        run_at text not null,
        max_rowid integer not null,
        reviews_added integer not null
    );
runs
CREATE TABLE podcasts (
        podcast_id text primary key,
        itunes_id integer not null,
        slug text not null,
        itunes_url text not null,
        title text not null
    );
podcasts
CREATE TABLE "reviews"
(
    podcast_id TEXT    not null
        constraint reviews_podcasts_podcast_id_fk
            references podcasts,
    title      TEXT    not null,
    content    TEXT    not null,
    rating     INTEGER not null,
    author_id  TEXT    not null,
    created_at TEXT    not null
);
reviews
CREATE TABLE "categories"
(
    podcast_id TEXT not null
        constraint categories_podcasts_podcast_id_fk
            references podcasts,
    category   TEXT not null,
    constraint "PRIMARY"
        primary key (podcast_id, category)
);
categories
original_column_name,column_name,column_description,data_format,value_description
run_at,run at,The date and time of the podcast review creation.,text,
max_rowid,max row id,The id of max row of this run.,integer,
reviews_added,reviews added,The number of reviews added in this run.,integer,
runs
original_column_name,column_name,column_description,data_format,value_description
podcast_id,podcast id,The unique id of the podcast ,text,
itunes_id,itunes id,The unique id of the itunes.,integer,
slug,,The slug of the podcast.,text,"commonsense evidence: 
It usually has the same name with the ""title"" column. "
itunes_url,itunes url,The iTunes url of the podcast.,text,"commonsense evidence: 
Can visit the webpage of the podcast by clicking the itunes_url."
title,,The title of the podcast.,text,"commonsense evidence: 
It usually has a very similar name to the ""slug"" column. "
podcasts
original_column_name,column_name,column_description,data_format,value_description
podcast_id,podcast id,The unique id of the podcast ,text,
title,,The title of the podcast review.,text,"commonsense evidence: 
This usually is the abstract of the whole review."
content,,The content of the podcast review.,text,"commonsense evidence: 
This usually is the detailed explanation of the podcast review title."
rating,,The rating of the podcast review.,integer,"commonsense evidence: 
Allowed values: 0 to 5. 
This rating is highly related with ""title"" and ""content""."
author_id,author id,The author id of the podcast review.,text,
created_at,created at,The date and time of the podcast review creation.,text,"In the format of ""Date time"". e.g., 2018-05-09T18:14:32-07:00"
reviews
original_column_name,column_name,column_description,data_format,value_description
podcast_id,podcast id,The unique id of the podcast ,text,
category,,category of the podcast,text,"commonsense evidence: 
This usually represents the topic of the podcast."
categories