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.
| Type | Constraints |
|---|---|
| char(3) | Primary Key |
writer_id
The unique identifier of the writer of the Shabad.
| Type | Constraints |
|---|---|
| integer | Foreign Key (Writers.id), Not Null |
section_id
The unique identifier of the section that the Shabad belongs to.
| Type | Constraints |
|---|---|
| integer | Foreign Key (Sections.id), Not Null |
subsection_id
The unique identifier of the subsection that the Shabad belongs to.
| Type | Constraints |
|---|---|
| integer | Foreign Key (Subsections.id) |
sttm_id
The unique identifier of the equivalent Shabad within the SikhiToTheMax 2 database.
| Type | Constraints |
|---|---|
| integer | None |
composition_id
The Gurbani composition that the Shabad belongs to.
| Type | Constraints |
|---|---|
| integer | Foreign Key (Sources.id), Not Null |
order_id
The correct order of Shabads. Order by this field to fetch shabads in the correct order.
| Type | Constraints |
|---|---|
| integer | None |