- #About dbschema information pdf#
- #About dbschema information install#
- #About dbschema information code#
swrve_os_version – the operating system version.swrve_os – the operating system of the device.swrve_language – the language of the device.swrve_ios_token – user’s Apple Push Notification Service (APNS) token.
#About dbschema information install#
#About dbschema information code#
swrve_app_store – the app store for the device.swrve_android_device_ydpi – the exact physical pixels per inch of the screen in the Y dimension.swrve_android_device_xdpi – the exact physical pixels per inch of the screen in the X dimension.milliseconds_played – accumulated milliseconds of app usage.swrve_app_version – the app version on the device, taken from the app itself.last_active – the date the user was last seen by Swrve.date_joined – the date the user was first seen by Swrve.swrve_user_id – identifier you sent to identify your user. There is a one-to-one correspondence between swrve_data_id and swrve_user_id.swrve_data_id – identifier used internally by Swrve for joining between tables.To query custom properties and other parameters, you can query these other user tables: These attributes are the same ones that are available to you in the Audience Builder. The results include common Swrve attributes like user, date joined, last_active, spend and many others. You can also download the packages from Behind the Blackboard on the Download Files page for each release.If you are using the Swrve Insights hosted solution, in the above SQL query, the table name is app_01234_swrve_properties instead of swrve_properties. You can view the Schema or Changes packages and documentation on Blackboard's repository or using the following links.
#About dbschema information pdf#
Additional commentary is also provided for key tables and columns.įor 9.1 SP 8 and later, Blackboard also provides a PDF "diff file" to detail the changes to the Open Database Schema since the previous release of Blackboard Learn. The schemas include a description of the data characteristics of the tables and columns in the Blackboard Learn database, which includes data types and sizes, nullability, index, sequence, key, and constraint information. This information is intended for intermediate to expert database administrators, as an aid to troubleshooting, capacity planning, and analytics. The Open Database Schema provides information about the Blackboard Learn database structure, including layout and table inter-dependencies. Blackboard provides the Open Database Schema for Blackboard Learn 9.1 Service Pack (SP) 1 and SP 6 and later in an HTML package in Javadoc format.