DB Schema
- BIBLE TEXT:
- table:BIBLE -- Holds the bible text, formatted, unformatted, and titles.
[31102 records] - table:BIBLE_WORDS_IDX -- Reverse Indexes location of all unique bible words.
[16977 records] - table:BIBLE_WORDS -- Holds the verse and position of every bible word.
[752683 records] - table:BIBLE_BOOKS -- Holds the name of all 66 bible books.
[66 records] - table:LINE2VERSE -- Holds the 31102 Line# mappings for all Book Chap:Verses.
[31102 records]
- table:BIBLE -- Holds the bible text, formatted, unformatted, and titles.
- BIBLE NOTES:
- table:NOTES -- Holds the footnotes text, location, type, refs, etc.
[60918 records] - table:NOTES_WORDS_IDX -- Reverse Indexes the location of all unique footnote words.
[39489 records] - table:NOTES_EXIST -- Holds verse existance mapping for each existing note.
[xxx records]
- table:NOTES -- Holds the footnotes text, location, type, refs, etc.
- RESOURCES:
- table:EBD -- Holds the dictionary entries and definitions for EBD.
[3925 records] - table:ISBE -- Holds the dictionary entries and definitions for ISBE.
[9449 records] - table:SMITH -- Holds the dictionary entries and definitions for SMITH.
[4639 records] - table:ILLUS -- Holds the titles and entries for Sermon Illustrations.
[9159 records] - table:ILLUS_TOPIC -- Holds the topics and entries for Sermon Illustrations.
[9159 records] - table:NAVE -- Holds the dictionary entries and definitions for NAVE.
[6676 records]
- table:EBD -- Holds the dictionary entries and definitions for EBD.
- MISC:
- Includes four daily reading plans, etc...
