Database schema

CREATE TABLE article_author (id INTEGER PRIMARY KEY, article_id INTEGER, author_id INTEGER)
CREATE TABLE article_keyword (id INTEGER PRIMARY KEY, article_id INTEGER, keyword_id INTEGER)
CREATE TABLE article_organization (id INTEGER PRIMARY KEY, article_id INTEGER,
                                   organization_id INTEGER)
CREATE TABLE articles (id INTEGER PRIMARY KEY, wos_id TEXT, title TEXT, abstract TEXT,
                       issue_id INTEGER, type TEXT, beginning_page INTEGER,
                       end_page INTEGER, page_count INTEGER, language TEXT)
CREATE TABLE authors (id INTEGER PRIMARY KEY, name TEXT)
CREATE TABLE citations (id INTEGER PRIMARY KEY, orig_id INTEGER, targ_id INTEGER,
                        orig_wosid TEXT, targ_wosid TEXT)
CREATE TABLE issues (id INTEGER PRIMARY KEY, wos_id TEXT, pub_id INTEGER, year INTEGER,
                     date TEXT, volume INTEGER, issue INTEGER, timestamp REAL)
CREATE TABLE keywords (id INTEGER PRIMARY KEY, keyword TEXT)
CREATE TABLE organizations (id INTEGER PRIMARY KEY, name TEXT, city TEXT,
                            province_state TEXT, country TEXT, postal_code TEXT)
CREATE TABLE publications (id INTEGER PRIMARY KEY, title TEXT, iso_title TEXT,
                           type TEXT, ISSN TEXT)