Entity Relationship Diagram Schema - Inventory


This document explains the database schema of the Inventory module used by Mobile Device Manager Plus.

Database Details

Database Details such as data type, storage format, and data description is explained in this document.

Supported Databases

  • Postgres SQL
  • MS SQL (2005 and higher versions)

Table Details

  • CustomerInfo : Contains information about all the customers available in MDM.
  • Resource : Contains information about all the resources available in MDM.
  • ManagedDevice : Contains list of all the devices managed by MDM.
  • ManagedDeviceExtn : It is the extension of ManagedDevice table and holds additional information about managed devices.
  • ManagedUser : Contains information about users whose devices are managed using MDM.
  • ManagedUserToDevice : Contains details about all the users and the managed devices available in MDM.
  • MDSecurityInfo : Contains information about all security related configurations available for the devices.
  • MDSIMinfo : Contains SIM information of all devices available in MDM.
  • MDDeviceInfo : Contains information of all devices available in MDM.
  • MDModelInfo : Contains Model info of all devices available in MDM.
  • MDDeviceScanStatus :Contains details of device scans.
  • MDDeviceStatusToErrCode : Contains the details of device status related error codes.
  • ErrorCodeToKBURL : Contains the solution to the device status codes.
  • AgentContact : Contains the agent contact details.