diff options
author | Bryan Newbold <bnewbold@robocracy.org> | 2019-07-10 22:20:44 -0700 |
---|---|---|
committer | Bryan Newbold <bnewbold@robocracy.org> | 2019-07-10 22:20:47 -0700 |
commit | 32179f8dd78655515eb46cb3d1024f242512976c (patch) | |
tree | 566ce9932c2eaaa02844b9dfd6908e59ac71fe90 /extra/journal_metadata/chocula_schema.sql | |
parent | d9f16664367cc42abf64fe453de16b8e9dbfe77e (diff) | |
download | fatcat-32179f8dd78655515eb46cb3d1024f242512976c.tar.gz fatcat-32179f8dd78655515eb46cb3d1024f242512976c.zip |
chocula early work
(non-functional)
Diffstat (limited to 'extra/journal_metadata/chocula_schema.sql')
-rw-r--r-- | extra/journal_metadata/chocula_schema.sql | 80 |
1 files changed, 80 insertions, 0 deletions
diff --git a/extra/journal_metadata/chocula_schema.sql b/extra/journal_metadata/chocula_schema.sql new file mode 100644 index 00000000..e03907ac --- /dev/null +++ b/extra/journal_metadata/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 + ); |