diff options
Diffstat (limited to 'chocula_schema.sql')
-rw-r--r-- | chocula_schema.sql | 80 |
1 files changed, 80 insertions, 0 deletions
diff --git a/chocula_schema.sql b/chocula_schema.sql new file mode 100644 index 0000000..e03907a --- /dev/null +++ b/chocula_schema.sql @@ -0,0 +1,80 @@ + + +CREATE TABLE IF NOT EXISTS journal_summary + (issnl TEXT NOT NULL PRIMARY KEY, + issne TEXT, + issnp TEXT, + country TEXT, + lang TEXT, + langs TEXT, + publisher_type TEXT, + is_active BOOLEAN, + is_oa BOOLEAN default false, + is_longtail BOOLEAN default false, + vor_pdf BOOLEAN, + vor_html BOOLEAN, + vor_jats BOOLEAN, + has_dois BOOLEAN, + any_live_homepage BOOLEAN, + any_preservation BOOLEAN, + any_ia BOOLEAN + ); + +CREATE TABLE IF NOT EXISTS journal_index + (issnl TEXT NOT NULL, + slug TEXT NOT NULL, + identifier TEXT, + name TEXT, + work_count INTEGER, + extra TEXT, + PRIMARY KEY(issnl, slug) + ); + +CREATE TABLE IF NOT EXISTS fatcat_container + (issnl TEXT NOT NULL PRIMARY KEY, + ident TEXT NOT NULL, + revision TEXT NOT NULL, + name TEXT, + container_type TEXT, + publisher TEXT, + country TEXT, + lang TEXT, + release_count INTEGER, + ia_count INTEGER, + ia_frac float, + kbart_count INTEGER, + kbart_frac float + ); + +CREATE TABLE IF NOT EXISTS homepage + (id INTEGER PRIMARY KEY, + issnl TEXT NOT NULL, + surt TEXT NOT NULL, + url TEXT NOT NULL, + host TEXT NOT NULL, + domain TEXT NOT NULL, + suffix TEXT NOT NULL, + status_code INTEGER, + terminal_url TEXT, + terminal_status_code INTEGER, + platform_software TEXT, + scope TEXT, + has_issn BOOLEAN, + blocked BOOLEAN, + UNIQUE(issnl, surt) + ); + +CREATE TABLE IF NOT EXISTS fulltext_pattern + (id INTEGER PRIMARY KEY, + issnl TEXT NOT NULL, + surt_glob TEXT, + mimetype TEXT, + state_date TEXT, + end_date TEXT + ); + +CREATE TABLE IF NOT EXISTS title + (id INTEGER PRIMARY KEY, + issnl TEXT NOT NULL, + title TEXT NOT NULL + ); |