This Table Table lists the database tables that are used in the Swift MEAP™ application. \
Table Name | Table Description |
cad_apprules | Stores all the application validation rules. |
cad_context | Stores context settings from the server. |
cad_externalappscheme | Stores all external application configurations. |
cad_fieldgroups | Fields are grouped into different display groups. Information on grouping is stored in this table. |
cad_field_conditions | Contains all the field conditions, whether they are required, read only, or hide conditions. Also stores the JavaScript filters for reference objects (conditionQueryJSON). |
cad_formfields | Stores the map settings for each field, including the following: module ID, field ID, field label, type, length, default value. |
cad_implicit_ids | Stores the modules with a REFERENCE-IMPLICIT type, that are only used in Microsoft CRM. |
cad_keyword | Stores all the information related to keywords, including the following: keyword ID display value, alias information, conditional information. |
cad_lookup | Stores the fields that are enabled for lookup, listed by module. |
cad_menuitems | Stores the module settings and menu settings information, including the following: module IDs, labels, sort fields, search fields, heading information, read only and delete settings, and so on. |
cad_modulefields | Contains the menu settings and the business card settings. |
cad_moduleicons | Stores information relating to any conditional icons configured in the Swift MEAP application, including the conditional rules and icons used. |
cad_modulerules | Stores the JavaScript code. The onSave, onDelete, onOpen code is stored by module ID. |
cad_options | Stores information about the the data source Server and copy to calendar, address book, and task options displayed in Global Settings. |
cad_qsfields | Stores the parameters for all fields configured within the Quick Selector, including fields stored, length, parent and child details. |
cad_qsfilters | Stores the JavaScript used to define filters, validation, and toggle buttons for the Quick Selector. |
cad_qsmodules | Stores information about all modules with configured Quick Selectors. Contains the information defined in the list section of Quick Selector menu. |
cad_quickactions | Stores all quick action button configurations, including icon files used. |
cad_stfields | Lists all of the fields and settings used if modules are configured to be displayed in a Table Form. |
cad_stfilters | Contains the JavaScript code, which filters the information displayed in tables. |
cad_systemkeys | Stores the system keys, and their settings. |
me_addressbookuid | Stores the address book entries that have been synchronized to the native client application. If the data is removed from Swift MEAP, then this table is used to remove the data from the native application also. |
me_alertdata | Stores all the data that is displayed in the synchronization log. |
me_attachments | Stores the details of attachments, if configured. Contains signature, and will be utilized for photos in future releases. |
me_calendaruid | Stores the calendar entries that have been synchronized to the native calendar application on the user device. If data is removed from Swift MEAP, then this table is used to remove the data from the native application also. |
me_datarelation | Stores the Parent-Child relationships, including the row ID or temporary device row ID relationships, and the modules related to every record where a relationship exists. |
me_edited | Stores edited information, pending successful update to the data source. If the update permanently fails, then the data is restored from this table. |
me_geocode | Stores the latitude and longitude information for addresses. |
me_login | Stores the login details of the current user. |
me_lookup | Stores the cached lookup requests, data searched for, status and count of records returned. |
me_lookupresponse | Stores the cached lookup response from the server, including all information displayed in the lookup results page. |
me_requestqueue | Stores all the XML requests from the user device that are waiting to be sent to the server. If the user device is switched to offline mode, then you can see the exact requests queued to server. |
me_sortfields | Stores the fields and the order in which they are sorted in the application. |
me_temp | Stores the temporary packets received from the server during and initial load or update. When the packets have been downloaded to this table, they are processed in the order that they were received. |
me_uniqueid | Stores the C+ incremental value used in combination with the device PIN to calculate the devicerowid of record. |
medata_x, where x is the moduleid. | These tables are created when the CAD is received, and store all data on the user device in the corresponding module ids |
