From 057d554d10d48d1c833473008f49d712116219a4 Mon Sep 17 00:00:00 2001
From: Bryan Newbold <bnewbold@robocracy.org>
Date: Wed, 10 Jul 2019 22:20:44 -0700
Subject: chocula early work

(non-functional)
---
 chocula_schema.sql | 80 ++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 80 insertions(+)
 create mode 100644 chocula_schema.sql

(limited to 'chocula_schema.sql')

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
+    );
-- 
cgit v1.2.3