Translations

The Translations table contains the corresponding translation of a single line from a translation source.

caution

The translation can be nullable.

If used, the additional_information is a serialized JSON string that must be deserialized with a JSON.parse() or equivalent, to support non-standard fields universally across different translation sources.

Columns#

line_id#

The unique identifier of the Gurbani line that the translation corresponds with.

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

translation_source_id#

The unique identifier of the translation source that the translation originates from.

TypeConstraints
integerPrimary Key,
Foreign Key (Translation_Sources.id)

translation#

The translation of the Gurbani line.

TypeConstraints
textNone

additional_information#

Any additional, non-standard data about the translation. Stored as a serialized JSON object.

TypeConstraints
text/jsonNone
Last updated on by Bhajneet S.K