This section contains details related to MOSIP data model design.The section also provides the data dictionary of the tables and columns defined by MOSIP databases.
Meaningful Naming: DB objects that are being created will have a meaningful naming.
Flexible model: No business rules are set at the database level other than few mapping data. Most of the business logic is applied at application layer.
Database specific features: Use of DB specific features like defaults, DB sequences, identify fields are not used
No business logic at DB: No business logic implemented at database level other than PK, UK, FKs.
Data Security: Individual and security related information is encrypted
Databases inventory in MOSIP.
1
mosip_kernel
kernel
Kernel database store security key details, data related to kernel services like sync process, OTP, etc.
2
mosip_master
master
All the master data defined by a country / organization is maintained in mosip_master database.
3
mosip_idrepo
idrepo
ID repository database stores all the data related to an individual for which an UIN is generated.
4
mosip_prereg
prereg
Pre-registration database to store the data that is captured as part of pre-registration process and appointments booking.
5
mosip_reg
reg
Registration client database to capture registration related data. The needed data from MOSIP system will be synched with this database.
6
mosip_regprc
regprc
The data related to Registration process flows and transaction will be maintained in this database.
7
mosip_ida
ida
ID Authentication related requests, transactions will be stored in this database
8
mosip_audit
audit
Audit related logs collected from all modules are stored in this database
9
mosip_credential
credential
Credential request from MOSIP applications related entities and its data is stored in this database
10
mosip_idmap
idmap
Database to store and manage all the data related to mapping between various IDs, like vid with UIN of an individual
11
mosip_keymgr
keymgr
Key Manager database maintains common system configurations, data related to key services like encryption, decryption keys, certificates..etc
12
mosip_regdevice
regdevice
Database to store all registration device management data, look-up data, configuration data, metadata...etc.
13
mosip_authdevice
authdevice
Database to store all partner authentication device management data, look-up data, configuration data, metadata...etc
14
mosip_pms
pms
Partner Management Service related entities and its data is stored in this database