CREATE TABLE "station"
(
    id                INTEGER not null
        primary key,
    name              TEXT,
    lat               REAL,
    long              REAL,
    dock_count        INTEGER,
    city              TEXT,
    installation_date TEXT
);
station
CREATE TABLE "status"
(
    station_id      INTEGER,
    bikes_available INTEGER,
    docks_available INTEGER,
    time            TEXT
);
status
CREATE TABLE "trip"
(
    id                 INTEGER not null
        primary key,
    duration           INTEGER,
    start_date         TEXT,
    start_station_name TEXT,
    start_station_id   INTEGER,
    end_date           TEXT,
    end_station_name   TEXT,
    end_station_id     INTEGER,
    bike_id            INTEGER,
    subscription_type  TEXT,
    zip_code           INTEGER
);
trip
CREATE TABLE "weather"
(
    date                           TEXT,
    max_temperature_f              INTEGER,
    mean_temperature_f             INTEGER,
    min_temperature_f              INTEGER,
    max_dew_point_f                INTEGER,
    mean_dew_point_f               INTEGER,
    min_dew_point_f                INTEGER,
    max_humidity                   INTEGER,
    mean_humidity                  INTEGER,
    min_humidity                   INTEGER,
    max_sea_level_pressure_inches  REAL,
    mean_sea_level_pressure_inches REAL,
    min_sea_level_pressure_inches  REAL,
    max_visibility_miles           INTEGER,
    mean_visibility_miles          INTEGER,
    min_visibility_miles           INTEGER,
    max_wind_Speed_mph             INTEGER,
    mean_wind_speed_mph            INTEGER,
    max_gust_speed_mph             INTEGER,
    precipitation_inches           TEXT,
    cloud_cover                    INTEGER,
    events                         TEXT,
    wind_dir_degrees               INTEGER,
    zip_code                       TEXT
);
weather
original_column_name,column_name,column_description,data_format,value_description
date,,,text,
max_temperature_f,max temperature in Fahrenheit degree,max temperature in Fahrenheit degree,integer,"commonsense evidence:
It represents the hottest temperature."
mean_temperature_f,mean temperature in Fahrenheit degree,mean temperature in Fahrenheit degree,integer,
min_temperature_f,min temperature in Fahrenheit degree,min temperature in Fahrenheit degree,integer,"commonsense evidence:
It represents the coldest temperature."
max_dew_point_f,max dew point in Fahrenheit degree ,max dew point in Fahrenheit degree ,integer,
mean_dew_point_f,mean dew point in Fahrenheit degree ,mean dew point in Fahrenheit degree ,integer,
min_dew_point_f,min dew point in Fahrenheit degree ,min dew point in Fahrenheit degree ,integer,
max_humidity,max humidity,max humidity,integer,
mean_humidity,mean humidity,mean humidity,integer,
min_humidity,min humidity,min humidity,integer,
max_sea_level_pressure_inches,max sea level pressure in inches,max sea level pressure in inches,real,
mean_sea_level_pressure_inches,mean sea level pressure in inches,mean sea level pressure in inches,real,
min_sea_level_pressure_inches,min sea level pressure in inches,min sea level pressure in inches,real,
max_visibility_miles,max visibility in miles,max visibility in miles,integer,
mean_visibility_miles,mean visibility in miles,mean visibility in miles,integer,
min_visibility_miles,min visibility in miles,min visibility in miles,integer,
max_wind_Speed_mph,max wind Speed in mph,max wind Speed in mph,integer,
mean_wind_speed_mph,mean wind Speed in mph,mean wind Speed in mph,integer,
max_gust_speed_mph,max gust Speed in mph,max gust Speed in mph,integer,
precipitation_inches,precipitation in inches,precipitation in inches,text,
cloud_cover,cloud cover,cloud cover,integer,
events,,,text,"Allowed input: [null], Rain, other"
wind_dir_degrees,wind direction degrees,wind direction degrees,integer,
zip_code,zip code,zip code,text,
weather
original_column_name,column_name,column_description,data_format,value_description
id,,,integer,
duration,,The duration of the trip in seconds.,integer,"commonsense evidence:
duration = end_date - start_date "
start_date,start date,start date,text,
start_station_name,start station name,The name of the start station,text,"commonsense evidence:
It represents the station name the bike borrowed from."
start_station_id,start station id,The ID of the start station,integer,
end_date,end date,end date,text,
end_station_name,end station name,The name of the end station,text,"commonsense evidence:
It represents the station name the bike returned to."
end_station_id,end station id,The ID of the end station,integer,
bike_id,bike id,The ID of the bike,integer,
subscription_type,subscription type,subscription type,text,"Allowed input: Subscriber, Customer."
zip_code, zip code,zip code,integer,
trip
original_column_name,column_name,column_description,data_format,value_description
id,,unique ID for each station,integer,
name,,Station name,text,
lat,latitude,latitude,real,"commonsense evidence:
Can represent the location of the station when combined with longitude."
long,longitude,longitude,real,"commonsense evidence:
Can represent the location of the station when combined with 
latitude."
dock_count,dock count,number of bikes the station can hold,integer,
city,,,text,
installation_date,installation date,installation date,text,
station
original_column_name,column_name,column_description,data_format,value_description
station_id,station id,station id,integer,
bikes_available,,number of available bikes,integer,"commonsense evidence:
0 means no bike can be borrowed."
docks_available,,number of available docks,integer,"commonsense evidence:
0 means no bike can be returned to this station."
time,,,text,
status