Subsections

The Subsections table contains a list of all the different subsections, per single section. Every subsection must belong to a single section.

To determine which source that a subsection is from, retrieve the source of the section that the subsection belongs to, using section_id.

Columns

id

The unique identifier of the subsection.

TypeConstraints
integerPrimary Key

section_id

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

TypeConstraints
integerForeign Key (Sections.id),
Not Null

name_english

The name of the subsection, in English.

TypeConstraints
textNot Null

name_gurmukhi

The name of the subsection, in Gurmukhi, ASCII representation.

TypeConstraints
textNot Null

start_page

The physical "page" from the source that this subsection begins on.

TypeConstraints
integerNot Null

end_page

The physical "page" from the source that this subsection ends on.

TypeConstraints
integerNot Null