> For the complete documentation index, see [llms.txt](https://colah.gitbook.io/illuminate-bi-tool-guide/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://colah.gitbook.io/illuminate-bi-tool-guide/get_started_using_bi_with_sql/learn_the_schema.md).

# Learn the Schema

To get more information about the Illuminate database, please email <help@illuminateed.com> requesting access to Schema Spy. NOTE: Illuminate does not support writing SQL queries for you. We will guide you as to where in the database specific data elements are stored.

The following schemas and/or tables are commonly used, but the schema is quite complex:

**public**

* students
* sites
* users
* terms
* sessions
* sections

**matviews**

* ss\_cube (Rostering)

  Note: Illuminate uses the second half of the academic year throughout all data. For example, 2015 is used to designate the 2014-15 school year.

**dna\_assessments** (Assessments)

**dna\_repositories** (Summary Assessments & Demographics) Note: If a new repository is created, please email <help@illuminateed.com> to have your permissions refreshed to gain ODBC access to the repositories.

**state\_data\_XX** (State Data Imports)

**national\_assessments** (NWEA, AIMSweb, SAT, ACT, etc.)

**codes** (Each code tables provide links to decode what the id's stand for within many of the tables throughout the database.)

**gradebook**

* overall\_score\_cache
* category\_score\_cache
* standards\_score\_cache
*