CREATE TABLE cites
(
    cited_paper_id  TEXT not null,
    citing_paper_id TEXT not null,
    primary key (cited_paper_id, citing_paper_id)
);
cites
CREATE TABLE paper
(
    paper_id    TEXT  not null
        primary key,
    class_label TEXT not null
);
paper
CREATE TABLE content
(
    paper_id     TEXT not null,
    word_cited_id TEXT not null,
    primary key (paper_id, word_cited_id),
    foreign key (paper_id) references paper(paper_id)
);
content
original_column_name,column_name,column_description,data_format,value_description
paper_id,paper id,unique string ID of the paper,text,unique string ID of the paper
word_cited_id,word cited id,rtype,text,whether each word in the vocabulary is present (indicated by 1) or absent (indicated by 0) in the paper
content
original_column_name,column_name,column_description,data_format,value_description
cited_paper_id,,cited_paper_id is the ID of the paper being cited,text,cited_paper_id is the ID of the paper being cited
citing_paper_id,,citing_paper_id stands for the paper which contains the citation,text,citing_paper_id stands for the paper which contains the citation
cites
original_column_name,column_name,column_description,data_format,value_description
paper_id,paper id,unique string ID of the paper,text,unique string ID of the paper
class_label,class label,,text,
paper