Sections

The Sections table contains a list of all the different sections, per composition. Every section must have a single composition.

Columns#

id#

The unique identifier of the section.

TypeConstraints
integerPrimary Key

name_english#

The name of the section, in English.

TypeConstraints
textNot Null

name_gurmukhi#

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

TypeConstraints
textNot Null

description#

The description of the section.

TypeConstraints
textNot Null

start_page#

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

TypeConstraints
integerNot Null

end_page#

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

TypeConstraints
integerNot Null

composition_id#

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

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