Transliterations
The Transliterations
table contains the corresponding transliteration of a single line in a given language and source.
caution
The transliteration
can be nullable.
#
Columnsline_id
#
The unique identifier of the line that the transliteration corresponds with.
Type | Constraints |
---|---|
char(4) | Primary Key, Foreign Key (Lines.id) |
source_id
#
The unique identifier of the Source that the transliteration is of.
Type | Constraints |
---|---|
integer | Primary Key, Foreign Key (Sources.id) |
language_id
#
The unique identifier of the Language that the transliteration is in.
Type | Constraints |
---|---|
integer | Primary Key, Foreign Key (Languages.id) |
transliteration
#
The transliteration of the Gurbani line.
Type | Constraints |
---|---|
text | None |
first_letters
#
The first letters of each word in the transliteration
, useful for searching the database by first letter.
Type | Constraints |
---|---|
text | Not Null |
vishraam_first_letters
#
Same as first_letters
, but includes heavy vishraams. Useful for prioritizing search results.
Type | Constraints |
---|---|
text | Not Null |