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.

TypeConstraints
integerPrimary Key

name_english#

The name of the translation source, in English.

TypeConstraints
textNot Null

name_gurmukhi#

The name of the translation source, in Gurmukhi, ASCII representation.

TypeConstraints
textNot Null

composition_id#

The unique identifier of the Gurbani composition that the translation source corresponds to.

TypeConstraints
integerForeign Key (Compositions.id),
Not Null

language_id#

The unique identifier of the language that the translation source is translated into.

TypeConstraints
integerForeign Key (Languages.id),
Not Null
Last updated on by Bhajneet S.K