Skip to main content

IDM Database Details

IDM configured in project wise and each project has following collections to store the IDM related documents.

The project wise means, each project has its database and each database has its set of default collections which contains following IDM related collections.

  1. IDM_Repository

  2. IDM_PermissionManagement

  3. IDM_permissionRepoMapping

  4. IDM_PermissionRoleMapping

Source and consumer details of IDM

The source or UI of IDM was client projects ie) ipmo, survillance, clmm etc.

The IDM consumes IDM Services, IDM Services was a java spring boot application which consist set of APIs.

Then, IDM Services internally call the arango adapter API for to perform CRUD operation in arangodb.

Collections with details

Collection NameUsage
IDM_Repository This collection used to store the access repository ie) pages, access lists
IDM_permissionManagement This collection used to store the permission for set of repository
IDM_permissionRepoMapping This collection used to store the access rights (read, write, delete) for the permission
IDM_permissionRoleMapping This collection used to store the role and each role was mapped with permission and each permission mapped with permission access rights.

Collection attributes with details

Collection Name: IDM_Repository

AttributesUsage
clientid This attribute used to store the clientid.
projectid This attribute used to stote the projectid
metadataid This attribute used to store the IDM tool metadataid
rep_id This attribute used to store the unique repositoryid(UUID)
rep_name This attribute used to store the repostitory name
rep_type This attribute used to store the repo type
isactive This attribute stores the boolean value which makes repository active and inactive.
Parent_rep This attribure denote the parent repository for the particular repository.
route_url This attribute store the navigation url for the particular repository.
unique_id

Collection Name: IDM_permissionManagement

AttributesUsage
clientid This attribute used to store the clientid.
projectid This attribute used to stote the projectid
metadataid This attribute used to store the IDM tool metadataid
permsnid This attribute stores the permission uniqueid(UUID)
permsnname This attribute store the permission unique name
permsn_repo This attribute stores the multiple permission repo, which refers the IDM_permissionRepoMapping documents which has the access rights(read, write, delete) for the repository
status This attribute stores the boolean value which makes repository active and inactive.

Collection Name: IDM_permissionRepoMapping

AttributesUsage
repoid This attribute stores the IDM_Repository document _id.
permsnread This attribute is a boolean type, it enables read access to the mentioned repository.
permsnwrite This attribute is a boolean type, it enables write access to the mentioned repository.
permsnupdate This attribute is a boolean type, it enables update access to the mentioned repository.
permsndelete This attribute is a boolean type, it enables delete access to the mentioned repository.

Collection Name: IDM_permissionRoleMapping

AttributesUsage
clientid This attribute used to store the clientid.
projectid This attribute used to stote the projectid
metadataid This attribute used to store the IDM tool metadataid
id This attribute stores the document uniqueid(UUID)
roleid This attribute stores the role uniqueid
rolename This attribute stores the unique role name.
perrolepermsnid This attribute stores the multiple permissionid which refers the IDM_permissionManagement document _id.

Production Collection

IDM_Repository

IDM_PermissionManagement

IDM_permissionRepoMapping

IDM_PermissionRoleMapping

Dependency for IDM

The IDM datas/documents stored in above mentioned collections.

The IDM UI calls arango adapter API for to perform CRUD operations in arangodb server.