Data-Model

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.

Data Model Considerations

• 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

Data Model

Databases inventory in MOSIP.

Sl No	Database Name	Schema Name	Description
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