This is a copy of the screen-shot showing the schema of dataset-1.db

[bash xmeng@polaris lecture02-3-sql]$ sqlite3 dataset_1.db 
SQLite version 3.13.0 2016-05-18 10:57:30
Enter ".help" for usage hints.
sqlite> .schema
CREATE TABLE precipitation_full(state_code INT, station_id INT, year INT, month INT, day INT, hour INT, precipitation INT, flag_1 VARCHAR(1), flag_2 VARCHAR(1));
CREATE TABLE states(code INT, name VARCHAR(30), abbrev VARCHAR(2));
CREATE TABLE precipitation(
  station_id INT,
  day INT,
  precipitation INT
);
CREATE TABLE A(i INT, j INT, val INT);
CREATE TABLE B(i INT, j INT, val INT);
CREATE TABLE streets(id INT, direction CHAR(1), A text, B text, d INT, PRIMARY KEY (id, direction));
CREATE TABLE franchise (name TEXT, db_type TEXT);
CREATE TABLE store (franchise TEXT, location TEXT);
CREATE TABLE bagel (name TEXT, price MONEY, made_by TEXT);
CREATE TABLE purchase (bagel_name TEXT, franchise TEXT, date INT, quantity INT, purchaser_age INT);
CREATE TABLE rain_corps_assignments(
    student_id INT PRIMARY KEY,
    name VARCHAR(1000),
    station_id INT,
    state_code INT,
    start_hour INT,
    end_hour INT,
    holding_cup BOOLEAN,
    cup_size FLOAT,
    off_day INT
);
sqlite>