Database Schema

Shabad OS Database was engineered to provide relational structures for better consistency and flexibility. This page lists an overview of all the tables.

Lines

Gurbani lines, linked to a Shabad (e.g. source_page: 10, Line_Content). (Read the docs)

Line_Content

Corresponding Gurmukhi related to the source of a line (e.g. SGPC: nmsqM mhMqy ]). (Read the docs)

Line_Types

List of possible line classifications (e.g. rahao). (Read the docs)

Shabads

Grouping of Gurbani Lines, with additional metadata (e.g. Writer, Section, Subsection, Lines). (Read the docs)

Writers

Composers of Shabads (e.g. Guru Angad Dev Ji). (Read the docs)

Compositions

A composition of Gurbani Shabads (e.g. Sri Guru Granth Sahib Ji). (Read the docs)

Sources

A source of Gurbani (e.g. SGPC). (Read the docs)

Sections

Grouping of Shabads within a single composition (e.g. Raag Gujri). (Read the docs)

Subsections

Sub-groupings within a single section (e.g. Mahalaa 1). (Read the docs)

Languages

Available translation languages (e.g. English). (Read the docs)

Transliterations

Transliterations for Gurbani Lines in a given Language and Source (e.g. SGPC: har har har gun gaavo). (Read the docs)

Translation_Sources

Translation source authors and languages for a single (Read the docs)

Translations

Translations for Gurbani Lines from a translation source (e.g. Language: English, Author: Sant Singh Khalsa). (Read the docs)

Banis

Named of available Banis (e.g. The Lord is One). (Read the docs)

Bani_Lines

Groupings of Lines to Banis (e.g. Jap Ji Sahib). (Read the docs)