Changes

Page history
Update Datenbankschema authored by Pollack, Philipp's avatar Pollack, Philipp
Hide whitespace changes
Inline Side-by-side
Open-Access-Monitor/Datenbankschema.md
View page @ b2e4fb2a
...@@ -2,14 +2,26 @@ ...@@ -2,14 +2,26 @@
``` ```
{ {
"_id": <string>, "_id": <string>,
"doi": <string>,
"publisher": <Publisher>, "publisher": <Publisher>,
"journal": <Journal>, "journal": <Journal>,
"year": <int?>, "year": <int?>,
"published_date": <string>, "published_date": <string>,
"oa_color": <int?>, "oa_color": <int?>,
"dim": <PublicationSourceData>, "license": <string>,
"wos": <PublicationSourceData>, "source_data": <PublicationSourceData>,
"scopus": <PublicationSourceData>, "updated": <DateTime?>
}
```
# PublicationSourceData
```
{
"source": <string>,
"source_id": <string>,
"updated": <DateTime?>,
"organisations": [ <Organisation>, <...> ],
"citation_count": <long?>,
"url": <string>
} }
``` ```
# PublicationCosts # PublicationCosts
...@@ -18,11 +30,21 @@ ...@@ -18,11 +30,21 @@
"_id": <string>, "_id": <string>,
"publisher": <Publisher>, "publisher": <Publisher>,
"journal": <Journal>, "journal": <Journal>,
"organisations": <Organisation>,
"doi": <string>, "doi": <string>,
"year": <int>,
"oa_color": <int?>, "oa_color": <int?>,
"published_date": <string>, "published_date": <string>,
"license": <string>,
"source_data": [ <PublicationCostItem>, <...> ],
"updated": <DateTime?>
}
```
# PublicationCostItem
```
{
"source": <string>,
"updated": <DateTime?>,
"organisations": <Organisation>,
"year": <int?>,
"apc": <double?>, "apc": <double?>,
"colour_charges": <double?>, "colour_charges": <double?>,
"cover": <double?>, "cover": <double?>,
...@@ -32,14 +54,15 @@ ...@@ -32,14 +54,15 @@
"publication_charges": <double?>, "publication_charges": <double?>,
"reprint": <double?>, "reprint": <double?>,
"submission_fee": <double?>, "submission_fee": <double?>,
"total": <double?>, "total": <double>
} }
``` ```
# Publisher # Publisher
``` ```
{ {
"_id": <string>, "_id": <string>,
"name": <sring>, "updated": <DateTime?>,
"name": <string>,
"oa_color": <int?> "oa_color": <int?>
} }
``` ```
...@@ -47,6 +70,7 @@ ...@@ -47,6 +70,7 @@
``` ```
{ {
"_id": <string>, "_id": <string>,
"updated": <DateTime?>,
"title": <string>, "title": <string>,
"oa_color": <int?>, "oa_color": <int?>,
"issns": [ <string>, <...> ], "issns": [ <string>, <...> ],
...@@ -54,19 +78,11 @@ ...@@ -54,19 +78,11 @@
"agreements": [ <string>, <...> ] "agreements": [ <string>, <...> ]
} }
``` ```
# PublicationSourceData
```
{
"source_id": <string>,
"organisations": [ <Organisation>, <...> ],
"citation_count": <long?>,
"url": <string>
}
```
# Organisation # Organisation
``` ```
{ {
"_id": <string>, "_id": <string>,
"updated": <DateTime?>,
"grid_id": <string>, "grid_id": <string>,
"name": <string>, "name": <string>,
"aliases": [ <string>, <...> ], "aliases": [ <string>, <...> ],
...@@ -74,7 +90,7 @@ ...@@ -74,7 +90,7 @@
"type": <string>, "type": <string>,
"address": <RorAddress>, "address": <RorAddress>,
"labels": <RorLabels>, "labels": <RorLabels>,
"relationships": <RorRelationship>, "relationships": <RorRelation>,
"corresponding": <bool?> "corresponding": <bool?>
} }
``` ```
...@@ -99,7 +115,7 @@ ...@@ -99,7 +115,7 @@
"iso639": <string> "iso639": <string>
} }
``` ```
# RorRelationship # RorRelation
``` ```
{ {
"type": <string>, "type": <string>,
... ...
......