CREATE TABLE "Method"
(
    Id            INTEGER not null
        primary key autoincrement,
    Name          TEXT,
    FullComment   TEXT,
    Summary       TEXT,
    ApiCalls      TEXT,
    CommentIsXml  INTEGER,
    SampledAt     INTEGER,
    SolutionId    INTEGER,
    Lang          TEXT,
    NameTokenized TEXT
);
Method
CREATE TABLE "MethodParameter"
(
    Id       INTEGER not null
        primary key autoincrement,
    MethodId TEXT,
    Type     TEXT,
    Name     TEXT
);
MethodParameter
CREATE TABLE Repo
(
    Id            INTEGER not null
        primary key autoincrement,
    Url           TEXT,
    Stars         INTEGER,
    Forks         INTEGER,
    Watchers      INTEGER,
    ProcessedTime INTEGER
);
Repo
CREATE TABLE Solution
(
    Id            INTEGER not null
        primary key autoincrement,
    RepoId        INTEGER,
    Path          TEXT,
    ProcessedTime INTEGER,
    WasCompiled   INTEGER
);
Solution
original_column_name,column_name,column_description,data_format,value_description
Id ,,"unique id number
that identifies methods",integer,
Name ,,name of methods ,text,"the second part is the task of this method
delimited by ""."""
FullComment,Full Comment,full comment of this method,text,
Summary,Summary,summary of the method,text,
ApiCalls,Api Calls,linearized sequenced of API calls,text,
CommentIsXml,CommentIs Xml,whether the comment is XML format or not,integer,"commonsense evidence:

0: the comment for this method is not XML format.
1: the comment for this method is XML format."
SampledAt,Sampled At,the time of sampling,integer,
SolutionId,Solution Id,id number of solutions,integer,
Lang,Language,language code of method,text,
NameTokenized,Name Tokenized,tokenized name,text,
Method
original_column_name,column_name,column_description,data_format,value_description
Id,,unique id number identifying method parameters,integer,
MethodId,Method Id,,text,
Type,,type of the method,text,
Name,,name of the method,text,"commonsense evidence:

if the name is not a word like ""H"", ""z"", it means this method is not well-discriminative."
MethodParameter
,original_column_name,column_name,column_description,data_format,value_description
0,Id,,unique id to identify this solution,integer,
1,RepoId,Repository Id,id of repository,integer,
2,Path,Path,path of this solution,text,
3,ProcessedTime,Processed Time,processed time,integer,
4,WasCompiled,Was Compiled,whether this solution needs to be compiled or not,integer,"
commonsense evidence:
0: this solution needs to be compiled if user wants to implement it.
1: this solution can be implemented without needs of compilation"
Solution
original_column_name,column_name,column_description,data_format,value_description
Id,,unique id to identify repositories,integer,
Url,,github address of repository,text,
Stars,,stars this repository has received,integer,
Forks,,forks that the repository has received,integer,
Watchers,,how many watchers of this repository,integer,
ProcessedTime,Processed Time,how much processed time of downloading this repository,integer,
Repo