Lines

The Lines table contains all the Sikh bani and panthic content, across all sources.

Many lines must belong to one Shabad.

The content is unordered by default, and must be ordered by order_id. The id is a four-letter, immutable identifier that will refer to the same line across database versions.

Currently, the gurmukhi stores an ASCII representation of Gurbani. They may be converted to unicode with gurmukhi-utils.

Columns#

id#

A unique identifier for the line which never changes.

TypeConstraints
char(4)Primary Key

shabad_id#

A unique identifier of the Shabad to which the line belongs to.

TypeConstraints
char(3)Foreign Key (Shabads.id)
Not Null

source_page#

The physical "page" (e.g. ਅੰਗ) where the line appears within the source composition.

TypeConstraints
integerNot Null

source_line#

The physical "line" (i.e. of horizontal lines on "page", not of sentence count) where the line appears within the source composition.

TypeConstraints
integerNone

pronunciation#

Guidelines around pronouncing the Gurbani line stored in the gurmukhi field, correctly.

TypeConstraints
textNone

pronunciation_information#

Additional footnotes about the pronunciation guidelines.

TypeConstraints
textNone

first_letters#

The first letters of each word in the gurmukhi line, useful for searching the database by first letter.

TypeConstraints
textNot Null

vishraam_first_letters#

Same as first_letters, but includes heavy vishraams. Useful for prioritizing search results.

TypeConstraints
textNot Null

type_id#

The unique identifier of the line type.

TypeConstraints
integerForeign Key (Line_Types)

order_id#

The correct order of the line. Order by this field to fetch the lines in the correct order.

TypeConstraints
integerNone
Last updated on by Bhajneet S.K