MobileDevices
Stores records representing mobile devices that are registered to access SugarCRM. This table supports device authentication, audit logging, and mobile security enforcement.
Columns
| Name | Type | ReadOnly | Description |
| Assigned_User_Id | String | False |
The Id of the user who is assigned to this mobile device record. This assignment determines ownership and links the device to a specific SugarCRM user profile for authentication and push notification routing. |
| Assigned_User_Name | String | True |
The display name of the user who is assigned to this mobile device record. |
| Created_By | String | True |
The Id of the user who created the mobile device record. This information is used for auditing and historical tracking. |
| Created_By_Name | String | True |
The display name of the user who created the mobile device record. |
| Date_Entered | Datetime | True |
The date and time when the mobile device record was created. This timestamp indicates when the device was first registered with the system. |
| Date_Modified | Datetime | True |
The date and time when the mobile device record was last modified. This timestamp updates when device associations, status, or metadata change. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when the mobile device record is flagged as deleted. It returns a value of 'false' when the record remains active. This field supports soft-delete workflows and device unregistration. |
| Description | String | False |
A text description that provides additional context about the mobile device record. This field can include usage notes, ownership details, or internal device labeling information. |
| Device_Id | String | False |
The unique hardware or platform Identifier (Id) that is assigned to the device. This Id is typically sourced from the mobile platform and is used to identify the device in push notification routing and session validation. |
| Device_Platform | String | False |
The platform or operating system of the mobile device (for example, 'iOS' or 'Android'). This value is used to determine compatible authentication and notification protocols. |
| Following | Bool | False |
A Boolean field that returns a value of 'true' when the current user is following the mobile device record. It returns a value of 'false' when the user is not following it. Following a device enables change notifications and activity stream updates. |
| Id [KEY] | String | True |
The unique Id of the mobile device record. |
| Locked_Fields | String | True |
A system-managed list of fields that are restricted from modification. This field is used to preserve data integrity and prevent updates to protected attributes. |
| Modified_By_Name | String | True |
The display name of the user who last modified the mobile device record. |
| Modified_User_Id | String | True |
The Id of the user who last modified the mobile device record. This value supports audit trails and historical tracking. |
| My_Favorite | Bool | False |
A Boolean field that returns a value of 'true' when the mobile device record is marked as a favorite by the current user. It returns a value of 'false' when it is not marked as a favorite. This feature helps users quickly access frequently referenced device records. |
| Name | String | False |
The user-defined or system-generated name that is assigned to the mobile device record. This value is displayed in device lists and administration screens. |
| Sync_Key | String | True |
An internal synchronization key that is used to reconcile mobile device records across distributed systems and integrated environments. |