Skip to content

Module Bible

Rodolfo Goulart edited this page Dec 30, 2023 · 25 revisions

The Bible Module Schema

class BibleVersion { int id; String? language; String versionName; String versionAbrev; String? copyright; bool? hasStrong; }

Table BibleVersion

Column Type Required Description Default Value
id int yes
language String no if not informed, deafalt = "pr-br" pt-br
versionName String yes Version name of the bible
versionAbrev String yes Version abreviation
copyright String no copyright informed of the bible
hasStrong bool no inform if this version has Strong Reference associated false

Table BibleVersionBooks

class BibleVersionBooks { int? id; int idBook; int idBibleVersion; int? sequence; int? numberChapters; String? nameTranslation; String? abrevTranslation; }

Column Type Required Description Default Value
id int yes
idBook int yes Id related to book
idBibleVersion int yes Id related to the bible version
sequence int no sequence of the book, to order when show the books of this version
numberChapters int no number of chapter that the book contain
nameTranslation String no Name used on translation, normaly the database contain the books of the protestant cannon
abrevTranslation String no Abreviation of the book

Table Book

class Book { //id need to be unique and a constant int id; //overwrite on [BibleVersionBooks] String name; //overwrite on [BibleVersionBooks] String abrev; Division division;

///the literary genre of the book String literaryGenre; String? cannon; }

Column Type Required Description Default Value
id int yes
name String yes Name of the book (English)
abrev String yes Abreviation of the book name
division String yes Division of the book [OT -> Old Testament, NT -> new Testament, A -> Apocryphal, O -> Other]
literaryGenre String yes Litetary Genre of the book empty value
cannon String no Cannon of the book "Protestant"

Table Verse

abstract class VerseCore { int id; int idBibleVersion; int idBook;

int numberChapter; int numberVerse;

///for some type of bible version that has verses jointed int? numberVerseEnd; List content;

String contentWithOutFormat; }

Column Type Required Description Default Value
id int yes
idBibleVersion int yes id of bible version
idBook int yes book id
numberChapter int yes number of the chapter
numberVerse int yes number of the verse
numberVerseEnd int yes if version contain joined verses, use this to set the number of the verse with is joined
content Json String value yes the content of the verse in his format (bold, break line, italic, Jesus words, ...), see Content
contentWithOutFormat String yes the verse without format
Clone this wiki locally