Planned changes in Circulation request DB schema
| Current DB record structure (segments to be removed are in orange) | Proposed DB record structure (segments to be added are in green) |
|---|---|
{ "id": "9c8583f1-8631-4194-a477-572d342cdd4d", "item": { "title": "A semantic web primer", "barcode": "10101", "identifiers": [ { "value": "0262012103", "identifierTypeId": "8261054f-be78-422d-bd51-4ed9f33c3422" }, { "value": "9780262012102", "identifierTypeId": "8261054f-be78-422d-bd51-4ed9f33c3422" }, { "value": "2003065165", "identifierTypeId": "c858e4f2-2b6b-4385-842b-60732ee14abb" } ] }, "itemId": "7212ba6a-8dcf-45a1-be9a-ffaa847c4423", "status": "Open - Not yet filled", "metadata": { "createdDate": "2021-09-09T13:14:43.756", "updatedDate": "2021-09-09T13:14:43.756+00:00", "createdByUserId": "c2d3902a-3454-50ea-998f-42897e32ac5f", "updatedByUserId": "c2d3902a-3454-50ea-998f-42897e32ac5f" }, "position": 1, "requester": { "barcode": "10001", "lastName": "Kurash", "firstName": "Alexander" }, "requestDate": "2021-09-09T13:14:41.000+00:00", "requestType": "Hold", "requesterId": "27bc1f87-8c08-437a-be09-1df885262497", "fulfilmentPreference": "Hold Shelf", "pickupServicePointId": "3a40852d-49fd-4df2-a1f9-6e2641a6e91f" } | { "id": "9c8583f1-8631-4194-a477-572d342cdd4d", "requestLevel": "Item", "instanceId": "5bf370e0-8cca-4d9c-82e4-5170ab2a0a39", "instance": { "title": "A semantic web primer", "identifiers": [ { "value": "0262012103", "identifierTypeId": "8261054f-be78-422d-bd51-4ed9f33c3422" }, { "value": "9780262012102", "identifierTypeId": "8261054f-be78-422d-bd51-4ed9f33c3422" }, { "value": "2003065165", "identifierTypeId": "c858e4f2-2b6b-4385-842b-60732ee14abb" } ] }, "item": { "barcode": "10101" }, "itemId": "7212ba6a-8dcf-45a1-be9a-ffaa847c4423", "status": "Open - Not yet filled", "metadata": { "createdDate": "2021-09-09T13:14:43.756", "updatedDate": "2021-09-09T13:14:43.756+00:00", "createdByUserId": "c2d3902a-3454-50ea-998f-42897e32ac5f", "updatedByUserId": "c2d3902a-3454-50ea-998f-42897e32ac5f" }, "position": 1, "requester": { "barcode": "10001", "lastName": "Kurash", "firstName": "Alexander" }, "requestDate": "2021-09-09T13:14:41.000+00:00", "requestType": "Hold", "requesterId": "27bc1f87-8c08-437a-be09-1df885262497", "fulfilmentPreference": "Hold Shelf", "pickupServicePointId": "3a40852d-49fd-4df2-a1f9-6e2641a6e91f" } |
Planned API changes
API endpoint: /circulation/requests
Note that item field has some additional instance-related values that will also be moved to the instance field.
| Current JSON structure (segments to be removed are in orange) | Proposed JSON structure (segments to be added are in green) |
|---|---|
|
|
Proposed JSON structure for request from UI side
{
"id": "df45dc97-32c9-458f-9b32-2c1ea8e73159",
"requestLevel": "Item",
"requestType": "Hold",
"fulfilmentPreference": "Hold Shelf",
"item": {
"barcode": "90000"
},
"itemId": "100d10bf-2f06-4aa0-be15-0b95b2d9f9e3",
"requester": {
"barcode": "11111"
},
"requestDate": "2021-10-19T12:54:47Z",
"requesterId": "503ea8a5-fdd0-4c7a-b38d-9bdf2368f869",
"pickupServicePointId": "3a40852d-49fd-4df2-a1f9-6e2641a6e91f",
"instanceId": "5bf370e0-8cca-4d9c-82e4-5170ab2a0a39"
}