Swift MEAP Local Database Tables

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. For example Appointment (Module ID 7) would be stored in medata_7.