CREATE TABLE "Author"
(
    Id          INTEGER
        constraint Author_pk
            primary key,
    Name        TEXT,
    Affiliation TEXT
);
Author
CREATE TABLE "Conference"
(
    Id        INTEGER
        constraint Conference_pk
            primary key,
    ShortName TEXT,
    FullName  TEXT,
    HomePage  TEXT
);
Conference
CREATE TABLE "Journal"
(
    Id        INTEGER
        constraint Journal_pk
            primary key,
    ShortName TEXT,
    FullName  TEXT,
    HomePage  TEXT
);
Journal
CREATE TABLE Paper
(
    Id           INTEGER
            primary key,
    Title        TEXT,
    Year         INTEGER,
    ConferenceId INTEGER,
    JournalId    INTEGER,
    Keyword      TEXT,
    foreign key (ConferenceId) references Conference(Id),
    foreign key (JournalId) references Journal(Id)
);
Paper
CREATE TABLE PaperAuthor
(
    PaperId     INTEGER,
    AuthorId    INTEGER,
    Name        TEXT,
    Affiliation TEXT,
    foreign key (PaperId) references Paper(Id),
    foreign key (AuthorId) references Author(Id)
);
PaperAuthor
original_column_name,column_name,column_description,data_format,value_description
PaperId,, Paper Id,integer,
AuthorId,,Author Id,integer,"commonsense reasoning: A paper can have more than one author. Co-authorship can be derived from (paper ID, author ID) pair. "
Name,,Author Name (as written on paper),text,
Affiliation,,Author Affiliation (as written on paper),text,the name of an organization with which an author can be affiliated
PaperAuthor
original_column_name,column_name,column_description,data_format,value_description
Id,,Journal Id,integer,
ShortName,,Short name,text,
FullName,,Full name,text,
HomePage,,Homepage URL of journal,text,
Journal
original_column_name,column_name,column_description,data_format,value_description
Id,,Conference Id,integer,
ShortName,,Short name,text,
FullName,,Full name,text,
HomePage,,Homepage URL of conference,text,
Conference
original_column_name,column_name,column_description,data_format,value_description
Id,, Id of the paper,integer,
Title,,Title of the paper,text,
Year,,Year of the paper,integer,"commonsense reasoning: if the year is ""0"", it means this paper is preprint, or not published"
ConferenceId,,Conference Id in which paper was published,integer,
JournalId,,Journal Id in which paper was published,integer,"commonsense reasoning: If a paper contain ""0"" in both ConferenceID and JournalId, it means this paper is preprint"
Keyword,,Keywords of the paper ,text,"commonsense reasoning: Keywords should contain words and phrases that suggest what the topic is about. 
Similar keywords represent similar fields or sub-field. "
Paper
original_column_name,column_name,column_description,data_format,value_description
Id,,Id of the author,integer,
Name,,Author Name,text,
Affiliation,,Organization name with which the author is affiliated. ,text,the name of an organization with which an author can be affiliated
Author