MODKBEKBJ-330 - Getting issue details... STATUS
IN PROGRESS
Goal: Investigate if there is an association between a logged-in user and the institution the user belongs to.
To understand the link between the institution and user, let's visualize table connections
This tool can not analyze the `jsonb` column, unfortunately, so the next steps require a manual review of schemas.
So, the schema for `location` contains following properties:
{
"$schema": "http://json-schema.org/draft-04/schema#",
"description": "A (shelf) location, the forth-level location unit below institution, campus, and library.",
"type": "object",
"properties":
,
"additionalProperties": false,
"required": [
"name",
"code",
"institutionId",
"campusId",
"libraryId",
"primaryServicePoint"
]
}
And as we see the most interesting part from the spike point is `servicePointIds` property, which leads us to two other schemas : `service-point` and `service-point-user`
Let's see `servicepointsuser.json`
{
"$schema": "http://json-schema.org/draft-04/schema#",
"description": "The list of service points a user is allowed to work at, and the default service point for that user.",
"type": "object",
"properties":
,
"additionalProperties": false,
"required": [
"userId"
]
}
and here we can find an `userId` of user and can say that connection is following: