diff options
| -rw-r--r-- | proposals/20190911_v05_schema_tweaks.md (renamed from proposals/20190911_v04_schema_tweaks.md) | 9 | ||||
| -rw-r--r-- | proposals/20211012_v04_schema_tweaks.md | 30 |
2 files changed, 35 insertions, 4 deletions
diff --git a/proposals/20190911_v04_schema_tweaks.md b/proposals/20190911_v05_schema_tweaks.md index 8e61bf36..46d7c489 100644 --- a/proposals/20190911_v04_schema_tweaks.md +++ b/proposals/20190911_v05_schema_tweaks.md @@ -7,23 +7,24 @@ Proposed schema changes for next fatcat iteration (v0.4? v0.5?). SQL (and API, and elasticsearch): -- container:`container_status` as a string enum: eg, "stub", - "out-of-print"/"ended" (?), "active", "new"/"small" (?). Particularly to - deal with disambiguation of multiple containers by the same title but - separate ISSN-L. For example, "The Lancet". +- `db_get_range_for_editor` is slow when there are many editgroups for editor; add sorted index? meh. - release: `release_month` (to complement `release_date` and `release_year`) - file: `file_scope` as a string enum indicating how much content this file includes. Eg, `book`, `chapter`, `article`/`work`, `issue`, `volume`, `abstract`, `component`. Unclear how to initialize this field; default to `article`/`work`? +- file: some way of marking bad/bogus files... by scope? type? status? - TODO: webcapture: lookup by primary URL sha1? - TODO: release: switch how pages work? first/last? - TODO: indication of peer-review process? at release or container level? - TODO: container: separate canonical and disambiguating titles (?) - TODO: container: "imprint" field? +- TODO: container: "series" field? eg for conferences - TODO: release inter-references using SCHOLIX/Datacite schema https://zenodo.org/record/1120265 https://support.datacite.org/docs/connecting-research-outputs#section-related-identifiers +- TODO: fileset: some sort of lookup; hashes of hashes? +- TODO: fileset: some indication/handling of git repositories API tweaks: diff --git a/proposals/20211012_v04_schema_tweaks.md b/proposals/20211012_v04_schema_tweaks.md new file mode 100644 index 00000000..15ca489e --- /dev/null +++ b/proposals/20211012_v04_schema_tweaks.md @@ -0,0 +1,30 @@ + +Status: implemented + +## Schema Changes for v0.4 + +Small SQL and API changes. Calling these a minor-level API version increment. + +API Schema Changes: + +- release `ext_ids`: `hdl` (handle) identifier +- fileset: `mimetype` for manifest files as a field. This is a SQL schema change as well. +- container: `issne` and `issnp` as top-level fields, indexed for lookup. SQL + schema change. +- container: `publication_status` as a top-level field, to indicate "active", + "discontinued", etc. SQL schema change. + +API Endpoints: + +- `GET /editor/lookup`: editor lookup by username + +Elasticsearch Schemas: + +- release: 'hdl' identifier +- release: `container_publication_status` and `container_issns` +- release: add missing `version` field (not related to any API change) +- release: add `tags` for future extensibility +- release: `is_work_alias` boolean flag for unversioned releases which point + to the overall work, or the latest published version of the work. Included + from field with the same name in release `extra`. +- container: `publication_status` |