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.
| Type | Constraints |
|---|---|
| integer | Primary Key |
name_english
The name of the section, in English.
| Type | Constraints |
|---|---|
| text | Not Null |
name_gurmukhi
The name of the section, in Gurmukhi, ASCII representation.
| Type | Constraints |
|---|---|
| text | Not Null |
description
The description of the section.
| Type | Constraints |
|---|---|
| text | Not Null |
start_page
The physical "page" from the source that this section begins on.
| Type | Constraints |
|---|---|
| integer | Not Null |
end_page
The physical "page" from the source that this section ends on.
| Type | Constraints |
|---|---|
| integer | Not Null |
composition_id
The unique identifier of the composition that this section belongs to.
| Type | Constraints |
|---|---|
| integer | Foreign Key (Compositions.id), Not Null |