Open-Access-Monitor/Datenbankschema.md

@@ -2,14 +2,26 @@
 ```
 {
     "_id": <string>,
+    "doi": <string>,
     "publisher": <Publisher>,
     "journal": <Journal>,
     "year": <int?>,
     "published_date": <string>,
     "oa_color": <int?>,
-    "dim": <PublicationSourceData>,
-    "wos": <PublicationSourceData>,
-    "scopus": <PublicationSourceData>,
+    "license": <string>,
+    "source_data": <PublicationSourceData>,
+    "updated": <DateTime?>
+}
+```
+# PublicationSourceData
+```
+{
+    "source": <string>,
+    "source_id": <string>,
+    "updated": <DateTime?>,
+    "organisations": [ <Organisation>, <...> ],
+    "citation_count": <long?>,
+    "url": <string>
 }
 ```
 # PublicationCosts
@@ -18,11 +30,21 @@
     "_id": <string>,
     "publisher": <Publisher>,
     "journal": <Journal>,
-    "organisations": <Organisation>,
     "doi": <string>,
-    "year": <int>,
     "oa_color": <int?>,
     "published_date": <string>,
+    "license": <string>,
+    "source_data": [ <PublicationCostItem>, <...> ],
+    "updated": <DateTime?>
+}
+```
+# PublicationCostItem
+```
+{
+    "source": <string>,
+    "updated": <DateTime?>,
+    "organisations": <Organisation>,
+    "year": <int?>,
     "apc": <double?>,
     "colour_charges": <double?>,
     "cover": <double?>,
@@ -32,14 +54,15 @@
     "publication_charges": <double?>,
     "reprint": <double?>,
     "submission_fee": <double?>,
-    "total": <double?>,
+    "total": <double>
 }
 ```
 # Publisher
 ```
 {
     "_id": <string>,
-    "name": <sring>,
+    "updated": <DateTime?>,
+    "name": <string>,
     "oa_color": <int?>
 }
 ```
@@ -47,6 +70,7 @@
 ```
 {
     "_id": <string>,
+    "updated": <DateTime?>,
     "title": <string>,
     "oa_color": <int?>,
     "issns": [ <string>, <...> ],
@@ -54,19 +78,11 @@
     "agreements": [ <string>, <...> ]
 }
 ```
-# PublicationSourceData
-```
-{
-    "source_id": <string>,
-    "organisations": [ <Organisation>, <...> ],
-    "citation_count": <long?>,
-    "url": <string>
-}
-```
 # Organisation
 ```
 {
     "_id": <string>,
+    "updated": <DateTime?>,
     "grid_id": <string>,
     "name": <string>,
     "aliases": [ <string>, <...> ],
@@ -74,7 +90,7 @@
     "type": <string>,
     "address": <RorAddress>,
     "labels": <RorLabels>,
-    "relationships": <RorRelationship>,
+    "relationships": <RorRelation>,
     "corresponding": <bool?>
 }
 ```
@@ -99,7 +115,7 @@
     "iso639": <string>
 }
 ```
-# RorRelationship
+# RorRelation
 ```
 {
     "type": <string>,