CREATE TABLE location
(
    LocationID INTEGER
        constraint location_pk
            primary key,
    Country    TEXT,
    State      TEXT,
    StateCode  TEXT,
    City       TEXT
);
location
CREATE TABLE user
(
    UserID TEXT
        constraint user_pk
            primary key,
    Gender TEXT
);
user
CREATE TABLE twitter
(
    TweetID         TEXT
            primary key,
    Weekday         TEXT,
    Hour         INTEGER,
    Day          INTEGER,
    Lang         TEXT,
    IsReshare    TEXT,
    Reach        INTEGER,
    RetweetCount INTEGER,
    Likes        INTEGER,
    Klout        INTEGER,
    Sentiment    REAL,
    "text"         TEXT,
    LocationID   INTEGER,
    UserID       TEXT,
    foreign key (LocationID) references location(LocationID),
    foreign key (UserID) references user(UserID)
);
twitter
original_column_name,column_name,column_description,data_format,value_description
LocationID,location id,unique id of the location,integer,
Country,,the country,text,
State,,the state,text,
StateCode,state code,state code,text,
City,,the city,text,
location
original_column_name,column_name,column_description,data_format,value_description
UserID,user id,the unique id of the user,text,
Gender,,user's gender,text,Male / Female / Unknown
user
original_column_name,column_name,column_description,data_format,value_description
TweetID,tweet id,the unique id of the tweet,text,
Weekday,,the weekday that the tweet has been posted,text,
Hour,,the hour that the tweet has been posted,integer,
Day,,the day that the tweet has been posted,integer,
Lang,language,the language of the tweet,text,
IsReshare,is reshare,whether the tweet is reshared,text,"commonsense evidence:
A reshared tweet is when someone reshares or forwards a post to their own Twitter 
	true: the tweet is reshared
	false: the tweet isn't reshared"
Reach,,the reach of the tweet,integer,"commonsense evidence:
reach counts the number of unique users who have seen your tweet"
RetweetCount,retweet count,the retweet count,integer,
Likes,,the number of likes ,integer,
Klout,,the klout of the tweet,integer,
Sentiment,,the sentiment of the tweet,real,"commonsense evidence:
	>0: the sentiment of the tweet is positive. 
	=0: the sentiment of the tweet is neutral.
	<0: the sentiment of the tweet is negative. "
text,,the text of the tweet,text,
LocationID,location id,the location id of the poster,integer,
UserID,user id,the user id of the poster,integer,
twitter