Entity Relationship Diagram Schema - Content Management

Overview

This document explains the database schema of the Content Management 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

• Resource - Contains information about all the resources available in MDM.
• ManagedDevice - Contains a list of all the devices managed by MDM.
• MdDeviceInfo - Contains information of all devices available in 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.
• IOSNativeAppStatus - Contains details about all the users and managed devices available in MDM.
• DocumentManagedDeviceRel - Contains the mappings between a document and a device.
• DocumentManagedDeviceInfo - Contains the mapping status between a document and a device.
• ConfigStatusDefn - Contains static info of various statuses.