Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What's the best way to store the bible in SQL?

What I'm looking for is a breakdown of table names w/ corresponding fields/types.

The bible I want to store will be in English and needs to support the following:

  • Books
  • Chapters
  • Section Titles (can show up within verses and in-between verses)
  • Smallcaps Text
  • Red Letter Text
  • Verse Numbers
  • Footnotes (can show up within verses and within section titles) (may optionally reference another verse)
  • Cross-references (essentially a footnote that only references another verse and doesn't add any commentary)
  • Anything else I'm forgetting
like image 360
John Kurlak Avatar asked Jan 14 '11 04:01

John Kurlak


1 Answers

Here is another collection / example for you:

https://github.com/scrollmapper/bible_databases

Here you will see SQL, XML, CSV, and JSON. Of special note is the cross-reference table (quite extensive and amazing) and a simple verse-id system for fast queries.

EDIT: Notice the ids of the tables are book-chapter-verse combinations, always unique.

like image 82
Orangeman555 Avatar answered Sep 18 '22 05:09

Orangeman555