Transliterations

The Transliterations table contains the corresponding transliteration of a single line in a given language and source.

caution

The transliteration can be nullable.

Columns#

line_id#

The unique identifier of the line that the transliteration corresponds with.

TypeConstraints
char(4)Primary Key,
Foreign Key (Lines.id)

source_id#

The unique identifier of the Source that the transliteration is of.

TypeConstraints
integerPrimary Key,
Foreign Key (Sources.id)

language_id#

The unique identifier of the Language that the transliteration is in.

TypeConstraints
integerPrimary Key,
Foreign Key (Languages.id)

transliteration#

The transliteration of the Gurbani line.

TypeConstraints
textNone

first_letters#

The first letters of each word in the transliteration, 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
Last updated on by Bhajneet S.K