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 datatypes 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.
You can view the Schema or Changes packages directly in HTML using the following links. You can also download the packages through Behind the Blackboard on the Download Files page for each release.
|Release||Schema and Changes|
|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.