<style>p { margin: 0; }span.fr-emoticon.fr-emoticon-img { background-repeat: no-repeat !important; font-size: inherit; height: 1em; width: 1em; min-height: 20px; min-width: 20px; display: inline-block; margin: -0.1em 0.1em 0.1em; line-height: 1; vertical-align: middle; } span.fr-emoticon { font-weight: normal; font-family: "Apple Color Emoji", "Segoe UI Emoji", "NotoColorEmoji", "Segoe UI Symbol", "Android Emoji", "EmojiSymbols"; display: inline; line-height: 0; } blockquote { border-left: solid 2px #5e35b1; color: #5e35b1; margin-left:0; padding-left:5px;}blockquote blockquote{ border-color: #00bcd4; color: #00bcd4;}blockquote blockquote blockquote{ border-color: #43a047; color: #43a047;} table.grid{ border-collapse: collapse;} table.grid td, table.grid th { border: 1px solid #ddd;} .fr-fic.fr-dib{ display: block; margin: 5px auto;}.fr-fic.fr-dib.fr-fir{ text-align: right; margin: 5px 0 5px auto;}.fr-fic.fr-dib.fr-fil{ text-align: left; margin: 5px auto 5px 0;}</style><p><br></p>
<style>p { margin: 0; }span.fr-emoticon.fr-emoticon-img { background-repeat: no-repeat !important; font-size: inherit; height: 1em; width: 1em; min-height: 20px; min-width: 20px; display: inline-block; margin: -0.1em 0.1em 0.1em; line-height: 1; vertical-align: middle; } span.fr-emoticon { font-weight: normal; font-family: "Apple Color Emoji", "Segoe UI Emoji", "NotoColorEmoji", "Segoe UI Symbol", "Android Emoji", "EmojiSymbols"; display: inline; line-height: 0; } blockquote { border-left: solid 2px #5e35b1; color: #5e35b1; margin-left:0; padding-left:5px;}blockquote blockquote{ border-color: #00bcd4; color: #00bcd4;}blockquote blockquote blockquote{ border-color: #43a047; color: #43a047;} table.grid{ border-collapse: collapse;} table.grid td, table.grid th { border: 1px solid #ddd;} .fr-fic.fr-dib{ display: block; margin: 5px auto;}.fr-fic.fr-dib.fr-fir{ text-align: right; margin: 5px 0 5px auto;}.fr-fic.fr-dib.fr-fil{ text-align: left; margin: 5px auto 5px 0;}</style><p><strong>In this guide we will cover:</strong></p><p><a href="#The-Halo-Schema"><strong>- The Halo Schema</strong></a></p><p><a href="#Using-the-Schema"><strong>- Using the Schema</strong></a></p><p><br></p><p data-pasted="true"><strong><span style="font-size: 14pt;"><a id="The-Halo-Schema" class="fr-anchor" title="The-Halo-Schema"></a>The Halo Schema</span></strong></p><p>The Halo Schema can be found on our website, or using the following link <a target="_blank" rel="noopener noreferrer" data-fr-linked="true" href="https://www.usehalo.com/sqlschema" data-pasted="true">https://www.usehalo.com/sqlschema</a>.</p><p><br></p><p data-pasted="true"><span style="font-size: 14pt;"><strong><a id="Using-the-Schema" class="fr-anchor" title="Using-the-Schema"></a>Using the Schema</strong></span></p><p>The schema consists of tabs which can be found by clicking the Schema name shown below. </p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjcwZmU1ZTU0LTgwODktNDM0YS1hMDY0LWQ5NDRkODMzYWZmYiJ9._dCTBwnXa21ukELk-roSUjZJpGVapA8C83QBUivWDOo" class="fr-fic fr-fil fr-dib" width="1105" style="width: 1107px; height: 335.559px;" height="336"></p><p><br></p><p><strong><em>Note: The Advanced Schema is very large, and may struggle to load. All other schemas are far smaller and faster. </em></strong></p><p><br></p><p>Hovering over a line will highlight it in red, and clicking it will hold this red colour even when dragging around the page. You will need to click off the line to deselect it. </p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjBiOTFmNzQ3LTQ3MmItNGQ2NC1iNzM0LTY5OTAzNDg1NWI0ZiJ9.QFnRR3s0cktvgr7poWQZsSY2ikA__VKu0r89L3gm6h0" class="fr-fic fr-fil fr-dib" width="1100" style="width: 1102px; height: 513.425px;" height="513"></p><p><br></p><p>Clicking on the top of a table will highlight all the joins relevant to the table, again this will hold this red colour even when dragging around the page. You will need to click off the table to deselect it.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjVmNjA0OTFlLTQ5YzEtNDk4Mi04NTkwLWZkOTVjYmI3NzQ0OCJ9.7eLgOuPevpIZB1nhBAek6tv5wpvUo_Xsx9dg1pFFB-s" class="fr-fic fr-fil fr-dib" width="1092" style="width: 1094px; height: 458.353px;" height="458"></p><p><br></p><p>Clicking on a Column within the table, will highlight the row and any joins to the selected column. </p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImE5ZjQzMGU5LTYxN2MtNGQzZS1iYmViLTg5MzkxYTlhZGEwNCJ9.ISNAqs4LWrl_CgQWPaNIraTpGWqNC3_zGvuZ2-CqVQw" class="fr-fic fr-fil fr-dib" width="1093" style="width: 1095px; height: 451.675px;" height="452"></p><p><br></p><p>The search bar at the top allows you to search on the table name, column name, alias, and notes. </p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjYyMTBiOWY5LTg3ZTQtNGM0OC05ZWFkLWY1ZTczMmZmNjZmNSJ9.uFNKrIjQBbAQZHzykGOSHiNQ0ao_CbGWzHiu9jx1M4w" class="fr-fic fr-fil fr-dib" width="1092" style="width: 1094px; height: 475.732px;" height="476"></p><p><br></p><p>The JSON for each tab can be obtained by clicking the "Export JSON" button.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImM2NjFiMTI5LWJhMmMtNGRkOS1iOTYwLTA5Mzc5YzA4N2ZkNCJ9.UKiw4JeNJSeyF-9pqBV0w9EFxsPLg0FjAvz0SkAtMD8" class="fr-fic fr-fil fr-dib" width="1087" style="width: 1089px; height: 330.207px;" height="330"></p><p><br></p><p>The Key at the bottom right can be used to jump to a table. This can be dragged out from the corner to expand the section.</p><p><br></p><p><img src="https://halo.haloservicedesk.com/api/attachment/image?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjcwN2E0MzNkLWFjOTgtNDBmOS1hN2Y0LTUzNjZlYTcwY2ZjNyJ9.wmDX-p_oTx2-dD9ip3g3yHO9xUt3248bOuFRDF_SBgE" class="fr-fic fr-fil fr-dib" width="517" height="346"></p>
