Store app catalog information
Data model
Fields
| Field | Type | Description |
|---|---|---|
| appfile | NVARCHAR (MAX) | Application binary file |
| appiconfile | NVARCHAR (MAX) | App icon binary file |
| avgrating | NCHAR (40) | Average App Rating |
| bundleid | NVARCHAR (1024) | Unique name of the application package |
| companydev | NVARCHAR (256) | Application developer company |
| devicecount | INT | Number of devices with the app installed |
| hasdevicecount | BIT | Determine if your app has device count |
| iconurl | NVARCHAR (1024) | App icon url |
| id* | INT | Unique identifier for an application |
| iostrackid | VARCHAR (64) | Unique identifier for an app in the Apple Store |
| isafw* | BIT | Determine if your app is approved in Android For Work |
| iscorporate | BIT | Determine if the app is corporate |
| isprivate* | BIT | Determine if the app is private |
| isprocessed | BIT | Determine if the app was processed |
| isproductive | BIT | Determines whether application consumption is marked as productive |
| issystem* | BIT | Determine if the app is system-wide |
| isvisible* | BIT | Determines whether the app is visible in the app listing |
| lastupdate | DATETIME | Date of last update of the application |
| nextupdate | DATETIME | Date of next update of the application |
| platform_id | INT | Application platform identifier. Reference to the AMDM_DEVICEPLATFORM.platf_id table |
| price | VARCHAR (16) | App Price |
| supporteddevices | NVARCHAR (4096) | Determines the list of device models that support the application |
| synchronized | BIT | Identify if the app is synced |
| urlexternal | NVARCHAR (4096) | External download url of the application binary |
| version | NVARCHAR (128) | App Version |
Primary Key
| PK_AMDMAPPSINFORMATION |
|---|
| id |