MOSIP Docs 1.1.5
GitHubCommunityTech Blogs
  • Home
  • Architecture
    • Guiding Principles
    • MOSIP Architecture
      • Technology Stack
    • MOSIP and Data
      • Naming Standards
      • Data-Model
    • Privacy & Security
      • Cryptography in MOSIP
    • Anonymous Profiling Support
  • Modules
    • Pre-Registration
      • Pre-Registration Functionality
      • UI Specification for Pre-registration
      • Pre-Registration Configuration
    • Registration
      • Registration Functionality
      • Registration Packet
      • Registration Client Setup
      • First User Registration and Onboarding
      • Guide to Configure MOSIP for Biometrics
      • Guide to On-board Biometric Devices
      • Device Integration Specifications
      • UI Specification for Registration Client
    • Registration Processor
      • Registration Processor Functionality
      • Deduplication and Manual Adjudication
      • MOSIP ID Object Definition
    • ID Repository
    • ID Authentication
      • ID Authentication Functionality
    • Resident Services
      • Resident Services Functionality
    • Partner Management
      • Partner Management Functionality
      • MOSIP Partner Secure Communication
      • Partner Self Service Portal
    • Administration
      • Admin Services Functionality
      • Download Card
    • Kernel
      • Audit Manager Functionality
        • Admin Service Audits
        • Resident Service Audits
        • Partner Management Audits
        • Registration Client Audits
        • Registration Processor Audits
        • ID Repository Audits
        • ID Authentication Audits
        • Pre-registration Audits
      • Authentication and Authorization Functionality
      • Auth Adapter
      • Auth Implementation
      • Common Services Functionality
      • Data Services Functionality
      • Master Data Services Functionality
      • UIN and VID Generation Service Functionality
      • VID Generator
  • Biometrics
    • ABIS
    • Biometric SDK
    • MDS Specification
    • Biometric Specification
    • CBEFF XML
    • Compliance Tool Kit
  • Build & Deploy
    • Sandbox Installer
    • Deployment Architectures
    • Cell Based Deployment Architecture
    • Hardware Security Module HSM Specifications
    • Hardware Sizing
    • Customizations for a Country
    • Other Installation Guides
      • Steps to Install and Configure HDFS
      • Steps to Install and use PostgreSQL Version 10.2 on RHEL 7.5
      • Steps to Install Clam AntiVirus Version 0.101.0
      • Steps to Install Keycloak Standalone Server
    • Services in MOSIP
  • Glossary
  • Contribute
    • Call for Contribution
    • Contributor's Guide
    • Code of Conduct
    • Issue Reporting Guideline
    • Coding Standards
      • Auth Angular User Guide
      • Auth SpringBoot User Guide
      • Gitub Workflow
      • MOSIP Java Coding Standards
      • MOSIP REST API guidelines
      • Registration Client UI Developer Document
      • Registration Client Developer Documentation
      • Security Tools
    • Testing
      • Test Rig Design
      • Tester Documentation
      • Testing Attachments Kernel
  • APIs
    • ABIS APIs
    • Admin APIs
    • AuthN and AuthZ APIs
    • Biometric SDK APIs
    • BlacklistedWords APIs
    • Common APIs
    • Device APIs
    • Device Type and Subtype APIs
    • Device Management APIs
    • Document APIs
    • Dynamic Fields APIs
    • Holiday APIs
    • ID Authentication APIs
    • ID Repository APIs
    • ID Schema APIs
    • Kernel APIs
    • Machine APIs
    • Master Data Biometric APIs
    • Packet APIs
    • Packet Manager APIs
    • Partner Management Service APIs
    • Pre Registration APIs
    • Registration Center APIs
    • Registration Processor APIs
    • Resident Service APIs
    • Sync Data APIs
    • Template APIs
    • Zone APIs
  • Older Releases
    • Release Notes 1.1.5
      • Enhancements
      • Defect Fixes
      • Patches
        • Patch 1.1.5.5
        • Patch 1.1.5.5-P1
    • Release Notes 1.1.4
      • Enhancements
      • Defect Fixes
    • Release Notes 1.1.3
      • Features
      • Bug Fixes
    • Release Notes 1.1.2
      • Features
      • Bug Fixes
    • Release Notes 1.1.1
      • Bug Fixes
      • Artifact Version
    • Release Notes 1.1.0
      • Features
      • Bug Fixes
      • 1.2.0 Features
      • Artifact Version
    • Release Notes 1.0.6
    • Release Notes 1.0.5
    • Release Notes 1.0.0
      • Features
    • Release Notes 0.9.0
  • Roadmap
    • Roadmap Activities
  • Revision History
  • License
Powered by GitBook
On this page
  • Data Model Considerations
  • Data Model

Was this helpful?

Export as PDF
  1. Architecture
  2. MOSIP and Data

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

PreviousNaming StandardsNextPrivacy & Security

Last updated 1 year ago

Was this helpful?