DB Schema

Format for printing
Submitted by sabda on Mon, 2006-02-20 09:45.
  • 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]
  • 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]
  • 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]
  • MISC:
    • Includes four daily reading plans, etc...

Posted in DB Schema | 330 reads »