Shabads

The Shabads table is used to group the Lines together, and provide additional metadata about those Lines.

Every Shabad must have a composition, writer, and section.

The content is unordered by default, and must be ordered by order_id.

The id is a three-letter, immutable identifier that will refer to the same Shabad across database versions.

Columns#

id#

A unique identifier for the Shabad. Permanent and will never change.

TypeConstraints
char(3)Primary Key

writer_id#

The unique identifier of the writer of the Shabad.

TypeConstraints
integerForeign Key (Writers.id),
Not Null

section_id#

The unique identifier of the section that the Shabad belongs to.

TypeConstraints
integerForeign Key (Sections.id),
Not Null

subsection_id#

The unique identifier of the subsection that the Shabad belongs to.

TypeConstraints
integerForeign Key (Subsections.id)

sttm_id#

The unique identifier of the equivalent Shabad within the SikhiToTheMax 2 database.

TypeConstraints
integerNone

composition_id#

The Gurbani composition that the Shabad belongs to.

TypeConstraints
integerForeign Key (Sources.id),
Not Null

order_id#

The correct order of Shabads. Order by this field to fetch shabads in the correct order.

TypeConstraints
integerNone
Last updated on by Bhajneet S.K