Line_Content
The Line_Content table contains the content for Lines of Sources. This exists to support the different Sources of the same line.
Columns
line_id
The unique identifier of the line.
| Type | Constraints |
|---|---|
| char(4) | Primary Key, Foreign Key (Lines.id) |
source_id
The unique identifier of the source.
| Type | Constraints |
|---|---|
| integer | Primary, Foreign Key (Sources) Key |
gurmukhi
The line, stored as a compatible ASCII Gurmukhi font.
| Type | Constraints |
|---|---|
| text | Not Null |
first_letters
The first letters of each word in the gurmukhi line, useful for searching the database by first letter.
| Type | Constraints |
|---|---|
| text | Not Null |