Als u een Managed Hosting-klant bent, is dit onderwerp voor u niet van toepassing.

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.

The Open Database Schema provides information about the Blackboard Learn database structure, including layout and table inter-dependencies. This information is intended for intermediate to expert database administrators, as an aid to troubleshooting, capacity planning, and analytics.

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. Additional commentary is also provided for key tables and columns.

For 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.

Available schemas

You can view the Schema or Changes packages directly in HTML using the following links. You can also download the packages from Behind the Blackboard on the Download Files page for each release.

Release Schema and Changes
9.1 Q2 2019 View Schema | View Changes
9.1 Q4 2018 View Schema | View Changes
9.1 Q2 2018 View SchemaView Changes
9.1 Q4 2017 View Schema | View Changes
9.1 Q2 2017 View Schema |
9.1 Q4 2016 View Schema | View Changes
9.1 Q2 2016 View Schema | View Changes
9.1 Q4 2015 View Schema | View Changes
9.1 October 2014 View Schema | View Changes
9.1 April 2014 View Schema | View Changes
9.1 SP 14 View Schema | View Changes
9.1 SP 13 View Schema | View Changes
9.1 SP 12 View Schema | View Changes
9.1 SP 11 View Schema | View Changes
9.1 SP 10 View Schema | View Changes
9.1 SP 9 View Schema | View Changes
9.1 SP 8 View Schema | View Changes
9.1 SP 7 View Schema
9.1 SP 6 View Schema
9.1 SP 1 View Schema

What isn't included?

The Open Database Schema does not include a complete description of every database object in Blackboard Learn. The following information is not included:

  • Detailed commentary for some tables and columns.
  • No table or column information for the Xythos engine file storage schema.
  • No information about stored procedures, views, triggers, or database jobs.