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.
| 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 |