Translation_Sources
The Translation_Sources table contains all the sources of translations that the database contains, used by the Translations.
A translation source is a combination of the Gurbani source, the language, and the author details.
To retrieve the actual Translations for a translation source, use the Translations table.
Columns
id
The unique identifier of the translation source.
| Type | Constraints |
|---|---|
| integer | Primary Key |
name_english
The name of the translation source, in English.
| Type | Constraints |
|---|---|
| text | Not Null |
name_gurmukhi
The name of the translation source, in Gurmukhi, ASCII representation.
| Type | Constraints |
|---|---|
| text | Not Null |
composition_id
The unique identifier of the Gurbani composition that the translation source corresponds to.
| Type | Constraints |
|---|---|
| integer | Foreign Key (Compositions.id), Not Null |
language_id
The unique identifier of the language that the translation source is translated into.
| Type | Constraints |
|---|---|
| integer | Foreign Key (Languages.id), Not Null |