Line_Content
The Line_Content
table contains the content for Lines of Sources. This exists to support the different Sources of the same line.
#
Columnsline_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 |